PREVIEW / etf_1hour / 2022-04-01

all etf 1-hour files

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

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-01 04:00:00	SPY	ETF	453.68	454.08	453.55	454.01	49150.0
2022-04-01 05:00:00	SPY	ETF	453.77	454.39	453.62	454.35	51236.0
2022-04-01 06:00:00	SPY	ETF	454.36	454.57	454.03	454.31	59306.0
2022-04-01 07:00:00	SPY	ETF	454.21	454.34	453.94	454.12	344985.0
2022-04-01 08:00:00	SPY	ETF	453.8304	454.35	451.978	453.24	750170.0
2022-04-01 09:00:00	SPY	ETF	453.2	453.71	451.66	452.26	6007402.0
2022-04-01 10:00:00	SPY	ETF	452.25	452.81	450.8	451.99	9120369.0
2022-04-01 11:00:00	SPY	ETF	451.985	452.43	450.11	450.35	6133316.0
2022-04-01 12:00:00	SPY	ETF	450.33	450.51	449.35	449.931	5128510.0
2022-04-01 13:00:00	SPY	ETF	449.95	450.88	449.14	450.53	4576640.0
2022-04-01 14:00:00	SPY	ETF	450.53	452.77	450.47	451.7966	7265447.0
2022-04-01 15:00:00	SPY	ETF	451.8	453.19	450.31	452.88	18245442.0
2022-04-01 16:00:00	SPY	ETF	452.87	453.06	452.15	452.84	5459724.0
2022-04-01 17:00:00	SPY	ETF	452.86	453.19	452.7001	453.12	175890.0
2022-04-01 18:00:00	SPY	ETF	453.15	453.18	452.99	452.99	12386.0
2022-04-01 19:00:00	SPY	ETF	453.05	453.29	453.02	453.29	18351.0
2022-04-01 04:00:00	QQQ	ETF	363.63	363.99	363.34	363.6	70448.0
2022-04-01 05:00:00	QQQ	ETF	363.51	363.98	363.03	363.88	41107.0
2022-04-01 06:00:00	QQQ	ETF	364.0	364.28	363.83	363.97	56441.0
2022-04-01 07:00:00	QQQ	ETF	364.01	364.09	363.63	364.09	191145.0
2022-04-01 08:00:00	QQQ	ETF	363.9399	364.1496	362.79	362.81	677548.0
2022-04-01 09:00:00	QQQ	ETF	362.83	363.61	360.59	361.41	5719568.0
2022-04-01 10:00:00	QQQ	ETF	361.41	362.77	360.5512	362.57	7316994.0
2022-04-01 11:00:00	QQQ	ETF	362.57	362.71	359.3	359.53	5364730.0
2022-04-01 12:00:00	QQQ	ETF	359.53	360.05	358.76	359.04	4874977.0
2022-04-01 13:00:00	QQQ	ETF	359.05	360.13	358.59	359.59	3754459.0
2022-04-01 14:00:00	QQQ	ETF	359.55	361.77	359.34	360.75	4230273.0
2022-04-01 15:00:00	QQQ	ETF	360.71	362.09	359.12	361.89	8576292.0
2022-04-01 16:00:00	QQQ	ETF	361.87	361.9511	361.12	361.65	2274970.0
2022-04-01 17:00:00	QQQ	ETF	361.62	361.9	361.4	361.85	61486.0
2022-04-01 18:00:00	QQQ	ETF	361.8	361.83	361.4	361.83	3049.0
2022-04-01 19:00:00	QQQ	ETF	361.73	361.85	361.25	361.85	9919.0
2022-04-01 04:00:00	IWM	ETF	205.9	206.25	205.9	206.24	9730.0
2022-04-01 05:00:00	IWM	ETF	206.2	206.54	206.0	206.51	80361.0
2022-04-01 06:00:00	IWM	ETF	206.56	206.59	206.22	206.33	14086.0
2022-04-01 07:00:00	IWM	ETF	206.3	206.4	206.15	206.23	87333.0
2022-04-01 08:00:00	IWM	ETF	206.46	206.5	205.89	205.97	126697.0
2022-04-01 09:00:00	IWM	ETF	205.98	207.72	205.83	207.47	2641208.0
2022-04-01 10:00:00	IWM	ETF	207.49	207.61	205.79	206.73	2932506.0
2022-04-01 11:00:00	IWM	ETF	206.72	207.4055	205.85	206.04	1817337.0
2022-04-01 12:00:00	IWM	ETF	206.02	206.06	205.01	205.57	1651303.0
2022-04-01 13:00:00	IWM	ETF	205.56	206.2	205.15	205.97	1536686.0
2022-04-01 14:00:00	IWM	ETF	205.93	207.28	205.92	207.08	1669835.0
2022-04-01 15:00:00	IWM	ETF	207.07	207.66	206.5	207.4598	3477461.0
2022-04-01 16:00:00	IWM	ETF	207.57	207.6	206.565	207.39	3444188.0
2022-04-01 17:00:00	IWM	ETF	207.27	207.68	207.27	207.6	10045.0
2022-04-01 18:00:00	IWM	ETF	207.67	207.87	207.45	207.62	8510.0
2022-04-01 19:00:00	IWM	ETF	207.75	207.85	207.63	207.67	6213.0
2022-04-01 04:00:00	DIA	ETF	348.41	348.41	348.33	348.33	413.0
2022-04-01 05:00:00	DIA	ETF	348.39	348.83	348.36	348.83	1500.0

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

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