PREVIEW / etf_1hour / 2008-02-12

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-02-12.parquet
  size:    99 KB
  rows:    3,298

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-12 05:00:00	SPY	ETF	133.52	133.52	133.52	133.52	300.0
2008-02-12 06:00:00	SPY	ETF	133.91	134.45	133.91	134.29	33800.0
2008-02-12 07:00:00	SPY	ETF	134.34	134.59	134.0	134.04	1496800.0
2008-02-12 08:00:00	SPY	ETF	134.05	135.17	133.45	134.83	15885900.0
2008-02-12 09:00:00	SPY	ETF	134.82	135.19	134.56	135.13	24944353.0
2008-02-12 10:00:00	SPY	ETF	135.15	136.3	135.12	136.1885	43765632.0
2008-02-12 11:00:00	SPY	ETF	136.19	136.31	135.73	135.8	23092138.0
2008-02-12 12:00:00	SPY	ETF	135.8	135.94	135.0	135.48	26436223.0
2008-02-12 13:00:00	SPY	ETF	135.48	135.94	135.45	135.91	20462577.0
2008-02-12 14:00:00	SPY	ETF	135.91	135.92	135.08	135.77	24446113.0
2008-02-12 15:00:00	SPY	ETF	135.76	135.78	133.98	134.94	64543252.0
2008-02-12 16:00:00	SPY	ETF	135.0	135.19	134.73	135.05	7543600.0
2008-02-12 17:00:00	SPY	ETF	135.05	135.1	134.95	134.97	124500.0
2008-02-12 18:00:00	SPY	ETF	134.97	134.98	134.81	134.87	159800.0
2008-02-12 19:00:00	SPY	ETF	134.84	134.86	134.6	134.66	91600.0
2008-02-12 06:00:00	QQQ	ETF	44.23	44.23	44.23	44.23	10000.0
2008-02-12 07:00:00	QQQ	ETF	44.25	44.29	44.19	44.21	117791.0
2008-02-12 08:00:00	QQQ	ETF	43.95	44.56	43.95	44.42	3255384.0
2008-02-12 09:00:00	QQQ	ETF	44.42	44.43	44.25	44.3	17109382.0
2008-02-12 10:00:00	QQQ	ETF	44.3	44.58	44.29	44.56	21936548.0
2008-02-12 11:00:00	QQQ	ETF	44.56	44.57	44.42	44.425	12814198.0
2008-02-12 12:00:00	QQQ	ETF	44.42	44.47	44.13	44.27	16136245.0
2008-02-12 13:00:00	QQQ	ETF	44.27	44.36	44.21	44.32	9517254.0
2008-02-12 14:00:00	QQQ	ETF	44.32	44.32	44.06	44.24	13094532.0
2008-02-12 15:00:00	QQQ	ETF	44.23	44.23	43.51	43.81	45494283.0
2008-02-12 16:00:00	QQQ	ETF	43.82	44.1586	43.6318	43.94	7722393.0
2008-02-12 17:00:00	QQQ	ETF	43.96	43.97	43.92	43.94	111366.0
2008-02-12 18:00:00	QQQ	ETF	43.94	43.94	43.89	43.91	72967.0
2008-02-12 19:00:00	QQQ	ETF	43.91	43.91	43.86	43.86	26114.0
2008-02-12 06:00:00	IWM	ETF	69.92	69.92	69.87	69.87	7500.0
2008-02-12 07:00:00	IWM	ETF	69.95	70.03	69.76	69.81	109500.0
2008-02-12 08:00:00	IWM	ETF	69.65	70.39	69.65	70.16	375000.0
2008-02-12 09:00:00	IWM	ETF	70.15	70.35	69.79	70.17	7081832.0
2008-02-12 10:00:00	IWM	ETF	70.16	70.92	70.16	70.88	11908406.0
2008-02-12 11:00:00	IWM	ETF	70.88	70.97	70.61	70.67	6781331.0
2008-02-12 12:00:00	IWM	ETF	70.66	70.76	70.24	70.51	9170563.0
2008-02-12 13:00:00	IWM	ETF	70.52	71.05	70.52	71.02	6532388.0
2008-02-12 14:00:00	IWM	ETF	71.01	71.01	70.4	70.94	9926393.0
2008-02-12 15:00:00	IWM	ETF	70.93	70.94	69.72	70.19	22814714.0
2008-02-12 16:00:00	IWM	ETF	70.19	70.54	70.19	70.47	2194200.0
2008-02-12 17:00:00	IWM	ETF	70.42	70.47	70.42	70.43	3800.0
2008-02-12 18:00:00	IWM	ETF	70.41	70.41	70.38	70.41	3900.0
2008-02-12 19:00:00	IWM	ETF	70.36	70.36	70.25	70.34	5400.0
2008-02-12 07:00:00	DIA	ETF	122.7	122.7	122.58	122.58	500.0
2008-02-12 08:00:00	DIA	ETF	122.51	123.36	122.51	123.13	74600.0
2008-02-12 09:00:00	DIA	ETF	123.12	123.55	122.96	123.5	1543071.0
2008-02-12 10:00:00	DIA	ETF	123.53	124.7	123.49	124.65	3583268.0
2008-02-12 11:00:00	DIA	ETF	124.66	124.74	124.2	124.42	1915650.0
2008-02-12 12:00:00	DIA	ETF	124.42	124.5	123.91	124.22	1632877.0
2008-02-12 13:00:00	DIA	ETF	124.23	124.58	124.21	124.5	1545663.0

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

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