PREVIEW / etf_1hour / 2007-02-09

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-02-09.parquet
  size:    66 KB
  rows:    2,054

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
2007-02-09 04:00:00	SPY	ETF	145.16	145.16	145.16	145.16	400.0
2007-02-09 07:00:00	SPY	ETF	145.04	145.11	145.03	145.04	54900.0
2007-02-09 08:00:00	SPY	ETF	145.05	145.1	144.96	145.0	921700.0
2007-02-09 09:00:00	SPY	ETF	145.01	145.33	144.98	145.13	5208900.0
2007-02-09 10:00:00	SPY	ETF	145.11	145.21	144.82	144.85	10271200.0
2007-02-09 11:00:00	SPY	ETF	144.85	145.12	144.84	145.06	5030300.0
2007-02-09 12:00:00	SPY	ETF	145.06	145.07	144.35	144.47	9227500.0
2007-02-09 13:00:00	SPY	ETF	144.47	144.5	143.81	144.0	15968300.0
2007-02-09 14:00:00	SPY	ETF	144.0	144.06	143.39	143.56	13616900.0
2007-02-09 15:00:00	SPY	ETF	143.55	143.95	143.53	143.92	14829800.0
2007-02-09 16:00:00	SPY	ETF	143.93	144.01	143.85	143.96	2511200.0
2007-02-09 17:00:00	SPY	ETF	143.95	143.95	143.9	143.9	13900.0
2007-02-09 18:00:00	SPY	ETF	143.9	143.9	143.86	143.86	1500.0
2007-02-09 19:00:00	SPY	ETF	143.9	143.9	143.86	143.86	600.0
2007-02-09 05:00:00	QQQ	ETF	44.58	44.58	44.58	44.58	200.0
2007-02-09 07:00:00	QQQ	ETF	44.56	44.57	44.56	44.57	37922.0
2007-02-09 08:00:00	QQQ	ETF	44.57	44.59	44.55	44.56	806013.0
2007-02-09 09:00:00	QQQ	ETF	44.56	44.72	44.56	44.57	13925348.0
2007-02-09 10:00:00	QQQ	ETF	44.58	44.61	44.33	44.37	20391700.0
2007-02-09 11:00:00	QQQ	ETF	44.36	44.49	44.35	44.46	7338500.0
2007-02-09 12:00:00	QQQ	ETF	44.45	44.47	43.98	44.0	21130800.0
2007-02-09 13:00:00	QQQ	ETF	44.0	44.11	43.88	43.96	25565600.0
2007-02-09 14:00:00	QQQ	ETF	43.96	44.0	43.73	43.86	18681700.0
2007-02-09 15:00:00	QQQ	ETF	43.86	44.01	43.83	43.89	20713300.0
2007-02-09 16:00:00	QQQ	ETF	43.89	43.92	43.82	43.84	2000278.0
2007-02-09 17:00:00	QQQ	ETF	43.84	43.84	43.76	43.82	32971.0
2007-02-09 18:00:00	QQQ	ETF	43.8	43.84	43.8	43.8	15311.0
2007-02-09 19:00:00	QQQ	ETF	43.77	43.8	43.77	43.78	17378.0
2007-02-09 07:00:00	IWM	ETF	81.03	81.03	81.03	81.03	1000.0
2007-02-09 08:00:00	IWM	ETF	81.03	81.03	80.99	81.02	6300.0
2007-02-09 09:00:00	IWM	ETF	81.01	81.15	80.93	80.95	1893000.0
2007-02-09 10:00:00	IWM	ETF	80.95	81.05	80.73	80.76	6318500.0
2007-02-09 11:00:00	IWM	ETF	80.76	80.87	80.7	80.81	4654000.0
2007-02-09 12:00:00	IWM	ETF	80.81	80.95	80.12	80.16	8900100.0
2007-02-09 13:00:00	IWM	ETF	80.16	80.16	79.88	79.98	11133600.0
2007-02-09 14:00:00	IWM	ETF	79.99	80.03	79.7	79.84	6731500.0
2007-02-09 15:00:00	IWM	ETF	79.84	80.11	79.83	80.02	9629800.0
2007-02-09 16:00:00	IWM	ETF	80.02	80.3	80.02	80.24	1036300.0
2007-02-09 17:00:00	IWM	ETF	80.27	80.3	80.2	80.21	18800.0
2007-02-09 18:00:00	IWM	ETF	80.21	80.21	80.21	80.21	300.0
2007-02-09 08:00:00	DIA	ETF	126.54	126.54	126.48	126.52	8900.0
2007-02-09 09:00:00	DIA	ETF	126.5	126.79	126.46	126.62	448300.0
2007-02-09 10:00:00	DIA	ETF	126.64	126.75	126.49	126.52	734900.0
2007-02-09 11:00:00	DIA	ETF	126.52	126.72	126.51	126.66	453600.0
2007-02-09 12:00:00	DIA	ETF	126.66	126.67	126.22	126.25	695600.0
2007-02-09 13:00:00	DIA	ETF	126.25	126.3	125.75	125.92	1633700.0
2007-02-09 14:00:00	DIA	ETF	125.93	125.96	125.48	125.6	1529400.0
2007-02-09 15:00:00	DIA	ETF	125.62	125.94	125.59	125.88	996700.0
2007-02-09 16:00:00	DIA	ETF	125.9	125.95	125.88	125.89	40700.0
2007-02-09 18:00:00	DIA	ETF	125.89	125.89	125.86	125.86	4700.0

> showing 50 of 2,054 rows — these rows as CSV

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