PREVIEW / etf_1hour / 2022-05-04

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-04.parquet
  size:    456 KB
  rows:    16,630

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
2022-05-04 04:00:00	SPY	ETF	417.36	417.62	417.11	417.58	15404.0
2022-05-04 05:00:00	SPY	ETF	417.28	418.0	416.93	418.0	19396.0
2022-05-04 06:00:00	SPY	ETF	418.15	418.19	417.77	417.93	42161.0
2022-05-04 07:00:00	SPY	ETF	417.88	418.45	417.66	417.85	239952.0
2022-05-04 08:00:00	SPY	ETF	417.9	418.42	416.75	417.15	319365.0
2022-05-04 09:00:00	SPY	ETF	417.1	417.47	416.02	416.0319	6922407.0
2022-05-04 10:00:00	SPY	ETF	416.045	416.16	414.25	415.06	9308837.0
2022-05-04 11:00:00	SPY	ETF	415.07	415.75	413.7099	415.225	6045109.0
2022-05-04 12:00:00	SPY	ETF	415.22	418.09	414.91	418.045	7085783.0
2022-05-04 13:00:00	SPY	ETF	418.04	418.92	416.9	418.205	6806097.0
2022-05-04 14:00:00	SPY	ETF	418.16	424.25	414.12	423.7	31838067.0
2022-05-04 15:00:00	SPY	ETF	423.71	429.66	423.08	428.99	37400472.0
2022-05-04 16:00:00	SPY	ETF	428.98	429.06	427.88	427.95	5043313.0
2022-05-04 17:00:00	SPY	ETF	427.94	428.43	427.92	428.31	354308.0
2022-05-04 18:00:00	SPY	ETF	428.32	428.93	427.97	428.1	307248.0
2022-05-04 19:00:00	SPY	ETF	428.15	428.36	427.9	428.16	101596.0
2022-05-04 04:00:00	QQQ	ETF	319.58	319.93	319.38	319.62	26429.0
2022-05-04 05:00:00	QQQ	ETF	319.39	319.79	318.96	319.79	14117.0
2022-05-04 06:00:00	QQQ	ETF	319.83	320.12	319.59	319.85	75655.0
2022-05-04 07:00:00	QQQ	ETF	319.83	320.43	319.64	319.91	111561.0
2022-05-04 08:00:00	QQQ	ETF	320.35	320.42	319.25	319.4	228337.0
2022-05-04 09:00:00	QQQ	ETF	319.22	319.58	317.11	317.145	5916290.0
2022-05-04 10:00:00	QQQ	ETF	317.16	317.37	314.76	315.1	8885704.0
2022-05-04 11:00:00	QQQ	ETF	315.11	316.2	313.891	315.785	6552791.0
2022-05-04 12:00:00	QQQ	ETF	315.78	319.2394	315.5	319.21	6546964.0
2022-05-04 13:00:00	QQQ	ETF	319.24	320.9116	318.42	320.23	6409802.0
2022-05-04 14:00:00	QQQ	ETF	320.2	325.38	315.25	324.9	35769138.0
2022-05-04 15:00:00	QQQ	ETF	324.94	330.29	324.25	329.74	21221094.0
2022-05-04 16:00:00	QQQ	ETF	329.74	329.75	328.63	328.84	2582537.0
2022-05-04 17:00:00	QQQ	ETF	328.8	329.33	328.7	329.21	232991.0
2022-05-04 18:00:00	QQQ	ETF	329.2	329.9	328.99	329.11	214470.0
2022-05-04 19:00:00	QQQ	ETF	329.15	329.39	329.0	329.25	167777.0
2022-05-04 04:00:00	IWM	ETF	188.9	189.15	188.81	189.09	6669.0
2022-05-04 05:00:00	IWM	ETF	189.0	189.2	188.79	189.2	8741.0
2022-05-04 06:00:00	IWM	ETF	189.34	189.45	189.3	189.41	10943.0
2022-05-04 07:00:00	IWM	ETF	189.39	189.67	189.24	189.4	30783.0
2022-05-04 08:00:00	IWM	ETF	189.43	189.65	188.98	189.0	106147.0
2022-05-04 09:00:00	IWM	ETF	189.02	189.26	187.53	187.59	2871285.0
2022-05-04 10:00:00	IWM	ETF	187.58	187.62	186.57	186.98	2826743.0
2022-05-04 11:00:00	IWM	ETF	186.99	187.17	186.1562	186.63	2046416.0
2022-05-04 12:00:00	IWM	ETF	186.62	187.98	186.39	187.9	1886586.0
2022-05-04 13:00:00	IWM	ETF	187.92	188.73	187.205	188.31	2119288.0
2022-05-04 14:00:00	IWM	ETF	188.295	191.45	185.6932	191.11	8818710.0
2022-05-04 15:00:00	IWM	ETF	191.13	193.93	190.93	193.63	9314754.0
2022-05-04 16:00:00	IWM	ETF	193.64	193.64	193.0	193.04	1136265.0
2022-05-04 17:00:00	IWM	ETF	193.03	193.37	193.01	193.25	32535.0
2022-05-04 18:00:00	IWM	ETF	193.25	193.49	193.05	193.12	31240.0
2022-05-04 19:00:00	IWM	ETF	193.2	193.26	193.04	193.21	36239.0
2022-05-04 06:00:00	DIA	ETF	332.52	332.52	332.4	332.48	7000.0
2022-05-04 07:00:00	DIA	ETF	332.3	332.7	332.3	332.3	7180.0

> showing 50 of 16,630 rows — these rows as CSV

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