PREVIEW / etf_1hour / 2005-08-23

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-23.parquet
  size:    31 KB
  rows:    939

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
2005-08-23 05:00:00	SPY	ETF	122.34	122.34	122.34	122.34	500.0
2005-08-23 07:00:00	SPY	ETF	122.37	122.41	122.34	122.34	101000.0
2005-08-23 08:00:00	SPY	ETF	122.39	122.5	122.34	122.45	456100.0
2005-08-23 09:00:00	SPY	ETF	122.43	122.61	122.15	122.23	7205000.0
2005-08-23 10:00:00	SPY	ETF	122.22	122.45	122.11	122.23	7295700.0
2005-08-23 11:00:00	SPY	ETF	122.23	122.25	121.81	121.89	9765100.0
2005-08-23 12:00:00	SPY	ETF	121.9	122.12	121.67	121.92	7139600.0
2005-08-23 13:00:00	SPY	ETF	121.92	122.15	121.83	122.04	5323100.0
2005-08-23 14:00:00	SPY	ETF	122.04	122.47	122.0	122.35	7464900.0
2005-08-23 15:00:00	SPY	ETF	122.35	122.36	122.05	122.05	6127000.0
2005-08-23 16:00:00	SPY	ETF	122.04	122.27	122.02	122.21	208400.0
2005-08-23 17:00:00	SPY	ETF	122.22	122.23	122.18	122.18	1567500.0
2005-08-23 18:00:00	SPY	ETF	122.18	122.18	122.15	122.15	3700.0
2005-08-23 19:00:00	SPY	ETF	122.22	122.25	122.22	122.25	19700.0
2005-08-23 09:00:00	QQQ	ETF	38.85	38.92	38.76	38.79	7072300.0
2005-08-23 10:00:00	QQQ	ETF	38.79	38.88	38.75	38.79	8899100.0
2005-08-23 11:00:00	QQQ	ETF	38.8	38.8	38.63	38.66	11929000.0
2005-08-23 12:00:00	QQQ	ETF	38.66	38.72	38.61	38.69	5271800.0
2005-08-23 13:00:00	QQQ	ETF	38.69	38.78	38.66	38.74	4960300.0
2005-08-23 14:00:00	QQQ	ETF	38.73	38.91	38.7	38.86	9209500.0
2005-08-23 15:00:00	QQQ	ETF	38.86	38.87	38.74	38.74	7530100.0
2005-08-23 07:00:00	IWM	ETF	65.43	65.43	65.4	65.4	21000.0
2005-08-23 08:00:00	IWM	ETF	65.44	65.45	65.4	65.41	495000.0
2005-08-23 09:00:00	IWM	ETF	65.42	65.63	65.35	65.36	3210900.0
2005-08-23 10:00:00	IWM	ETF	65.36	65.53	65.22	65.27	2610800.0
2005-08-23 11:00:00	IWM	ETF	65.26	65.3	64.95	64.99	2469900.0
2005-08-23 12:00:00	IWM	ETF	65.0	65.04	64.86	65.0	2445400.0
2005-08-23 13:00:00	IWM	ETF	65.02	65.25	64.98	65.16	1380600.0
2005-08-23 14:00:00	IWM	ETF	65.16	65.55	65.13	65.5	2207100.0
2005-08-23 15:00:00	IWM	ETF	65.49	65.49	65.18	65.22	3467300.0
2005-08-23 16:00:00	IWM	ETF	65.21	65.47	65.21	65.45	116500.0
2005-08-23 17:00:00	IWM	ETF	65.4	65.4	65.4	65.4	100.0
2005-08-23 19:00:00	IWM	ETF	65.47	65.47	65.47	65.47	600.0
2005-08-23 08:00:00	DIA	ETF	105.67	105.67	105.67	105.67	1000.0
2005-08-23 09:00:00	DIA	ETF	105.66	105.73	105.28	105.34	788700.0
2005-08-23 10:00:00	DIA	ETF	105.33	105.57	105.21	105.37	1223500.0
2005-08-23 11:00:00	DIA	ETF	105.38	105.4	105.08	105.13	1239200.0
2005-08-23 12:00:00	DIA	ETF	105.11	105.16	104.91	105.11	892400.0
2005-08-23 13:00:00	DIA	ETF	105.1	105.31	105.03	105.19	570000.0
2005-08-23 14:00:00	DIA	ETF	105.16	105.51	105.14	105.45	946000.0
2005-08-23 15:00:00	DIA	ETF	105.43	105.44	105.14	105.14	1040500.0
2005-08-23 16:00:00	DIA	ETF	105.16	105.31	105.16	105.3	66900.0
2005-08-23 17:00:00	DIA	ETF	105.27	105.27	105.27	105.27	100.0
2005-08-23 08:00:00	GLD	ETF	43.84	43.84	43.84	43.84	300.0
2005-08-23 09:00:00	GLD	ETF	43.84	43.9	43.8	43.88	87700.0
2005-08-23 10:00:00	GLD	ETF	43.88	43.88	43.71	43.76	120200.0
2005-08-23 11:00:00	GLD	ETF	43.74	43.87	43.73	43.84	173300.0
2005-08-23 12:00:00	GLD	ETF	43.84	43.84	43.73	43.81	43500.0
2005-08-23 13:00:00	GLD	ETF	43.8	43.85	43.77	43.85	35900.0
2005-08-23 14:00:00	GLD	ETF	43.84	43.85	43.8	43.8	52700.0

> showing 50 of 939 rows — these rows as CSV

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