PREVIEW / etf_1hour / 2006-10-02

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-10-02.parquet
  size:    53 KB
  rows:    1,668

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-10-02 07:00:00	SPY	ETF	133.66	133.66	133.45	133.45	15600.0
2006-10-02 08:00:00	SPY	ETF	133.46	133.8	133.37	133.43	278200.0
2006-10-02 09:00:00	SPY	ETF	133.42	133.56	133.38	133.46	3992300.0
2006-10-02 10:00:00	SPY	ETF	133.46	133.61	133.36	133.55	7917500.0
2006-10-02 11:00:00	SPY	ETF	133.54	133.83	133.45	133.7	8078600.0
2006-10-02 12:00:00	SPY	ETF	133.67	133.81	133.64	133.71	2164700.0
2006-10-02 13:00:00	SPY	ETF	133.71	133.75	133.05	133.16	8654900.0
2006-10-02 14:00:00	SPY	ETF	133.15	133.24	132.96	133.03	4572200.0
2006-10-02 15:00:00	SPY	ETF	133.02	133.3	132.95	133.07	6359600.0
2006-10-02 16:00:00	SPY	ETF	133.07	133.13	133.02	133.04	4840800.0
2006-10-02 17:00:00	SPY	ETF	133.04	133.48	133.02	133.02	16700.0
2006-10-02 18:00:00	SPY	ETF	133.02	133.09	133.02	133.09	757100.0
2006-10-02 19:00:00	SPY	ETF	133.08	133.1	133.08	133.1	1000.0
2006-10-02 09:00:00	QQQ	ETF	40.6	40.62	40.44	40.51	9591200.0
2006-10-02 10:00:00	QQQ	ETF	40.52	40.62	40.46	40.53	13432900.0
2006-10-02 11:00:00	QQQ	ETF	40.53	40.7	40.48	40.65	10284100.0
2006-10-02 12:00:00	QQQ	ETF	40.64	40.7	40.58	40.59	4740100.0
2006-10-02 13:00:00	QQQ	ETF	40.59	40.61	40.11	40.16	18027600.0
2006-10-02 14:00:00	QQQ	ETF	40.17	40.24	40.08	40.16	16436100.0
2006-10-02 15:00:00	QQQ	ETF	40.15	40.27	40.11	40.15	15395100.0
2006-10-02 07:00:00	IWM	ETF	71.93	71.93	71.93	71.93	1000.0
2006-10-02 08:00:00	IWM	ETF	72.0	72.0	71.82	71.84	345600.0
2006-10-02 09:00:00	IWM	ETF	71.88	72.0	71.5	71.63	5018400.0
2006-10-02 10:00:00	IWM	ETF	71.64	72.0	71.57	71.92	6638500.0
2006-10-02 11:00:00	IWM	ETF	71.92	72.21	71.86	72.11	3606600.0
2006-10-02 12:00:00	IWM	ETF	72.11	72.21	72.04	72.06	1683300.0
2006-10-02 13:00:00	IWM	ETF	72.07	72.15	71.54	71.64	5602900.0
2006-10-02 14:00:00	IWM	ETF	71.63	71.67	71.14	71.23	10951900.0
2006-10-02 15:00:00	IWM	ETF	71.24	71.52	71.21	71.38	4600000.0
2006-10-02 16:00:00	IWM	ETF	71.38	72.0782	71.25	71.31	1270200.0
2006-10-02 17:00:00	IWM	ETF	71.28	71.29	71.27	71.27	8300.0
2006-10-02 18:00:00	IWM	ETF	71.3	71.3	71.3	71.3	10000.0
2006-10-02 19:00:00	IWM	ETF	71.28	71.28	71.28	71.28	100.0
2006-10-02 07:00:00	DIA	ETF	116.67	116.67	116.67	116.67	500.0
2006-10-02 08:00:00	DIA	ETF	116.74	116.78	116.55	116.66	10000.0
2006-10-02 09:00:00	DIA	ETF	116.68	116.8	116.57	116.71	845500.0
2006-10-02 10:00:00	DIA	ETF	116.7	117.0	116.65	116.95	1332100.0
2006-10-02 11:00:00	DIA	ETF	116.95	117.2	116.86	117.08	1257900.0
2006-10-02 12:00:00	DIA	ETF	117.08	117.16	117.03	117.05	788400.0
2006-10-02 13:00:00	DIA	ETF	117.06	117.13	116.47	116.59	633000.0
2006-10-02 14:00:00	DIA	ETF	116.6	116.78	116.51	116.63	1504900.0
2006-10-02 15:00:00	DIA	ETF	116.62	116.82	116.58	116.67	571500.0
2006-10-02 16:00:00	DIA	ETF	116.68	116.68	116.58	116.65	65500.0
2006-10-02 17:00:00	DIA	ETF	116.6	116.6	116.6	116.6	500.0
2006-10-02 08:00:00	GLD	ETF	59.75	59.98	59.75	59.94	26400.0
2006-10-02 09:00:00	GLD	ETF	59.93	59.93	59.71	59.8	287300.0
2006-10-02 10:00:00	GLD	ETF	59.83	59.86	59.52	59.5906	378800.0
2006-10-02 11:00:00	GLD	ETF	59.59	59.62	59.26	59.35	385500.0
2006-10-02 12:00:00	GLD	ETF	59.35	59.6	59.24	59.55	313600.0
2006-10-02 13:00:00	GLD	ETF	59.5	59.5	59.32	59.34	177800.0

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

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