PREVIEW / etf_1hour / 2022-02-24

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-02-24.parquet
  size:    500 KB
  rows:    18,613

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-02-24 04:00:00	SPY	ETF	415.56	418.0	413.48	413.5	417940.0
2022-02-24 05:00:00	SPY	ETF	413.44	414.74	412.37	412.83	306297.0
2022-02-24 06:00:00	SPY	ETF	412.9	413.39	410.8	413.39	585033.0
2022-02-24 07:00:00	SPY	ETF	413.38	413.48	410.79	411.7	1117075.0
2022-02-24 08:00:00	SPY	ETF	415.503	421.95	410.1	411.489	2427405.0
2022-02-24 09:00:00	SPY	ETF	411.44	421.95	410.64	415.72	21849731.0
2022-02-24 10:00:00	SPY	ETF	415.71	418.14	413.11	417.07	25014012.0
2022-02-24 11:00:00	SPY	ETF	417.06	419.48	416.07	418.69	16171546.0
2022-02-24 12:00:00	SPY	ETF	418.67	418.7926	415.34	416.4273	12061071.0
2022-02-24 13:00:00	SPY	ETF	416.41	421.4	415.74	418.98	14635847.0
2022-02-24 14:00:00	SPY	ETF	418.975	423.82	417.84	423.36	20759042.0
2022-02-24 15:00:00	SPY	ETF	423.37	428.76	422.95	428.31	31811430.0
2022-02-24 16:00:00	SPY	ETF	428.3	428.42	426.08	426.78	5589229.0
2022-02-24 17:00:00	SPY	ETF	426.77	428.3	426.76	426.9	1228779.0
2022-02-24 18:00:00	SPY	ETF	426.81	428.3	425.2	425.94	244164.0
2022-02-24 19:00:00	SPY	ETF	425.91	427.61	425.71	425.91	229232.0
2022-02-24 04:00:00	QQQ	ETF	322.7	323.14	320.55	320.91	469547.0
2022-02-24 05:00:00	QQQ	ETF	321.05	322.4	319.89	320.54	320444.0
2022-02-24 06:00:00	QQQ	ETF	320.44	320.96	318.82	320.86	530544.0
2022-02-24 07:00:00	QQQ	ETF	320.94	320.98	318.39	319.03	1030423.0
2022-02-24 08:00:00	QQQ	ETF	320.93	329.667	317.75	319.45	2205584.0
2022-02-24 09:00:00	QQQ	ETF	319.53	325.97	318.26	325.41	16490523.0
2022-02-24 10:00:00	QQQ	ETF	325.4	329.1798	323.11	328.1353	18400015.0
2022-02-24 11:00:00	QQQ	ETF	328.12	330.8	327.3	330.29	11685710.0
2022-02-24 12:00:00	QQQ	ETF	330.31	330.599	326.93	328.18	8260643.0
2022-02-24 13:00:00	QQQ	ETF	328.16	334.14	327.76	331.7249	10063251.0
2022-02-24 14:00:00	QQQ	ETF	331.73	336.62	330.7	335.94	12362907.0
2022-02-24 15:00:00	QQQ	ETF	335.94	341.04	335.4762	340.65	16371195.0
2022-02-24 16:00:00	QQQ	ETF	340.65	340.79	329.9524	339.36	2604574.0
2022-02-24 17:00:00	QQQ	ETF	339.25	340.49	339.25	339.44	241476.0
2022-02-24 18:00:00	QQQ	ETF	339.44	339.44	337.5	338.05	250853.0
2022-02-24 19:00:00	QQQ	ETF	338.02	339.95	338.02	338.27	449460.0
2022-02-24 04:00:00	IWM	ETF	189.57	190.47	188.93	188.93	109619.0
2022-02-24 05:00:00	IWM	ETF	188.97	189.57	188.24	188.79	159269.0
2022-02-24 06:00:00	IWM	ETF	188.69	188.92	187.54	188.91	164262.0
2022-02-24 07:00:00	IWM	ETF	188.98	188.98	187.81	188.33	189133.0
2022-02-24 08:00:00	IWM	ETF	188.35	189.02	187.64	188.4	483120.0
2022-02-24 09:00:00	IWM	ETF	188.45	191.41	187.92	191.37	7171278.0
2022-02-24 10:00:00	IWM	ETF	191.34	192.65	189.9	191.91	8015262.0
2022-02-24 11:00:00	IWM	ETF	191.94	193.45	191.44	192.76	4451250.0
2022-02-24 12:00:00	IWM	ETF	192.75	193.12	191.33	191.89	3068752.0
2022-02-24 13:00:00	IWM	ETF	191.87	194.5	191.51	193.23	4068528.0
2022-02-24 14:00:00	IWM	ETF	193.2	195.9	192.5	195.48	5424096.0
2022-02-24 15:00:00	IWM	ETF	195.48	198.48	195.4	198.18	6932900.0
2022-02-24 16:00:00	IWM	ETF	198.18	198.23	196.86	197.07	1073493.0
2022-02-24 17:00:00	IWM	ETF	197.58	198.04	197.0	197.35	44305.0
2022-02-24 18:00:00	IWM	ETF	197.16	198.04	196.42	196.96	67969.0
2022-02-24 19:00:00	IWM	ETF	197.06	197.82	196.85	197.1	83790.0
2022-02-24 04:00:00	DIA	ETF	325.03	326.69	324.9	325.0	10050.0
2022-02-24 05:00:00	DIA	ETF	324.68	325.2	323.95	324.09	8600.0

> showing 50 of 18,613 rows — these rows as CSV

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