PREVIEW / etf_1hour / 2006-03-24

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-03-24.parquet
  size:    39 KB
  rows:    1,234

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
2006-03-24 06:00:00	SPY	ETF	129.99	129.99	129.97	129.97	8500.0
2006-03-24 07:00:00	SPY	ETF	129.89	130.02	129.89	129.95	50400.0
2006-03-24 08:00:00	SPY	ETF	130.0	130.02	129.91	129.99	1183800.0
2006-03-24 09:00:00	SPY	ETF	129.97	130.1	129.74	129.82	4260100.0
2006-03-24 10:00:00	SPY	ETF	129.82	130.57	129.81	130.47	11843400.0
2006-03-24 11:00:00	SPY	ETF	130.47	130.55	130.25	130.31	4427300.0
2006-03-24 12:00:00	SPY	ETF	130.31	130.38	130.06	130.17	3721100.0
2006-03-24 13:00:00	SPY	ETF	130.16	130.17	129.76	130.03	6262600.0
2006-03-24 14:00:00	SPY	ETF	130.06	130.23	129.87	130.1	3785400.0
2006-03-24 15:00:00	SPY	ETF	130.1	130.34	130.05	130.15	5164600.0
2006-03-24 16:00:00	SPY	ETF	130.16	130.27	130.1025	130.23	487200.0
2006-03-24 17:00:00	SPY	ETF	130.21	130.24	130.21	130.21	11400.0
2006-03-24 18:00:00	SPY	ETF	130.25	130.26	130.21	130.26	4500.0
2006-03-24 19:00:00	SPY	ETF	130.25	130.28	130.25	130.28	2000.0
2006-03-24 09:00:00	QQQ	ETF	41.23	41.26	41.1	41.19	12946200.0
2006-03-24 10:00:00	QQQ	ETF	41.19	41.5	41.15	41.47	22297500.0
2006-03-24 11:00:00	QQQ	ETF	41.47	41.48	41.25	41.34	11636000.0
2006-03-24 12:00:00	QQQ	ETF	41.33	41.36	41.19	41.26	7532400.0
2006-03-24 13:00:00	QQQ	ETF	41.26	41.26	41.02	41.15	9816400.0
2006-03-24 14:00:00	QQQ	ETF	41.15	41.25	41.08	41.18	6629600.0
2006-03-24 15:00:00	QQQ	ETF	41.18	41.32	41.16	41.29	7432000.0
2006-03-24 08:00:00	IWM	ETF	74.44	74.46	74.28	74.32	106100.0
2006-03-24 09:00:00	IWM	ETF	74.3	74.36	74.1	74.26	2339000.0
2006-03-24 10:00:00	IWM	ETF	74.27	74.7	74.2	74.62	6533000.0
2006-03-24 11:00:00	IWM	ETF	74.62	74.73	74.47	74.55	1940800.0
2006-03-24 12:00:00	IWM	ETF	74.54	74.58	74.32	74.4	2389500.0
2006-03-24 13:00:00	IWM	ETF	74.4	74.55	74.24	74.51	1890100.0
2006-03-24 14:00:00	IWM	ETF	74.5	74.77	74.44	74.68	3157700.0
2006-03-24 15:00:00	IWM	ETF	74.69	74.84	74.64	74.84	4820400.0
2006-03-24 16:00:00	IWM	ETF	74.84	74.92	74.82	74.91	3782000.0
2006-03-24 17:00:00	IWM	ETF	74.9	74.91	74.9	74.91	700.0
2006-03-24 18:00:00	IWM	ETF	74.92	74.92	74.92	74.92	100.0
2006-03-24 07:00:00	DIA	ETF	112.65	112.65	112.65	112.65	300.0
2006-03-24 08:00:00	DIA	ETF	112.65	112.67	112.6	112.64	16600.0
2006-03-24 09:00:00	DIA	ETF	112.69	112.74	112.35	112.43	499200.0
2006-03-24 10:00:00	DIA	ETF	112.44	113.0	112.42	112.99	1297500.0
2006-03-24 11:00:00	DIA	ETF	112.99	113.08	112.87	112.9	617600.0
2006-03-24 12:00:00	DIA	ETF	112.9	112.98	112.6	112.65	380900.0
2006-03-24 13:00:00	DIA	ETF	112.65	112.65	112.34	112.55	799900.0
2006-03-24 14:00:00	DIA	ETF	112.54	112.69	112.42	112.59	511300.0
2006-03-24 15:00:00	DIA	ETF	112.6	112.87	112.58	112.66	504500.0
2006-03-24 16:00:00	DIA	ETF	112.66	112.76	112.66	112.73	5000.0
2006-03-24 17:00:00	DIA	ETF	112.78	112.78	112.78	112.78	1100.0
2006-03-24 19:00:00	DIA	ETF	112.72	112.75	112.72	112.75	600.0
2006-03-24 07:00:00	GLD	ETF	54.72	54.72	54.72	54.72	2000.0
2006-03-24 08:00:00	GLD	ETF	54.96	55.01	54.91	54.91	8000.0
2006-03-24 09:00:00	GLD	ETF	54.95	55.25	54.92	55.21	647500.0
2006-03-24 10:00:00	GLD	ETF	55.22	55.71	55.22	55.58	1480500.0
2006-03-24 11:00:00	GLD	ETF	55.57	55.75	55.57	55.75	503200.0
2006-03-24 12:00:00	GLD	ETF	55.75	55.83	55.62	55.79	498100.0

> showing 50 of 1,234 rows — these rows as CSV

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