PREVIEW / etf_1hour / 2018-03-27

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-27.parquet
  size:    303 KB
  rows:    9,911

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2018-03-27 04:00:00	SPY	ETF	266.36	266.7	266.1	266.57	40599.0
2018-03-27 05:00:00	SPY	ETF	266.66	267.1	266.61	267.1	32986.0
2018-03-27 06:00:00	SPY	ETF	267.05	267.08	266.39	266.39	50876.0
2018-03-27 07:00:00	SPY	ETF	266.39	266.77	266.34	266.47	281589.0
2018-03-27 08:00:00	SPY	ETF	266.49	266.94	265.86	265.88	1162802.0
2018-03-27 09:00:00	SPY	ETF	265.88	266.21	264.79	265.63	8394850.0
2018-03-27 10:00:00	SPY	ETF	265.63	266.02	264.47	265.13	12374623.0
2018-03-27 11:00:00	SPY	ETF	265.14	266.71	264.64	266.55	11962008.0
2018-03-27 12:00:00	SPY	ETF	266.56	266.77	265.3	265.91	9788386.0
2018-03-27 13:00:00	SPY	ETF	265.91	266.5	264.18	264.83	10318544.0
2018-03-27 14:00:00	SPY	ETF	264.83	265.11	262.93	263.04	14070741.0
2018-03-27 15:00:00	SPY	ETF	263.04	263.12	258.84	260.53	46668380.0
2018-03-27 16:00:00	SPY	ETF	260.53	265.1259	260.3	260.4	10439250.0
2018-03-27 17:00:00	SPY	ETF	260.54	260.6	260.13	260.42	400758.0
2018-03-27 18:00:00	SPY	ETF	260.42	260.69	260.09	260.64	270895.0
2018-03-27 19:00:00	SPY	ETF	260.69	260.9	260.24	260.83	347853.0
2018-03-27 04:00:00	QQQ	ETF	165.71	165.93	165.53	165.9	55180.0
2018-03-27 05:00:00	QQQ	ETF	165.85	166.3	165.81	166.26	28536.0
2018-03-27 06:00:00	QQQ	ETF	166.27	166.27	165.74	165.81	38174.0
2018-03-27 07:00:00	QQQ	ETF	165.78	166.13	158.978	165.87	373857.0
2018-03-27 08:00:00	QQQ	ETF	165.89	166.07	165.45	165.5	522934.0
2018-03-27 09:00:00	QQQ	ETF	165.49	165.62	158.978	165.15	5569836.0
2018-03-27 10:00:00	QQQ	ETF	165.16	165.42	164.15	164.3	6097624.0
2018-03-27 11:00:00	QQQ	ETF	164.29	165.21	163.88	164.88	3874681.0
2018-03-27 12:00:00	QQQ	ETF	164.89	165.02	163.21	163.8	4392055.0
2018-03-27 13:00:00	QQQ	ETF	163.82	164.14	162.18	162.6	5211324.0
2018-03-27 14:00:00	QQQ	ETF	162.61	162.61	160.8707	160.95	8980187.0
2018-03-27 15:00:00	QQQ	ETF	160.96	161.01	157.68	158.99	23765140.0
2018-03-27 16:00:00	QQQ	ETF	159.0	161.38	158.9558	159.19	5665657.0
2018-03-27 17:00:00	QQQ	ETF	159.11	159.21	159.02	159.21	1646502.0
2018-03-27 18:00:00	QQQ	ETF	159.21	159.22	158.72	159.18	112314.0
2018-03-27 19:00:00	QQQ	ETF	159.12	159.22	158.83	159.19	82421.0
2018-03-27 04:00:00	IWM	ETF	153.8	154.0	153.75	154.0	1110.0
2018-03-27 05:00:00	IWM	ETF	154.24	154.32	154.24	154.32	7400.0
2018-03-27 06:00:00	IWM	ETF	154.15	154.15	153.89	153.95	758.0
2018-03-27 07:00:00	IWM	ETF	154.0	154.09	153.79	153.82	17872.0
2018-03-27 08:00:00	IWM	ETF	153.75	153.8	153.43	153.46	40118.0
2018-03-27 09:00:00	IWM	ETF	153.48	153.7	152.55	153.1299	2222508.0
2018-03-27 10:00:00	IWM	ETF	153.12	153.505	152.46	152.67	3760227.0
2018-03-27 11:00:00	IWM	ETF	152.68	153.455	152.22	153.24	2661742.0
2018-03-27 12:00:00	IWM	ETF	153.24	153.31	152.465	152.9	2037519.0
2018-03-27 13:00:00	IWM	ETF	152.9	153.43	152.04	152.42	1863414.0
2018-03-27 14:00:00	IWM	ETF	152.4	152.465	151.535	151.57	2361923.0
2018-03-27 15:00:00	IWM	ETF	151.58	151.6	149.71	150.36	7134518.0
2018-03-27 16:00:00	IWM	ETF	150.38	151.32	150.22	150.43	1246480.0
2018-03-27 17:00:00	IWM	ETF	150.44	150.44	150.2	150.32	96236.0
2018-03-27 18:00:00	IWM	ETF	150.36	150.47	150.05	150.22	79266.0
2018-03-27 19:00:00	IWM	ETF	150.18	150.35	150.18	150.27	5853.0
2018-03-27 04:00:00	DIA	ETF	243.0	243.0	243.0	243.0	350.0
2018-03-27 05:00:00	DIA	ETF	243.5	243.5	243.5	243.5	100.0

> showing 50 of 9,911 rows — these rows as CSV

> unlock the full archive -- $79 one-time