PREVIEW / etf_1hour / 2022-04-26

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-26.parquet
  size:    468 KB
  rows:    16,958

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-04-26 04:00:00	SPY	ETF	426.65	428.39	426.43	427.88	37252.0
2022-04-26 05:00:00	SPY	ETF	427.88	428.0	427.12	427.5	21530.0
2022-04-26 06:00:00	SPY	ETF	427.65	427.88	426.92	426.92	40402.0
2022-04-26 07:00:00	SPY	ETF	426.95	427.15	426.371	427.13	185004.0
2022-04-26 08:00:00	SPY	ETF	426.58	429.25	425.92	426.6	460741.0
2022-04-26 09:00:00	SPY	ETF	426.56	426.56	423.43	423.86	8574375.0
2022-04-26 10:00:00	SPY	ETF	423.85	424.64	420.49	421.07	11487214.0
2022-04-26 11:00:00	SPY	ETF	421.04	421.55	419.41	419.445	8627218.0
2022-04-26 12:00:00	SPY	ETF	419.46	422.31	419.44	422.225	7287553.0
2022-04-26 13:00:00	SPY	ETF	422.2144	422.26	418.74	419.41	8267756.0
2022-04-26 14:00:00	SPY	ETF	419.41	421.0	419.0	420.75	7936158.0
2022-04-26 15:00:00	SPY	ETF	420.72	421.22	416.07	416.11	23101134.0
2022-04-26 16:00:00	SPY	ETF	416.12	416.99	413.0	413.25	6484620.0
2022-04-26 17:00:00	SPY	ETF	413.41	414.5	413.35	414.4596	223833.0
2022-04-26 18:00:00	SPY	ETF	414.55	417.01	414.3	415.92	635242.0
2022-04-26 19:00:00	SPY	ETF	415.93	416.97	415.88	416.6	98346.0
2022-04-26 20:00:00	SPY	ETF	416.6	416.6	416.6	416.6	150.0
2022-04-26 04:00:00	QQQ	ETF	327.83	329.4	327.65	329.38	65539.0
2022-04-26 05:00:00	QQQ	ETF	329.31	329.56	328.7	329.09	31763.0
2022-04-26 06:00:00	QQQ	ETF	328.98	329.24	328.31	328.35	37060.0
2022-04-26 07:00:00	QQQ	ETF	328.37	328.66	327.9	328.58	335395.0
2022-04-26 08:00:00	QQQ	ETF	328.6	329.827	327.62	328.32	406415.0
2022-04-26 09:00:00	QQQ	ETF	328.28	328.28	322.88	323.25	9028825.0
2022-04-26 10:00:00	QQQ	ETF	323.21	323.4	320.07	320.26	14482479.0
2022-04-26 11:00:00	QQQ	ETF	320.25	320.87	319.05	319.1824	9892855.0
2022-04-26 12:00:00	QQQ	ETF	319.19	322.31	319.185	322.0	8335806.0
2022-04-26 13:00:00	QQQ	ETF	322.01	322.04	318.94	319.72	7147085.0
2022-04-26 14:00:00	QQQ	ETF	319.69	321.66	319.3	321.4549	8697555.0
2022-04-26 15:00:00	QQQ	ETF	321.45	321.885	316.855	316.91	18500045.0
2022-04-26 16:00:00	QQQ	ETF	316.88	317.26	311.88	312.23	6782489.0
2022-04-26 17:00:00	QQQ	ETF	312.11	315.05	312.0	314.49	489289.0
2022-04-26 18:00:00	QQQ	ETF	314.4	317.74	313.7	315.9	1986398.0
2022-04-26 19:00:00	QQQ	ETF	315.9	316.99	315.85	316.65	341598.0
2022-04-26 04:00:00	IWM	ETF	193.21	193.68	193.01	193.59	14948.0
2022-04-26 05:00:00	IWM	ETF	193.73	193.73	193.37	193.56	5173.0
2022-04-26 06:00:00	IWM	ETF	193.54	193.6	193.33	193.54	5961.0
2022-04-26 07:00:00	IWM	ETF	193.38	193.44	193.12	193.33	24593.0
2022-04-26 08:00:00	IWM	ETF	193.38	194.3	192.64	192.84	129173.0
2022-04-26 09:00:00	IWM	ETF	192.81	192.82	191.15	191.44	4433504.0
2022-04-26 10:00:00	IWM	ETF	191.41	192.04	189.72	190.11	4928330.0
2022-04-26 11:00:00	IWM	ETF	190.08	190.76	189.18	189.18	3287125.0
2022-04-26 12:00:00	IWM	ETF	189.19	190.89	189.15	190.86	2893311.0
2022-04-26 13:00:00	IWM	ETF	190.87	190.88	188.54	189.25	3037352.0
2022-04-26 14:00:00	IWM	ETF	189.25	189.89	188.85	189.73	2513549.0
2022-04-26 15:00:00	IWM	ETF	189.72	189.94	187.48	187.63	8824812.0
2022-04-26 16:00:00	IWM	ETF	187.74	188.0	186.79	187.05	1527256.0
2022-04-26 17:00:00	IWM	ETF	186.8312	187.18	186.79	186.83	23693.0
2022-04-26 18:00:00	IWM	ETF	187.17	187.74	186.6	187.36	307177.0
2022-04-26 19:00:00	IWM	ETF	187.33	187.77	187.3	187.3	35347.0
2022-04-26 04:00:00	DIA	ETF	339.12	339.3	339.12	339.3	2000.0

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

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