PREVIEW / etf_1hour / 2022-04-28

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-28.parquet
  size:    455 KB
  rows:    16,539

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-28 04:00:00	SPY	ETF	423.06	424.78	422.21	424.78	89964.0
2022-04-28 05:00:00	SPY	ETF	425.0	425.09	423.62	423.83	106239.0
2022-04-28 06:00:00	SPY	ETF	423.86	424.04	422.72	423.07	195502.0
2022-04-28 07:00:00	SPY	ETF	423.12	424.2	422.85	423.08	378935.0
2022-04-28 08:00:00	SPY	ETF	423.13	424.8004	420.1	421.82	1417828.0
2022-04-28 09:00:00	SPY	ETF	421.81	423.08	419.56	420.48	8481939.0
2022-04-28 10:00:00	SPY	ETF	420.445	420.68	417.6	419.2801	11128512.0
2022-04-28 11:00:00	SPY	ETF	419.31	421.35	419.085	420.55	7354685.0
2022-04-28 12:00:00	SPY	ETF	420.53	425.8	420.02	425.6	9498254.0
2022-04-28 13:00:00	SPY	ETF	425.6	427.63	425.23	427.17	9908988.0
2022-04-28 14:00:00	SPY	ETF	427.17	429.1999	426.72	428.65	8524363.0
2022-04-28 15:00:00	SPY	ETF	428.63	429.64	426.37	427.79	21912102.0
2022-04-28 16:00:00	SPY	ETF	427.78	428.1	424.7	425.31	5686564.0
2022-04-28 17:00:00	SPY	ETF	425.43	425.5	421.7	423.48	556601.0
2022-04-28 18:00:00	SPY	ETF	423.6	424.7	422.96	423.84	275831.0
2022-04-28 19:00:00	SPY	ETF	423.85	424.28	423.71	423.91	80628.0
2022-04-28 04:00:00	QQQ	ETF	322.2	324.9	322.2	324.9	170161.0
2022-04-28 05:00:00	QQQ	ETF	324.99	325.08	323.4	323.57	158461.0
2022-04-28 06:00:00	QQQ	ETF	323.45	323.78	322.85	323.25	233423.0
2022-04-28 07:00:00	QQQ	ETF	323.27	324.3	322.9	323.13	319081.0
2022-04-28 08:00:00	QQQ	ETF	323.2587	325.0804	316.76	321.36	1315964.0
2022-04-28 09:00:00	QQQ	ETF	321.43	323.505	319.03	320.03	12388375.0
2022-04-28 10:00:00	QQQ	ETF	320.02	321.22	317.52	319.2601	10278288.0
2022-04-28 11:00:00	QQQ	ETF	319.29	321.879	318.945	320.0507	6987312.0
2022-04-28 12:00:00	QQQ	ETF	320.07	325.76	319.53	325.3931	7467319.0
2022-04-28 13:00:00	QQQ	ETF	325.395	327.69	325.06	327.5921	9436603.0
2022-04-28 14:00:00	QQQ	ETF	327.58	329.47	327.01	328.765	7524680.0
2022-04-28 15:00:00	QQQ	ETF	328.76	329.89	326.72	327.94	13321825.0
2022-04-28 16:00:00	QQQ	ETF	327.95	328.12	323.3	324.21	5404938.0
2022-04-28 17:00:00	QQQ	ETF	324.77	328.01	318.87	321.35	1996591.0
2022-04-28 18:00:00	QQQ	ETF	321.35	323.6	321.07	322.82	823937.0
2022-04-28 19:00:00	QQQ	ETF	322.83	323.34	322.49	322.75	156622.0
2022-04-28 04:00:00	IWM	ETF	189.32	190.02	189.32	190.0	34530.0
2022-04-28 05:00:00	IWM	ETF	190.07	190.25	189.59	189.67	13847.0
2022-04-28 06:00:00	IWM	ETF	189.65	189.73	189.06	189.06	75322.0
2022-04-28 07:00:00	IWM	ETF	189.4	189.76	189.28	189.29	58961.0
2022-04-28 08:00:00	IWM	ETF	189.5699	189.75	188.0	188.75	238208.0
2022-04-28 09:00:00	IWM	ETF	188.74	189.61	187.01	187.11	4415686.0
2022-04-28 10:00:00	IWM	ETF	187.11	187.12	184.71	185.73	5395895.0
2022-04-28 11:00:00	IWM	ETF	185.735	186.37	185.28	185.78	2842319.0
2022-04-28 12:00:00	IWM	ETF	185.79	189.23	185.55	189.12	3006251.0
2022-04-28 13:00:00	IWM	ETF	189.13	190.425	188.83	190.07	3645226.0
2022-04-28 14:00:00	IWM	ETF	190.07	191.12	189.8815	190.94	2590308.0
2022-04-28 15:00:00	IWM	ETF	190.94	191.4	190.04	190.4	5540445.0
2022-04-28 16:00:00	IWM	ETF	190.45	190.67	189.56	189.86	2255343.0
2022-04-28 17:00:00	IWM	ETF	190.08	190.08	188.13	189.4401	153445.0
2022-04-28 18:00:00	IWM	ETF	189.44	189.98	189.34	189.59	62601.0
2022-04-28 19:00:00	IWM	ETF	189.6	189.74	189.42	189.59	19216.0
2022-04-28 04:00:00	DIA	ETF	335.98	335.98	335.98	335.98	289.0
2022-04-28 07:00:00	DIA	ETF	335.75	336.21	335.74	335.88	3629.0

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

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