PREVIEW / etf_1hour / 2022-09-08

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-08.parquet
  size:    438 KB
  rows:    15,946

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-09-08 04:00:00	SPY	ETF	397.25	397.77	396.81	397.76	150317.0
2022-09-08 05:00:00	SPY	ETF	397.89	397.91	397.38	397.78	68181.0
2022-09-08 06:00:00	SPY	ETF	397.9	398.46	397.5	398.12	39239.0
2022-09-08 07:00:00	SPY	ETF	398.24	398.83	397.5	397.8	242930.0
2022-09-08 08:00:00	SPY	ETF	398.3501	399.07	396.05	396.18	907223.0
2022-09-08 09:00:00	SPY	ETF	396.06	397.7	394.12	397.32	8731188.0
2022-09-08 10:00:00	SPY	ETF	397.33	399.99	395.741	399.9	8431703.0
2022-09-08 11:00:00	SPY	ETF	399.905	400.86	399.18	399.49	6754199.0
2022-09-08 12:00:00	SPY	ETF	399.51	399.69	395.05	397.88	11321059.0
2022-09-08 13:00:00	SPY	ETF	397.89	399.86	397.1001	398.99	6702756.0
2022-09-08 14:00:00	SPY	ETF	398.97	400.08	398.3	398.55	5987085.0
2022-09-08 15:00:00	SPY	ETF	398.56	400.49	397.84	400.4	9802374.0
2022-09-08 16:00:00	SPY	ETF	400.4	400.94	400.37	400.85	3930239.0
2022-09-08 17:00:00	SPY	ETF	400.84	400.94	400.73	400.7999	45313.0
2022-09-08 18:00:00	SPY	ETF	400.83	400.85	400.4	400.6	63910.0
2022-09-08 19:00:00	SPY	ETF	400.69	401.02	400.38	400.77	52786.0
2022-09-08 04:00:00	QQQ	ETF	298.88	299.13	298.09	299.13	49524.0
2022-09-08 05:00:00	QQQ	ETF	299.13	299.17	298.67	298.95	11271.0
2022-09-08 06:00:00	QQQ	ETF	299.01	299.48	298.75	299.2	29667.0
2022-09-08 07:00:00	QQQ	ETF	299.27	299.76	298.55	298.75	202426.0
2022-09-08 08:00:00	QQQ	ETF	298.85	300.25	296.93	297.11	1024575.0
2022-09-08 09:00:00	QQQ	ETF	297.04	299.23	295.45	298.62	7195409.0
2022-09-08 10:00:00	QQQ	ETF	298.66	300.96	296.98	300.94	6062736.0
2022-09-08 11:00:00	QQQ	ETF	300.93	301.87	300.085	300.34	4462531.0
2022-09-08 12:00:00	QQQ	ETF	300.3	300.5	295.99	298.2	7517005.0
2022-09-08 13:00:00	QQQ	ETF	298.2293	299.99	297.37	298.97	4844336.0
2022-09-08 14:00:00	QQQ	ETF	298.94	299.97	298.47	298.9023	3498988.0
2022-09-08 15:00:00	QQQ	ETF	298.9	300.58	298.21	300.51	4903358.0
2022-09-08 16:00:00	QQQ	ETF	300.56	301.11	300.406	301.06	2005190.0
2022-09-08 17:00:00	QQQ	ETF	301.07	301.16	300.99	301.1	49236.0
2022-09-08 18:00:00	QQQ	ETF	301.04	301.06	300.7	300.92	71552.0
2022-09-08 19:00:00	QQQ	ETF	300.93	301.4	300.93	301.19	77978.0
2022-09-08 04:00:00	IWM	ETF	181.82	182.04	181.67	182.03	17693.0
2022-09-08 05:00:00	IWM	ETF	182.12	182.12	181.9	182.08	5284.0
2022-09-08 06:00:00	IWM	ETF	181.9	182.36	181.9	182.21	21643.0
2022-09-08 07:00:00	IWM	ETF	182.22	182.44	181.87	181.99	155055.0
2022-09-08 08:00:00	IWM	ETF	182.3	182.5	181.13	181.17	132513.0
2022-09-08 09:00:00	IWM	ETF	181.1	182.13	179.62	181.76	2616888.0
2022-09-08 10:00:00	IWM	ETF	181.78	183.11	180.98	183.02	2810957.0
2022-09-08 11:00:00	IWM	ETF	183.01	183.55	182.95	183.18	1822637.0
2022-09-08 12:00:00	IWM	ETF	183.2	183.26	181.33	182.7	2521712.0
2022-09-08 13:00:00	IWM	ETF	182.72	183.455	182.2	183.17	2098006.0
2022-09-08 14:00:00	IWM	ETF	183.16	183.66	182.86	183.03	1740622.0
2022-09-08 15:00:00	IWM	ETF	183.03	183.79	182.735	183.73	2978614.0
2022-09-08 16:00:00	IWM	ETF	183.71	183.89	183.67	183.8	1147684.0
2022-09-08 17:00:00	IWM	ETF	183.75	183.88	183.74	183.84	14970.0
2022-09-08 18:00:00	IWM	ETF	183.76	183.84	183.62	183.84	27341.0
2022-09-08 19:00:00	IWM	ETF	183.84	184.06	183.82	183.86	19022.0
2022-09-08 04:00:00	DIA	ETF	316.17	316.17	316.06	316.06	420.0
2022-09-08 05:00:00	DIA	ETF	316.47	316.48	316.3	316.3	760.0

> showing 50 of 15,946 rows — these rows as CSV

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