PREVIEW / etf_1hour / 2022-06-29

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-29.parquet
  size:    439 KB
  rows:    16,122

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-06-29 04:00:00	SPY	ETF	380.71	381.45	380.31	381.15	31492.0
2022-06-29 05:00:00	SPY	ETF	381.07	381.3	379.45	379.45	38597.0
2022-06-29 06:00:00	SPY	ETF	379.56	380.42	379.56	379.91	46660.0
2022-06-29 07:00:00	SPY	ETF	379.92	381.53	379.51	381.4	223231.0
2022-06-29 08:00:00	SPY	ETF	381.39	382.24	379.49	380.8	679377.0
2022-06-29 09:00:00	SPY	ETF	380.71	381.94	378.42	381.0718	7694699.0
2022-06-29 10:00:00	SPY	ETF	381.04	382.27	379.66	380.84	9714856.0
2022-06-29 11:00:00	SPY	ETF	380.84	381.145	379.18	380.53	6060011.0
2022-06-29 12:00:00	SPY	ETF	380.51	380.7	378.45	379.5783	5282268.0
2022-06-29 13:00:00	SPY	ETF	379.58	380.91	378.75	380.8207	5132185.0
2022-06-29 14:00:00	SPY	ETF	380.8177	381.7099	379.68	380.07	5217966.0
2022-06-29 15:00:00	SPY	ETF	380.07	381.515	379.53	380.36	11309640.0
2022-06-29 16:00:00	SPY	ETF	380.37	380.72	380.08	380.6	2757977.0
2022-06-29 17:00:00	SPY	ETF	380.55	380.65	380.5	380.53	36594.0
2022-06-29 18:00:00	SPY	ETF	380.6	380.67	380.33	380.46	128868.0
2022-06-29 19:00:00	SPY	ETF	380.42	380.44	379.83	380.04	65295.0
2022-06-29 04:00:00	QQQ	ETF	283.36	284.18	283.27	283.67	123174.0
2022-06-29 05:00:00	QQQ	ETF	283.65	284.05	282.11	282.11	85049.0
2022-06-29 06:00:00	QQQ	ETF	282.33	282.96	282.23	282.65	88845.0
2022-06-29 07:00:00	QQQ	ETF	282.56	283.95	282.24	283.83	348913.0
2022-06-29 08:00:00	QQQ	ETF	282.66	284.65	282.1504	283.17	1202685.0
2022-06-29 09:00:00	QQQ	ETF	283.1	284.7	280.84	283.9	8417196.0
2022-06-29 10:00:00	QQQ	ETF	283.85	285.34	282.464	283.93	9074589.0
2022-06-29 11:00:00	QQQ	ETF	283.95	284.5491	282.635	283.97	4887449.0
2022-06-29 12:00:00	QQQ	ETF	283.9443	284.0597	281.82	282.97	3889560.0
2022-06-29 13:00:00	QQQ	ETF	282.98	283.97	282.22	283.9	3573796.0
2022-06-29 14:00:00	QQQ	ETF	283.88	284.79	282.82	283.1507	3687105.0
2022-06-29 15:00:00	QQQ	ETF	283.15	284.625	282.79	283.87	6235153.0
2022-06-29 16:00:00	QQQ	ETF	283.86	284.02	283.38	283.92	1387171.0
2022-06-29 17:00:00	QQQ	ETF	283.95	283.96	283.78	283.89	22012.0
2022-06-29 18:00:00	QQQ	ETF	283.88	284.05	283.75	283.9	54414.0
2022-06-29 19:00:00	QQQ	ETF	283.88	283.88	283.44	283.63	45506.0
2022-06-29 04:00:00	IWM	ETF	172.37	172.8	172.37	172.62	1741.0
2022-06-29 05:00:00	IWM	ETF	172.53	172.67	171.85	171.88	9758.0
2022-06-29 06:00:00	IWM	ETF	172.03	172.36	171.9	172.12	9224.0
2022-06-29 07:00:00	IWM	ETF	172.12	172.91	171.92	172.83	18860.0
2022-06-29 08:00:00	IWM	ETF	172.09	173.29	172.05	172.41	102346.0
2022-06-29 09:00:00	IWM	ETF	172.4	172.9	169.74	170.75	2720293.0
2022-06-29 10:00:00	IWM	ETF	170.73	171.55	169.75	169.93	2899141.0
2022-06-29 11:00:00	IWM	ETF	169.935	170.45	168.97	170.28	2506824.0
2022-06-29 12:00:00	IWM	ETF	170.29	170.39	169.21	169.8	1809189.0
2022-06-29 13:00:00	IWM	ETF	169.8	170.46	169.25	170.4	1302606.0
2022-06-29 14:00:00	IWM	ETF	170.39	170.94	169.9	170.08	1551545.0
2022-06-29 15:00:00	IWM	ETF	170.085	170.84	169.82	170.69	2828034.0
2022-06-29 16:00:00	IWM	ETF	170.69	170.97	170.58	170.94	1160096.0
2022-06-29 17:00:00	IWM	ETF	171.04	171.04	170.81	170.99	2375.0
2022-06-29 18:00:00	IWM	ETF	170.94	170.94	170.74	170.9	19481.0
2022-06-29 19:00:00	IWM	ETF	170.76	170.78	170.48	170.55	28289.0
2022-06-29 05:00:00	DIA	ETF	309.45	309.5	309.45	309.5	440.0
2022-06-29 06:00:00	DIA	ETF	309.0	309.0	309.0	309.0	280.0

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

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