PREVIEW / etf_1hour / 2007-02-08

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-02-08.parquet
  size:    64 KB
  rows:    2,026

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-08 05:00:00	SPY	ETF	145.01	145.01	145.01	145.01	10000.0
2007-02-08 06:00:00	SPY	ETF	145.05	145.05	145.05	145.05	4900.0
2007-02-08 07:00:00	SPY	ETF	145.04	145.04	144.76	144.79	222100.0
2007-02-08 08:00:00	SPY	ETF	144.77	145.0	144.77	144.8	1121400.0
2007-02-08 09:00:00	SPY	ETF	144.8	144.84	144.27	144.56	10855000.0
2007-02-08 10:00:00	SPY	ETF	144.55	144.73	144.34	144.48	12122800.0
2007-02-08 11:00:00	SPY	ETF	144.47	144.57	144.32	144.48	7254000.0
2007-02-08 12:00:00	SPY	ETF	144.49	144.81	144.4	144.67	6716900.0
2007-02-08 13:00:00	SPY	ETF	144.67	144.91	144.66	144.77	7808500.0
2007-02-08 14:00:00	SPY	ETF	144.76	145.12	144.62	145.0	12310100.0
2007-02-08 15:00:00	SPY	ETF	145.0	145.01	144.73	144.88	9463600.0
2007-02-08 16:00:00	SPY	ETF	144.88	145.04	144.87	144.99	1217600.0
2007-02-08 17:00:00	SPY	ETF	144.99	145.0	144.94	144.98	59500.0
2007-02-08 18:00:00	SPY	ETF	144.98	144.98	144.95	144.97	6800.0
2007-02-08 06:00:00	QQQ	ETF	44.46	44.46	44.46	44.46	3289.0
2007-02-08 07:00:00	QQQ	ETF	44.47	44.47	44.36	44.42	772048.0
2007-02-08 08:00:00	QQQ	ETF	44.4	44.46	44.4	44.4	1378949.0
2007-02-08 09:00:00	QQQ	ETF	44.41	44.49	44.23	44.31	17961283.0
2007-02-08 10:00:00	QQQ	ETF	44.32	44.45	44.28	44.38	14778800.0
2007-02-08 11:00:00	QQQ	ETF	44.38	44.44	44.29	44.37	7501100.0
2007-02-08 12:00:00	QQQ	ETF	44.37	44.53	44.32	44.48	7559700.0
2007-02-08 13:00:00	QQQ	ETF	44.48	44.57	44.43	44.5	8384500.0
2007-02-08 14:00:00	QQQ	ETF	44.5	44.6	44.41	44.58	19156800.0
2007-02-08 15:00:00	QQQ	ETF	44.59	44.59	44.45	44.51	9992200.0
2007-02-08 16:00:00	QQQ	ETF	44.51	44.57	44.47	44.53	1297018.0
2007-02-08 17:00:00	QQQ	ETF	44.54	44.56	44.52	44.52	145289.0
2007-02-08 18:00:00	QQQ	ETF	44.53	44.54	44.52	44.52	17016.0
2007-02-08 19:00:00	QQQ	ETF	44.53	44.56	44.53	44.55	20675.0
2007-02-08 08:00:00	IWM	ETF	80.98	81.0	80.9	80.9	104400.0
2007-02-08 09:00:00	IWM	ETF	80.9	81.0	80.58	80.71	3106000.0
2007-02-08 10:00:00	IWM	ETF	80.71	80.95	80.6	80.69	6128800.0
2007-02-08 11:00:00	IWM	ETF	80.68	80.93	80.59	80.86	3418700.0
2007-02-08 12:00:00	IWM	ETF	80.86	80.97	80.78	80.88	2987800.0
2007-02-08 13:00:00	IWM	ETF	80.88	81.05	80.84	80.88	1478600.0
2007-02-08 14:00:00	IWM	ETF	80.88	81.14	80.84	81.09	3193000.0
2007-02-08 15:00:00	IWM	ETF	81.09	81.1	80.9	81.04	3527900.0
2007-02-08 16:00:00	IWM	ETF	81.04	81.09	80.99	81.04	279300.0
2007-02-08 17:00:00	IWM	ETF	81.05	81.05	81.04	81.04	511100.0
2007-02-08 18:00:00	IWM	ETF	81.03	81.04	80.98	81.02	12500.0
2007-02-08 19:00:00	IWM	ETF	81.02	81.02	81.01	81.01	4000.0
2007-02-08 07:00:00	DIA	ETF	126.69	126.69	126.68	126.68	3500.0
2007-02-08 08:00:00	DIA	ETF	126.59	126.67	126.59	126.6	27900.0
2007-02-08 09:00:00	DIA	ETF	126.57	126.58	126.29	126.4	621100.0
2007-02-08 10:00:00	DIA	ETF	126.39	126.47	125.78	125.92	1670700.0
2007-02-08 11:00:00	DIA	ETF	125.93	126.07	125.81	126.03	820900.0
2007-02-08 12:00:00	DIA	ETF	126.02	126.25	125.96	126.2	810700.0
2007-02-08 13:00:00	DIA	ETF	126.2	126.36	126.17	126.25	585000.0
2007-02-08 14:00:00	DIA	ETF	126.25	126.56	126.11	126.43	953200.0
2007-02-08 15:00:00	DIA	ETF	126.43	126.49	126.28	126.43	757800.0
2007-02-08 16:00:00	DIA	ETF	126.43	126.49	126.42	126.47	20400.0

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

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