PREVIEW / etf_1hour / 2020-06-09

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-09.parquet
  size:    380 KB
  rows:    13,065

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
2020-06-09 04:00:00	SPY	ETF	321.14	321.37	319.33	319.67	147807.0
2020-06-09 05:00:00	SPY	ETF	319.82	320.49	319.54	319.71	182815.0
2020-06-09 06:00:00	SPY	ETF	319.77	320.35	319.34	320.25	243928.0
2020-06-09 07:00:00	SPY	ETF	320.27	320.86	319.9	320.52	615148.0
2020-06-09 08:00:00	SPY	ETF	320.51	323.24	319.4704	319.97	868004.0
2020-06-09 09:00:00	SPY	ETF	319.95	320.76	319.655	319.76	7788312.0
2020-06-09 10:00:00	SPY	ETF	319.79	321.69	319.36	321.37	12070339.0
2020-06-09 11:00:00	SPY	ETF	321.365	323.2849	320.47	320.62	8057527.0
2020-06-09 12:00:00	SPY	ETF	320.63	321.449	320.16	321.415	5415496.0
2020-06-09 13:00:00	SPY	ETF	321.41	322.22	321.26	321.97	5728427.0
2020-06-09 14:00:00	SPY	ETF	321.97	322.08	320.95	321.71	8604190.0
2020-06-09 15:00:00	SPY	ETF	321.7	322.365	320.48	320.81	20327603.0
2020-06-09 16:00:00	SPY	ETF	320.83	321.41	320.44	320.75	6600961.0
2020-06-09 17:00:00	SPY	ETF	320.75	320.86	320.63	320.78	102944.0
2020-06-09 18:00:00	SPY	ETF	320.75	321.54	320.75	321.43	142458.0
2020-06-09 19:00:00	SPY	ETF	321.4	321.95	320.96	321.92	160719.0
2020-06-09 04:00:00	QQQ	ETF	240.91	240.91	239.62	239.74	86291.0
2020-06-09 05:00:00	QQQ	ETF	239.83	240.18	239.76	239.88	25407.0
2020-06-09 06:00:00	QQQ	ETF	239.91	240.23	239.55	240.19	136468.0
2020-06-09 07:00:00	QQQ	ETF	240.25	240.37	239.78	240.33	159849.0
2020-06-09 08:00:00	QQQ	ETF	240.3301	241.64	239.62	240.6	248450.0
2020-06-09 09:00:00	QQQ	ETF	240.66	241.88	240.35	241.51	3689381.0
2020-06-09 10:00:00	QQQ	ETF	241.54	243.23	241.02	243.18	5740393.0
2020-06-09 11:00:00	QQQ	ETF	243.1788	243.42	242.66	242.81	4667059.0
2020-06-09 12:00:00	QQQ	ETF	242.81	243.745	242.55	243.5499	2735414.0
2020-06-09 13:00:00	QQQ	ETF	243.5375	244.18	243.3	244.015	2686320.0
2020-06-09 14:00:00	QQQ	ETF	244.0161	244.15	243.105	243.71	3669858.0
2020-06-09 15:00:00	QQQ	ETF	243.71	244.18	242.8154	243.2	5754875.0
2020-06-09 16:00:00	QQQ	ETF	243.21	243.48	242.51	243.03	749518.0
2020-06-09 17:00:00	QQQ	ETF	243.09	243.3	242.9	243.18	207453.0
2020-06-09 18:00:00	QQQ	ETF	243.18	243.68	243.14	243.6	51839.0
2020-06-09 19:00:00	QQQ	ETF	243.61	243.86	243.32	243.83	111069.0
2020-06-09 04:00:00	IWM	ETF	151.74	151.81	149.48	149.88	99219.0
2020-06-09 05:00:00	IWM	ETF	149.98	150.65	149.72	149.81	106189.0
2020-06-09 06:00:00	IWM	ETF	149.92	150.15	149.24	150.13	83128.0
2020-06-09 07:00:00	IWM	ETF	150.11	151.05	150.1	150.8	258598.0
2020-06-09 08:00:00	IWM	ETF	149.8404	153.1	149.8404	150.7	507283.0
2020-06-09 09:00:00	IWM	ETF	150.66	151.4	150.05	150.3	4609922.0
2020-06-09 10:00:00	IWM	ETF	150.33	150.66	149.06	150.19	8038148.0
2020-06-09 11:00:00	IWM	ETF	150.18	150.32	149.4	149.81	3148086.0
2020-06-09 12:00:00	IWM	ETF	149.8	150.39	149.6	150.25	1986517.0
2020-06-09 13:00:00	IWM	ETF	150.25	151.69	150.22	151.365	3011933.0
2020-06-09 14:00:00	IWM	ETF	151.38	151.48	150.56	151.13	2477643.0
2020-06-09 15:00:00	IWM	ETF	151.12	151.77	150.01	150.32	7031745.0
2020-06-09 16:00:00	IWM	ETF	150.36	150.66	150.0	150.24	1937105.0
2020-06-09 17:00:00	IWM	ETF	150.2	150.26	150.03	150.07	100502.0
2020-06-09 18:00:00	IWM	ETF	150.14	150.63	150.14	150.54	80845.0
2020-06-09 19:00:00	IWM	ETF	150.52	151.08	150.26	151.01	75884.0
2020-06-09 04:00:00	DIA	ETF	275.0	275.0	272.13	272.67	42280.0
2020-06-09 05:00:00	DIA	ETF	272.77	273.16	272.58	272.65	5365.0

> showing 50 of 13,065 rows — these rows as CSV

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