PREVIEW / etf_1hour / 2019-09-27

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-27.parquet
  size:    331 KB
  rows:    10,876

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
2019-09-27 04:00:00	SPY	ETF	297.24	297.87	297.24	297.79	18604.0
2019-09-27 05:00:00	SPY	ETF	297.65	297.87	297.54	297.8	8832.0
2019-09-27 06:00:00	SPY	ETF	297.75	298.28	297.6	298.05	35264.0
2019-09-27 07:00:00	SPY	ETF	298.05	298.07	297.85	297.9	113811.0
2019-09-27 08:00:00	SPY	ETF	297.9	298.07	296.75	297.81	309920.0
2019-09-27 09:00:00	SPY	ETF	297.77	297.9465	296.7	296.89	5083341.0
2019-09-27 10:00:00	SPY	ETF	296.88	297.69	296.32	297.6	5987026.0
2019-09-27 11:00:00	SPY	ETF	297.6	297.715	295.28	296.64	12578252.0
2019-09-27 12:00:00	SPY	ETF	296.63	296.72	294.91	294.91	7478436.0
2019-09-27 13:00:00	SPY	ETF	294.91	295.66	294.65	295.23	7430401.0
2019-09-27 14:00:00	SPY	ETF	295.23	295.26	293.69	293.98	8317667.0
2019-09-27 15:00:00	SPY	ETF	293.97	295.46	293.82	295.36	21391504.0
2019-09-27 16:00:00	SPY	ETF	295.37	295.97	295.3166	295.9	14537841.0
2019-09-27 17:00:00	SPY	ETF	295.9	296.8958	295.313	295.75	286089.0
2019-09-27 18:00:00	SPY	ETF	295.81	295.85	295.75	295.78	14228.0
2019-09-27 19:00:00	SPY	ETF	295.78	295.86	295.78	295.83	21876.0
2019-09-27 04:00:00	QQQ	ETF	189.42	189.6	189.37	189.58	9642.0
2019-09-27 05:00:00	QQQ	ETF	189.54	189.71	189.51	189.66	8620.0
2019-09-27 06:00:00	QQQ	ETF	189.58	190.05	189.58	189.79	23180.0
2019-09-27 07:00:00	QQQ	ETF	189.89	189.89	189.64	189.69	42509.0
2019-09-27 08:00:00	QQQ	ETF	189.81	189.87	188.7	189.65	140599.0
2019-09-27 09:00:00	QQQ	ETF	189.66	189.83	188.46	188.63	3071911.0
2019-09-27 10:00:00	QQQ	ETF	188.62	189.29	188.21	189.23	3095382.0
2019-09-27 11:00:00	QQQ	ETF	189.23	189.43	187.37	188.57	5519341.0
2019-09-27 12:00:00	QQQ	ETF	188.56	188.69	186.94	186.94	3332907.0
2019-09-27 13:00:00	QQQ	ETF	186.9321	187.46	186.68	187.165	3672058.0
2019-09-27 14:00:00	QQQ	ETF	187.165	187.19	185.75	186.02	6786014.0
2019-09-27 15:00:00	QQQ	ETF	186.02	187.22	185.97	187.14	7349553.0
2019-09-27 16:00:00	QQQ	ETF	187.14	187.58	187.03	187.57	1717525.0
2019-09-27 17:00:00	QQQ	ETF	187.55	187.56	187.28	187.28	15714.0
2019-09-27 18:00:00	QQQ	ETF	187.34	187.41	187.3	187.31	16931.0
2019-09-27 19:00:00	QQQ	ETF	187.3	187.38	187.26	187.34	13915.0
2019-09-27 04:00:00	IWM	ETF	152.74	152.9	152.74	152.9	4000.0
2019-09-27 05:00:00	IWM	ETF	152.81	152.88	152.81	152.88	3400.0
2019-09-27 06:00:00	IWM	ETF	152.9	153.16	152.8	153.03	21155.0
2019-09-27 07:00:00	IWM	ETF	153.08	153.1	152.96	153.0	17100.0
2019-09-27 08:00:00	IWM	ETF	153.08	153.08	152.83	152.88	12446.0
2019-09-27 09:00:00	IWM	ETF	152.95	153.22	152.32	152.4762	1777912.0
2019-09-27 10:00:00	IWM	ETF	152.47	153.12	152.16	153.07	2128799.0
2019-09-27 11:00:00	IWM	ETF	153.08	153.17	151.48	152.42	2876902.0
2019-09-27 12:00:00	IWM	ETF	152.4	152.5	151.07	151.105	1867991.0
2019-09-27 13:00:00	IWM	ETF	151.105	151.7	150.99	151.63	1391830.0
2019-09-27 14:00:00	IWM	ETF	151.64	151.65	150.5	150.65	1852811.0
2019-09-27 15:00:00	IWM	ETF	150.64	151.26	150.5	151.18	3629854.0
2019-09-27 16:00:00	IWM	ETF	151.16	153.2794	150.726	151.37	1503567.0
2019-09-27 17:00:00	IWM	ETF	151.75	151.75	151.16	151.21	77242.0
2019-09-27 18:00:00	IWM	ETF	151.23	151.32	151.23	151.32	390.0
2019-09-27 19:00:00	IWM	ETF	151.26	151.35	151.21	151.35	900.0
2019-09-27 04:00:00	DIA	ETF	269.4	269.54	269.4	269.54	200.0
2019-09-27 08:00:00	DIA	ETF	269.7	269.75	269.48	269.55	9600.0

> showing 50 of 10,876 rows — these rows as CSV

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