PREVIEW / etf_1hour / 2006-05-12

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-12.parquet
  size:    47 KB
  rows:    1,410

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-05-12 05:00:00	SPY	ETF	130.37	130.4	130.37	130.4	8500.0
2006-05-12 06:00:00	SPY	ETF	130.55	130.55	130.43	130.43	37200.0
2006-05-12 07:00:00	SPY	ETF	130.5	130.6	130.46	130.52	98500.0
2006-05-12 08:00:00	SPY	ETF	130.443	130.8	130.443	130.54	1294900.0
2006-05-12 09:00:00	SPY	ETF	130.55	130.63	130.15	130.58	18910200.0
2006-05-12 10:00:00	SPY	ETF	130.59	130.72	129.82	130.11	24916500.0
2006-05-12 11:00:00	SPY	ETF	130.08	130.23	129.8	130.04	8990000.0
2006-05-12 12:00:00	SPY	ETF	130.03	130.28	129.54	129.67	8957400.0
2006-05-12 13:00:00	SPY	ETF	129.65	129.78	129.47	129.6	5879100.0
2006-05-12 14:00:00	SPY	ETF	129.61	130.1	129.5	129.5	7298700.0
2006-05-12 15:00:00	SPY	ETF	129.5	129.71	129.19	129.25	12088500.0
2006-05-12 16:00:00	SPY	ETF	129.249	129.37	129.18	129.28	991800.0
2006-05-12 17:00:00	SPY	ETF	129.29	129.29	129.18	129.2	12700.0
2006-05-12 18:00:00	SPY	ETF	129.19	129.24	129.18	129.24	2500.0
2006-05-12 19:00:00	SPY	ETF	129.18	129.18	129.16	129.18	2800.0
2006-05-12 09:00:00	QQQ	ETF	40.57	40.62	39.96	40.59	36885100.0
2006-05-12 10:00:00	QQQ	ETF	40.59	40.61	40.2	40.34	34721800.0
2006-05-12 11:00:00	QQQ	ETF	40.35	40.45	40.23	40.4	17094400.0
2006-05-12 12:00:00	QQQ	ETF	40.4	40.56	40.21	40.29	19123700.0
2006-05-12 13:00:00	QQQ	ETF	40.28	40.35	40.19	40.3	10091900.0
2006-05-12 14:00:00	QQQ	ETF	40.29	40.5	40.25	40.27	10981400.0
2006-05-12 15:00:00	QQQ	ETF	40.27	40.34	40.18	40.2	15223900.0
2006-05-12 08:00:00	IWM	ETF	74.94	75.0	74.85	74.91	210400.0
2006-05-12 09:00:00	IWM	ETF	74.9	74.9	74.18	74.6	13659500.0
2006-05-12 10:00:00	IWM	ETF	74.61	74.73	73.6	74.0	13602700.0
2006-05-12 11:00:00	IWM	ETF	74.0	74.17	73.74	74.03	7433200.0
2006-05-12 12:00:00	IWM	ETF	74.02	74.33	73.81	73.99	6043500.0
2006-05-12 13:00:00	IWM	ETF	73.99	74.22	73.79	73.81	3984900.0
2006-05-12 14:00:00	IWM	ETF	73.79	74.22	73.79	73.98	4895600.0
2006-05-12 15:00:00	IWM	ETF	73.93	74.1	73.67	73.74	7838700.0
2006-05-12 16:00:00	IWM	ETF	73.73	73.88	73.5	73.5	2068700.0
2006-05-12 17:00:00	IWM	ETF	73.51	73.51	73.51	73.51	100.0
2006-05-12 18:00:00	IWM	ETF	73.55	73.55	73.55	73.55	200.0
2006-05-12 07:00:00	DIA	ETF	114.92	114.95	114.89	114.91	31300.0
2006-05-12 08:00:00	DIA	ETF	114.9	115.12	114.89	114.98	44800.0
2006-05-12 09:00:00	DIA	ETF	114.96	115.03	114.62	114.9299	1475300.0
2006-05-12 10:00:00	DIA	ETF	114.92	115.06	114.33	114.61	2249300.0
2006-05-12 11:00:00	DIA	ETF	114.6	114.76	114.43	114.59	1155300.0
2006-05-12 12:00:00	DIA	ETF	114.58	114.76	114.09	114.2	1622800.0
2006-05-12 13:00:00	DIA	ETF	114.2	114.3	114.04	114.11	796400.0
2006-05-12 14:00:00	DIA	ETF	114.12	114.49	113.99	114.0	1022700.0
2006-05-12 15:00:00	DIA	ETF	114.0	114.16	113.85	113.89	1326800.0
2006-05-12 16:00:00	DIA	ETF	113.89	114.0	113.82	113.92	177500.0
2006-05-12 17:00:00	DIA	ETF	113.88	114.05	113.88	114.05	800.0
2006-05-12 19:00:00	DIA	ETF	113.88	113.88	113.88	113.88	700.0
2006-05-12 06:00:00	GLD	ETF	71.99	71.99	71.99	71.99	100.0
2006-05-12 07:00:00	GLD	ETF	72.0	72.5	72.0	72.24	65100.0
2006-05-12 08:00:00	GLD	ETF	72.24	72.48	71.0	71.75	1156600.0
2006-05-12 09:00:00	GLD	ETF	71.75	72.05	71.49	71.77	2389500.0
2006-05-12 10:00:00	GLD	ETF	71.75	72.26	71.03	71.22	4764000.0

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

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