PREVIEW / etf_1hour / 2008-02-11

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-11.parquet
  size:    97 KB
  rows:    3,256

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-11 04:00:00	SPY	ETF	132.86	132.93	132.73	132.73	7900.0
2008-02-11 05:00:00	SPY	ETF	133.1	133.1	133.1	133.1	100.0
2008-02-11 06:00:00	SPY	ETF	133.06	133.06	132.81	132.95	55000.0
2008-02-11 07:00:00	SPY	ETF	132.87	133.57	132.81	133.47	613100.0
2008-02-11 08:00:00	SPY	ETF	133.45	133.59	132.95	133.35	2606500.0
2008-02-11 09:00:00	SPY	ETF	133.34	133.8	132.25	132.56	26022824.0
2008-02-11 10:00:00	SPY	ETF	132.55	132.83	132.04	132.77	33089851.0
2008-02-11 11:00:00	SPY	ETF	132.77	133.31	132.66	132.84	25056415.0
2008-02-11 12:00:00	SPY	ETF	132.84	133.94	132.84	133.8799	21327565.0
2008-02-11 13:00:00	SPY	ETF	133.87	134.2	133.65	133.9	16034689.0
2008-02-11 14:00:00	SPY	ETF	133.91	134.12	133.45	133.73	20742370.0
2008-02-11 15:00:00	SPY	ETF	133.72	134.23	133.5	133.91	29319707.0
2008-02-11 16:00:00	SPY	ETF	133.84	134.01	133.2	133.63	8073900.0
2008-02-11 17:00:00	SPY	ETF	133.63	133.75	133.61	133.69	141400.0
2008-02-11 18:00:00	SPY	ETF	133.75	133.8	133.65	133.71	16700.0
2008-02-11 19:00:00	SPY	ETF	133.73	133.77	133.58	133.72	51200.0
2008-02-11 04:00:00	QQQ	ETF	43.45	43.45	43.45	43.45	4000.0
2008-02-11 05:00:00	QQQ	ETF	43.63	43.63	43.61	43.61	400.0
2008-02-11 06:00:00	QQQ	ETF	43.6	43.6	43.57	43.59	28400.0
2008-02-11 07:00:00	QQQ	ETF	43.58	43.75	43.58	43.72	216898.0
2008-02-11 08:00:00	QQQ	ETF	43.72	43.92	43.72	43.84	1612496.0
2008-02-11 09:00:00	QQQ	ETF	43.84	43.9	43.62	43.74	19172594.0
2008-02-11 10:00:00	QQQ	ETF	43.73	43.85	43.54	43.82	19964128.0
2008-02-11 11:00:00	QQQ	ETF	43.82	43.93	43.67	43.71	12602772.0
2008-02-11 12:00:00	QQQ	ETF	43.72	44.0699	43.71	44.05	13714032.0
2008-02-11 13:00:00	QQQ	ETF	44.06	44.17	44.0	44.09	10341324.0
2008-02-11 14:00:00	QQQ	ETF	44.09	44.22	43.96	44.04	13499787.0
2008-02-11 15:00:00	QQQ	ETF	44.05	44.19	43.93	44.06	23075872.0
2008-02-11 16:00:00	QQQ	ETF	44.06	44.13	43.83	44.04	5816476.0
2008-02-11 17:00:00	QQQ	ETF	44.02	44.06	44.02	44.03	61633.0
2008-02-11 18:00:00	QQQ	ETF	44.03	44.05	44.01	44.05	9989.0
2008-02-11 19:00:00	QQQ	ETF	44.02	44.06	44.01	44.02	40532.0
2008-02-11 06:00:00	IWM	ETF	69.45	69.45	69.45	69.45	200.0
2008-02-11 07:00:00	IWM	ETF	69.68	69.88	69.68	69.88	12500.0
2008-02-11 08:00:00	IWM	ETF	69.86	70.0	69.79	69.83	326700.0
2008-02-11 09:00:00	IWM	ETF	69.81	69.81	68.75	69.0	10775137.0
2008-02-11 10:00:00	IWM	ETF	68.99	69.96	68.73	69.29	10846397.0
2008-02-11 11:00:00	IWM	ETF	69.29	69.52	69.06	69.13	9338282.0
2008-02-11 12:00:00	IWM	ETF	69.14	69.8	69.0	69.72	6927356.0
2008-02-11 13:00:00	IWM	ETF	69.72	70.14	69.62	69.98	12200243.0
2008-02-11 14:00:00	IWM	ETF	69.98	70.2	69.59	69.66	9727318.0
2008-02-11 15:00:00	IWM	ETF	69.66	70.02	69.49	69.62	14593171.0
2008-02-11 16:00:00	IWM	ETF	69.62	69.8	69.0	69.56	6054200.0
2008-02-11 17:00:00	IWM	ETF	69.58	69.64	69.58	69.62	2700.0
2008-02-11 18:00:00	IWM	ETF	69.59	69.6	69.59	69.6	1500.0
2008-02-11 07:00:00	DIA	ETF	121.99	122.19	121.91	122.19	2200.0
2008-02-11 08:00:00	DIA	ETF	122.11	122.25	122.0	122.03	16600.0
2008-02-11 09:00:00	DIA	ETF	121.99	122.0	120.97	121.19	2152652.0
2008-02-11 10:00:00	DIA	ETF	121.16	121.36	120.76	121.32	2158335.0
2008-02-11 11:00:00	DIA	ETF	121.32	121.67	121.23	121.31	1494632.0

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

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