PREVIEW / etf_1hour / 2022-04-25

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-25.parquet
  size:    473 KB
  rows:    17,424

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-25 04:00:00	SPY	ETF	422.26	423.68	421.2	421.77	69614.0
2022-04-25 05:00:00	SPY	ETF	421.72	422.94	421.17	422.39	90635.0
2022-04-25 06:00:00	SPY	ETF	422.2	422.71	421.84	422.53	57844.0
2022-04-25 07:00:00	SPY	ETF	422.6	423.5	421.45	422.71	612608.0
2022-04-25 08:00:00	SPY	ETF	422.64	425.721	421.2696	424.56	847179.0
2022-04-25 09:00:00	SPY	ETF	424.57	424.69	420.27	420.2993	11827942.0
2022-04-25 10:00:00	SPY	ETF	420.3	424.4	419.99	420.72	13739928.0
2022-04-25 11:00:00	SPY	ETF	420.7	422.21	418.84	419.77	10500117.0
2022-04-25 12:00:00	SPY	ETF	419.76	423.29	419.16	422.0399	9584420.0
2022-04-25 13:00:00	SPY	ETF	422.075	423.79	420.98	422.49	7545479.0
2022-04-25 14:00:00	SPY	ETF	422.49	426.76	421.75	425.51	11109278.0
2022-04-25 15:00:00	SPY	ETF	425.49	428.69	423.84	428.49	22441619.0
2022-04-25 16:00:00	SPY	ETF	428.49	429.0	428.07	428.65	3655425.0
2022-04-25 17:00:00	SPY	ETF	428.65	428.66	428.38	428.48	811836.0
2022-04-25 18:00:00	SPY	ETF	428.52	428.55	428.05	428.42	109664.0
2022-04-25 19:00:00	SPY	ETF	428.49	428.67	428.23	428.4	70773.0
2022-04-25 04:00:00	QQQ	ETF	323.5	324.03	321.94	322.36	234621.0
2022-04-25 05:00:00	QQQ	ETF	322.45	323.5	321.89	322.89	134414.0
2022-04-25 06:00:00	QQQ	ETF	323.08	323.21	322.25	322.78	167661.0
2022-04-25 07:00:00	QQQ	ETF	322.79	323.09	321.2	322.74	660481.0
2022-04-25 08:00:00	QQQ	ETF	322.8	325.644	321.2605	324.36	813256.0
2022-04-25 09:00:00	QQQ	ETF	324.38	325.6	322.43	322.74	11873740.0
2022-04-25 10:00:00	QQQ	ETF	322.73	328.01	322.63	324.62	16363715.0
2022-04-25 11:00:00	QQQ	ETF	324.65	325.73	322.51	323.16	10645388.0
2022-04-25 12:00:00	QQQ	ETF	323.142	326.57	322.56	324.99	8190478.0
2022-04-25 13:00:00	QQQ	ETF	324.98	326.75	324.11	325.2	6163946.0
2022-04-25 14:00:00	QQQ	ETF	325.22	328.65	324.52	327.2801	8159084.0
2022-04-25 15:00:00	QQQ	ETF	327.26	329.9	325.14	329.62	13679877.0
2022-04-25 16:00:00	QQQ	ETF	329.62	330.04	323.678	329.54	2341064.0
2022-04-25 17:00:00	QQQ	ETF	329.52	329.58	326.03	329.55	154424.0
2022-04-25 18:00:00	QQQ	ETF	329.54	329.56	329.05	329.5	130205.0
2022-04-25 19:00:00	QQQ	ETF	329.47	329.7	329.33	329.43	154777.0
2022-04-25 04:00:00	IWM	ETF	191.0	191.26	189.89	189.97	44792.0
2022-04-25 05:00:00	IWM	ETF	190.16	190.63	189.7	190.43	40363.0
2022-04-25 06:00:00	IWM	ETF	190.42	190.6	190.16	190.58	59710.0
2022-04-25 07:00:00	IWM	ETF	190.59	191.26	190.22	190.72	200610.0
2022-04-25 08:00:00	IWM	ETF	190.75	191.46	190.49	191.41	195718.0
2022-04-25 09:00:00	IWM	ETF	191.42	191.67	189.62	189.66	4065705.0
2022-04-25 10:00:00	IWM	ETF	189.62	191.51	189.27	189.66	4362321.0
2022-04-25 11:00:00	IWM	ETF	189.66	190.8	189.21	189.77	2914472.0
2022-04-25 12:00:00	IWM	ETF	189.77	192.43	189.41	191.71	3108964.0
2022-04-25 13:00:00	IWM	ETF	191.71	192.72	191.14	191.59	2567704.0
2022-04-25 14:00:00	IWM	ETF	191.62	193.665	191.23	192.72	2732040.0
2022-04-25 15:00:00	IWM	ETF	192.71	194.11	191.77	193.91	5490151.0
2022-04-25 16:00:00	IWM	ETF	193.85	194.09	193.3	193.85	994074.0
2022-04-25 17:00:00	IWM	ETF	193.93	193.93	193.7	193.7	7162.0
2022-04-25 18:00:00	IWM	ETF	193.71	193.81	193.54	193.76	15847.0
2022-04-25 19:00:00	IWM	ETF	193.86	193.95	193.63	193.75	13925.0
2022-04-25 04:00:00	DIA	ETF	335.77	335.9	334.63	334.98	2708.0
2022-04-25 05:00:00	DIA	ETF	334.84	335.76	334.84	335.54	2000.0

> showing 50 of 17,424 rows — these rows as CSV

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