PREVIEW / etf_1hour / 2021-07-23

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-23.parquet
  size:    415 KB
  rows:    14,409

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-07-23 04:00:00	SPY	ETF	437.22	437.37	437.07	437.3	63925.0
2021-07-23 05:00:00	SPY	ETF	437.27	437.65	437.25	437.61	11650.0
2021-07-23 06:00:00	SPY	ETF	437.47	437.63	437.43	437.57	39529.0
2021-07-23 07:00:00	SPY	ETF	437.57	437.59	437.15	437.4	102020.0
2021-07-23 08:00:00	SPY	ETF	437.5699	438.0	437.0	437.33	224891.0
2021-07-23 09:00:00	SPY	ETF	437.32	437.65	436.79	436.98	5765489.0
2021-07-23 10:00:00	SPY	ETF	436.975	438.38	436.95	438.3099	6804223.0
2021-07-23 11:00:00	SPY	ETF	438.3	439.5	438.27	438.73	7214478.0
2021-07-23 12:00:00	SPY	ETF	438.74	439.375	438.71	439.351	4002184.0
2021-07-23 13:00:00	SPY	ETF	439.36	440.04	439.3499	439.77	4203827.0
2021-07-23 14:00:00	SPY	ETF	439.765	440.0	439.58	439.74	4129696.0
2021-07-23 15:00:00	SPY	ETF	439.74	440.3	439.16	439.89	10888723.0
2021-07-23 16:00:00	SPY	ETF	439.89	439.94	439.36	439.39	3063697.0
2021-07-23 17:00:00	SPY	ETF	439.4401	439.65	439.22	439.25	61161.0
2021-07-23 18:00:00	SPY	ETF	439.3	439.94	439.25	439.32	12189.0
2021-07-23 19:00:00	SPY	ETF	439.31	439.37	439.2	439.26	12973.0
2021-07-23 04:00:00	QQQ	ETF	365.47	365.84	365.42	365.55	35630.0
2021-07-23 05:00:00	QQQ	ETF	365.65	366.0	365.65	365.78	18499.0
2021-07-23 06:00:00	QQQ	ETF	365.76	365.78	365.6	365.63	17532.0
2021-07-23 07:00:00	QQQ	ETF	365.67	365.71	365.05	365.21	101555.0
2021-07-23 08:00:00	QQQ	ETF	365.69	365.7596	364.93	364.99	174403.0
2021-07-23 09:00:00	QQQ	ETF	364.9699	365.5	364.04	365.08	3219973.0
2021-07-23 10:00:00	QQQ	ETF	365.08	366.12	364.95	366.01	3344816.0
2021-07-23 11:00:00	QQQ	ETF	366.02	367.585	365.82	367.32	3091238.0
2021-07-23 12:00:00	QQQ	ETF	367.33	367.6796	367.06	367.65	1973251.0
2021-07-23 13:00:00	QQQ	ETF	367.67	368.45	367.5199	368.0	2409605.0
2021-07-23 14:00:00	QQQ	ETF	368.0025	368.38	367.93	368.09	1695692.0
2021-07-23 15:00:00	QQQ	ETF	368.11	368.485	367.64	368.07	5865980.0
2021-07-23 16:00:00	QQQ	ETF	368.06	368.2	367.79	367.9	1102179.0
2021-07-23 17:00:00	QQQ	ETF	367.85	367.9	367.73	367.73	31872.0
2021-07-23 18:00:00	QQQ	ETF	367.8	367.85	367.75	367.84	10443.0
2021-07-23 19:00:00	QQQ	ETF	367.84	367.97	367.77	367.84	12124.0
2021-07-23 04:00:00	IWM	ETF	219.77	219.94	219.65	219.73	15503.0
2021-07-23 05:00:00	IWM	ETF	219.92	220.19	219.92	220.03	10603.0
2021-07-23 06:00:00	IWM	ETF	220.02	220.02	219.91	219.91	3164.0
2021-07-23 07:00:00	IWM	ETF	220.06	220.15	219.81	220.14	82991.0
2021-07-23 08:00:00	IWM	ETF	219.9899	220.36	219.84	219.91	92742.0
2021-07-23 09:00:00	IWM	ETF	219.88	219.95	217.645	217.795	3324985.0
2021-07-23 10:00:00	IWM	ETF	217.8	218.585	216.91	218.43	4494733.0
2021-07-23 11:00:00	IWM	ETF	218.41	219.2	218.12	218.159	2523197.0
2021-07-23 12:00:00	IWM	ETF	218.16	218.94	217.94	218.6676	2137660.0
2021-07-23 13:00:00	IWM	ETF	218.65	219.26	218.4	219.25	1104697.0
2021-07-23 14:00:00	IWM	ETF	219.2397	219.56	218.91	219.16	1491374.0
2021-07-23 15:00:00	IWM	ETF	219.17	219.71	218.9201	219.5	3308275.0
2021-07-23 16:00:00	IWM	ETF	219.55	219.6	218.95	219.01	1351414.0
2021-07-23 17:00:00	IWM	ETF	218.8	219.18	218.8	219.0	13484.0
2021-07-23 18:00:00	IWM	ETF	218.99	218.99	218.8	218.8	14029.0
2021-07-23 19:00:00	IWM	ETF	218.88	218.92	218.14	218.76	13196.0
2021-07-23 04:00:00	DIA	ETF	349.32	349.41	349.18	349.41	1500.0
2021-07-23 06:00:00	DIA	ETF	349.9	349.9	349.85	349.85	600.0

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

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