PREVIEW / etf_1hour / 2021-05-20

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-20.parquet
  size:    404 KB
  rows:    14,111

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
2021-05-20 04:00:00	SPY	ETF	410.48	410.59	408.9	409.03	37977.0
2021-05-20 05:00:00	SPY	ETF	408.93	409.2	408.28	408.82	97578.0
2021-05-20 06:00:00	SPY	ETF	408.8	409.47	408.55	409.47	47026.0
2021-05-20 07:00:00	SPY	ETF	409.48	410.31	409.44	410.18	168143.0
2021-05-20 08:00:00	SPY	ETF	409.61	411.25	408.7996	411.24	416228.0
2021-05-20 09:00:00	SPY	ETF	411.29	413.26	411.2	413.09	7412292.0
2021-05-20 10:00:00	SPY	ETF	413.09	414.18	412.965	413.97	8050553.0
2021-05-20 11:00:00	SPY	ETF	413.98	416.14	413.97	415.56	7139643.0
2021-05-20 12:00:00	SPY	ETF	415.56	415.6	414.1	414.8311	6994080.0
2021-05-20 13:00:00	SPY	ETF	414.83	415.5499	414.57	415.12	4269233.0
2021-05-20 14:00:00	SPY	ETF	415.13	415.85	415.09	415.59	4978887.0
2021-05-20 15:00:00	SPY	ETF	415.59	416.625	414.92	415.25	19584402.0
2021-05-20 16:00:00	SPY	ETF	415.24	415.43	414.79	414.99	3873738.0
2021-05-20 17:00:00	SPY	ETF	414.95	415.05	410.8845	414.96	185851.0
2021-05-20 18:00:00	SPY	ETF	414.95	415.4	414.88	415.3	258880.0
2021-05-20 19:00:00	SPY	ETF	415.28	415.85	415.23	415.83	49567.0
2021-05-20 04:00:00	QQQ	ETF	322.82	322.95	321.23	321.46	72438.0
2021-05-20 05:00:00	QQQ	ETF	321.46	321.66	320.75	321.19	67290.0
2021-05-20 06:00:00	QQQ	ETF	321.05	321.75	321.0	321.73	42830.0
2021-05-20 07:00:00	QQQ	ETF	321.8	322.86	321.71	322.61	198527.0
2021-05-20 08:00:00	QQQ	ETF	322.63	323.81	321.2996	323.79	414438.0
2021-05-20 09:00:00	QQQ	ETF	323.9	326.72	323.79	326.37	6345728.0
2021-05-20 10:00:00	QQQ	ETF	326.38	327.88	326.3	327.51	5943366.0
2021-05-20 11:00:00	QQQ	ETF	327.52	329.26	327.33	328.88	4693349.0
2021-05-20 12:00:00	QQQ	ETF	328.895	328.91	327.805	328.36	5025010.0
2021-05-20 13:00:00	QQQ	ETF	328.35	329.105	328.13	328.66	2789116.0
2021-05-20 14:00:00	QQQ	ETF	328.69	329.44	328.4487	329.27	2927611.0
2021-05-20 15:00:00	QQQ	ETF	329.29	329.71	328.72	328.87	7771753.0
2021-05-20 16:00:00	QQQ	ETF	328.88	329.3	328.7	328.9	2039204.0
2021-05-20 17:00:00	QQQ	ETF	328.83	329.0	328.82	328.95	20724.0
2021-05-20 18:00:00	QQQ	ETF	328.95	329.22	328.88	329.08	28508.0
2021-05-20 19:00:00	QQQ	ETF	329.14	329.66	329.05	329.66	85543.0
2021-05-20 04:00:00	IWM	ETF	217.55	217.55	216.28	216.39	16607.0
2021-05-20 05:00:00	IWM	ETF	216.59	216.71	215.85	216.31	6660.0
2021-05-20 06:00:00	IWM	ETF	216.26	216.99	216.26	216.99	10650.0
2021-05-20 07:00:00	IWM	ETF	217.02	217.54	217.0	217.389	107108.0
2021-05-20 08:00:00	IWM	ETF	217.39	218.28	217.26	218.28	156178.0
2021-05-20 09:00:00	IWM	ETF	218.29	218.48	216.33	217.68	4155484.0
2021-05-20 10:00:00	IWM	ETF	217.73	218.74	217.37	217.96	3061276.0
2021-05-20 11:00:00	IWM	ETF	217.9505	218.95	217.9505	218.77	2485305.0
2021-05-20 12:00:00	IWM	ETF	218.77	218.79	217.3	217.759	2965345.0
2021-05-20 13:00:00	IWM	ETF	217.75	218.39	217.54	217.84	1422291.0
2021-05-20 14:00:00	IWM	ETF	217.83	218.42	217.67	218.38	1440352.0
2021-05-20 15:00:00	IWM	ETF	218.385	219.87	218.0	219.4	4182188.0
2021-05-20 16:00:00	IWM	ETF	219.4	219.42	218.79	219.05	1009064.0
2021-05-20 17:00:00	IWM	ETF	219.0	219.21	218.9	219.05	44468.0
2021-05-20 18:00:00	IWM	ETF	219.08	219.55	219.05	219.41	50632.0
2021-05-20 19:00:00	IWM	ETF	219.43	219.81	219.36	219.81	34056.0
2021-05-20 04:00:00	DIA	ETF	338.93	338.93	337.78	337.78	733.0
2021-05-20 05:00:00	DIA	ETF	337.7	337.87	337.18	337.64	3360.0

> showing 50 of 14,111 rows — these rows as CSV

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