PREVIEW / etf_1hour / 2008-02-08

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-08.parquet
  size:    98 KB
  rows:    3,307

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
2008-02-08 04:00:00	SPY	ETF	134.18	134.18	133.86	133.86	13200.0
2008-02-08 05:00:00	SPY	ETF	133.82	133.82	133.5	133.5	6000.0
2008-02-08 06:00:00	SPY	ETF	133.49	133.49	133.15	133.15	266500.0
2008-02-08 07:00:00	SPY	ETF	133.2	133.43	132.92	133.14	1861900.0
2008-02-08 08:00:00	SPY	ETF	133.14	133.4	132.74	133.11	4924300.0
2008-02-08 09:00:00	SPY	ETF	133.11	133.86	132.92	133.83	23600489.0
2008-02-08 10:00:00	SPY	ETF	133.83	134.02	133.4	133.74	23766747.0
2008-02-08 11:00:00	SPY	ETF	133.75	134.22	133.18	133.24	20241739.0
2008-02-08 12:00:00	SPY	ETF	133.23	133.38	132.78	133.29	22739319.0
2008-02-08 13:00:00	SPY	ETF	133.28	133.29	132.1	132.72	31673492.0
2008-02-08 14:00:00	SPY	ETF	132.72	133.21	132.45	132.63	20665133.0
2008-02-08 15:00:00	SPY	ETF	132.63	133.72	132.53	133.12	41841441.0
2008-02-08 16:00:00	SPY	ETF	133.08	133.7523	132.93	132.98	26366989.0
2008-02-08 17:00:00	SPY	ETF	132.95	133.04	132.94	133.02	35300.0
2008-02-08 18:00:00	SPY	ETF	133.02	133.02	132.9	132.9	15400.0
2008-02-08 19:00:00	SPY	ETF	132.98	133.05	132.96	133.05	4900.0
2008-02-08 05:00:00	QQQ	ETF	43.19	43.19	43.19	43.19	1000.0
2008-02-08 06:00:00	QQQ	ETF	43.1	43.1	43.06	43.08	13300.0
2008-02-08 07:00:00	QQQ	ETF	43.08	43.24	43.04	43.14	527598.0
2008-02-08 08:00:00	QQQ	ETF	43.14	43.28	43.07	43.18	1888641.0
2008-02-08 09:00:00	QQQ	ETF	43.17	43.57	43.05	43.5	30048205.0
2008-02-08 10:00:00	QQQ	ETF	43.5	43.7	43.31	43.66	23087216.0
2008-02-08 11:00:00	QQQ	ETF	43.66	43.77	43.35	43.36	17472317.0
2008-02-08 12:00:00	QQQ	ETF	43.36	43.47	43.25	43.45	17505914.0
2008-02-08 13:00:00	QQQ	ETF	43.44	43.45	42.94	43.2	26022643.0
2008-02-08 14:00:00	QQQ	ETF	43.2	43.4	43.1	43.2	18057858.0
2008-02-08 15:00:00	QQQ	ETF	43.2	43.68	43.11	43.6	33154625.0
2008-02-08 16:00:00	QQQ	ETF	43.6	43.64	43.51	43.55	5905536.0
2008-02-08 17:00:00	QQQ	ETF	43.58	43.59	43.56	43.59	16555.0
2008-02-08 18:00:00	QQQ	ETF	43.59	43.6	43.56	43.6	74290.0
2008-02-08 19:00:00	QQQ	ETF	43.6	43.6	43.56	43.6	14345.0
2008-02-08 07:00:00	IWM	ETF	69.76	69.98	69.67	69.91	78900.0
2008-02-08 08:00:00	IWM	ETF	69.9	69.95	69.7	69.79	324300.0
2008-02-08 09:00:00	IWM	ETF	69.79	70.51	69.66	70.45	8436796.0
2008-02-08 10:00:00	IWM	ETF	70.45	70.64	69.8	70.25	18026428.0
2008-02-08 11:00:00	IWM	ETF	70.25	70.63	69.78	69.79	8277278.0
2008-02-08 12:00:00	IWM	ETF	69.79	69.92	69.36	69.66	12649675.0
2008-02-08 13:00:00	IWM	ETF	69.66	69.67	69.0	69.42	9305669.0
2008-02-08 14:00:00	IWM	ETF	69.42	69.8	69.28	69.43	8343361.0
2008-02-08 15:00:00	IWM	ETF	69.44	70.04	69.28	69.55	15956389.0
2008-02-08 16:00:00	IWM	ETF	69.56	70.01	69.51	69.6	5089000.0
2008-02-08 17:00:00	IWM	ETF	69.57	69.62	69.56	69.62	5400.0
2008-02-08 18:00:00	IWM	ETF	69.62	69.62	69.62	69.62	100.0
2008-02-08 07:00:00	DIA	ETF	122.3	122.3	121.95	122.15	18900.0
2008-02-08 08:00:00	DIA	ETF	122.12	122.24	121.83	122.05	32900.0
2008-02-08 09:00:00	DIA	ETF	122.08	122.49	121.77	122.48	1874480.0
2008-02-08 10:00:00	DIA	ETF	122.47	122.67	122.15	122.49	2447430.0
2008-02-08 11:00:00	DIA	ETF	122.5	122.88	122.03	122.06	1570782.0
2008-02-08 12:00:00	DIA	ETF	122.05	122.12	121.55	121.98	1419423.0
2008-02-08 13:00:00	DIA	ETF	121.98	121.98	121.08	121.5	2558429.0

> showing 50 of 3,307 rows — these rows as CSV

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