PREVIEW / etf_1hour / 2020-06-05

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-05.parquet
  size:    393 KB
  rows:    13,511

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-05 04:00:00	SPY	ETF	314.69	314.8	313.71	314.13	78808.0
2020-06-05 05:00:00	SPY	ETF	314.22	314.42	313.42	313.87	78039.0
2020-06-05 06:00:00	SPY	ETF	313.8	313.82	313.17	313.57	92851.0
2020-06-05 07:00:00	SPY	ETF	313.58	314.08	313.57	313.915	320179.0
2020-06-05 08:00:00	SPY	ETF	313.87	316.74	312.72	316.3	4414441.0
2020-06-05 09:00:00	SPY	ETF	316.31	318.65	316.16	317.65	16348269.0
2020-06-05 10:00:00	SPY	ETF	317.64	319.19	317.495	319.154	15231952.0
2020-06-05 11:00:00	SPY	ETF	319.17	321.275	319.07	320.32	20900332.0
2020-06-05 12:00:00	SPY	ETF	320.32	320.45	319.22	320.13	11227498.0
2020-06-05 13:00:00	SPY	ETF	320.13	320.74	319.68	320.07	8738990.0
2020-06-05 14:00:00	SPY	ETF	320.07	320.61	319.3	319.7	17035194.0
2020-06-05 15:00:00	SPY	ETF	319.7	320.14	318.37	319.27	35088411.0
2020-06-05 16:00:00	SPY	ETF	319.24	319.59	318.8	318.85	18917217.0
2020-06-05 17:00:00	SPY	ETF	318.81	319.34	318.81	318.92	235697.0
2020-06-05 18:00:00	SPY	ETF	318.92	318.98	318.8	318.9	146433.0
2020-06-05 19:00:00	SPY	ETF	318.86	319.26	318.85	319.15	68669.0
2020-06-05 04:00:00	QQQ	ETF	236.71	236.74	235.87	236.13	36432.0
2020-06-05 05:00:00	QQQ	ETF	236.19	236.3	235.74	235.92	14756.0
2020-06-05 06:00:00	QQQ	ETF	235.74	235.77	235.48	235.62	45250.0
2020-06-05 07:00:00	QQQ	ETF	235.68	235.96	235.44	235.44	217804.0
2020-06-05 08:00:00	QQQ	ETF	235.43	236.75	234.4	235.37	1357908.0
2020-06-05 09:00:00	QQQ	ETF	235.44	240.0	235.41	238.12	7640189.0
2020-06-05 10:00:00	QQQ	ETF	238.13	238.85	237.64	238.65	5619751.0
2020-06-05 11:00:00	QQQ	ETF	238.65	239.82	238.56	239.44	4978538.0
2020-06-05 12:00:00	QQQ	ETF	239.44	240.17	239.28	239.92	3875432.0
2020-06-05 13:00:00	QQQ	ETF	239.9112	240.297	239.41	239.585	4645311.0
2020-06-05 14:00:00	QQQ	ETF	239.58	240.27	239.28	239.72	4520196.0
2020-06-05 15:00:00	QQQ	ETF	239.725	240.285	238.94	239.6	7417970.0
2020-06-05 16:00:00	QQQ	ETF	239.6	239.69	234.978	239.37	966469.0
2020-06-05 17:00:00	QQQ	ETF	239.49	239.69	239.37	239.49	11801.0
2020-06-05 18:00:00	QQQ	ETF	239.45	239.52	239.26	239.4	16615.0
2020-06-05 19:00:00	QQQ	ETF	239.36	239.58	239.3	239.58	9920.0
2020-06-05 04:00:00	IWM	ETF	148.21	148.21	146.94	147.2	49417.0
2020-06-05 05:00:00	IWM	ETF	147.11	147.28	146.25	146.59	76665.0
2020-06-05 06:00:00	IWM	ETF	146.49	146.82	145.97	146.62	115201.0
2020-06-05 07:00:00	IWM	ETF	146.61	147.18	146.61	146.97	127828.0
2020-06-05 08:00:00	IWM	ETF	147.0699	150.75	146.36	150.32	1623292.0
2020-06-05 09:00:00	IWM	ETF	150.33	151.92	149.55	149.76	6966600.0
2020-06-05 10:00:00	IWM	ETF	149.7698	151.7	149.74	151.68	8490481.0
2020-06-05 11:00:00	IWM	ETF	151.665	152.315	151.46	152.025	4990227.0
2020-06-05 12:00:00	IWM	ETF	152.03	152.14	151.03	151.4	2701032.0
2020-06-05 13:00:00	IWM	ETF	151.4	152.0	151.0854	151.72	3091128.0
2020-06-05 14:00:00	IWM	ETF	151.71	152.08	151.27	151.37	6152368.0
2020-06-05 15:00:00	IWM	ETF	151.38	151.5	149.72	150.17	9099955.0
2020-06-05 16:00:00	IWM	ETF	150.18	154.1944	149.73	149.78	1747974.0
2020-06-05 17:00:00	IWM	ETF	149.7	150.18	149.7	149.95	93376.0
2020-06-05 18:00:00	IWM	ETF	149.8	149.98	149.8	149.98	7546.0
2020-06-05 19:00:00	IWM	ETF	150.12	150.2	150.03	150.2	14854.0
2020-06-05 04:00:00	DIA	ETF	266.98	267.14	266.43	266.48	8541.0
2020-06-05 05:00:00	DIA	ETF	266.6	266.99	266.12	266.28	1820.0

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

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