PREVIEW / etf_1hour / 2008-06-27

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-27.parquet
  size:    110 KB
  rows:    3,546

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-06-27 04:00:00	SPY	ETF	128.37	128.66	128.3	128.66	8100.0
2008-06-27 05:00:00	SPY	ETF	128.52	128.52	128.15	128.45	25500.0
2008-06-27 06:00:00	SPY	ETF	128.38	128.56	128.33	128.33	153900.0
2008-06-27 07:00:00	SPY	ETF	128.31	128.31	127.58	127.82	1316812.0
2008-06-27 08:00:00	SPY	ETF	127.84	128.46	127.67	128.38	8449740.0
2008-06-27 09:00:00	SPY	ETF	128.38	128.58	127.79	128.44	32542704.0
2008-06-27 10:00:00	SPY	ETF	128.455	128.86	127.75	127.91	50242804.0
2008-06-27 11:00:00	SPY	ETF	127.9197	128.25	127.66	128.06	33205013.0
2008-06-27 12:00:00	SPY	ETF	128.06	128.43	127.74	127.89	21745435.0
2008-06-27 13:00:00	SPY	ETF	127.88	127.93	127.035	127.36	43505907.0
2008-06-27 14:00:00	SPY	ETF	127.36	128.27	127.2	128.14	44232165.0
2008-06-27 15:00:00	SPY	ETF	128.13	128.24	127.5	127.8	47294974.0
2008-06-27 16:00:00	SPY	ETF	127.811	127.96	127.45	127.78	10543072.0
2008-06-27 17:00:00	SPY	ETF	127.77	127.88	127.73	127.76	228031.0
2008-06-27 18:00:00	SPY	ETF	127.73	127.79	127.7	127.74	11200.0
2008-06-27 19:00:00	SPY	ETF	127.79	127.91	127.75	127.89	10272.0
2008-06-27 04:00:00	QQQ	ETF	45.8	45.82	45.75	45.8	4100.0
2008-06-27 05:00:00	QQQ	ETF	45.8	45.86	45.69	45.78	102997.0
2008-06-27 06:00:00	QQQ	ETF	45.73	45.81	45.73	45.76	4400.0
2008-06-27 07:00:00	QQQ	ETF	45.74	45.74	45.4	45.54	768249.0
2008-06-27 08:00:00	QQQ	ETF	45.55	45.72	45.47	45.65	3349591.0
2008-06-27 09:00:00	QQQ	ETF	45.64	45.73	45.28	45.65	20157736.0
2008-06-27 10:00:00	QQQ	ETF	45.65	45.9	45.28	45.4	31823766.0
2008-06-27 11:00:00	QQQ	ETF	45.4	45.55	45.26	45.48	12756069.0
2008-06-27 12:00:00	QQQ	ETF	45.48	45.67	45.33	45.41	14219515.0
2008-06-27 13:00:00	QQQ	ETF	45.41	45.42	44.97	45.11	18559698.0
2008-06-27 14:00:00	QQQ	ETF	45.11	45.72	45.1	45.72	33085736.0
2008-06-27 15:00:00	QQQ	ETF	45.72	45.8	45.45	45.64	26322962.0
2008-06-27 16:00:00	QQQ	ETF	45.66	45.8	45.4676	45.79	7335883.0
2008-06-27 17:00:00	QQQ	ETF	45.8	45.87	45.8	45.8	154878.0
2008-06-27 18:00:00	QQQ	ETF	45.8	45.8	45.74	45.78	30970.0
2008-06-27 19:00:00	QQQ	ETF	45.79	45.79	45.75	45.78	4540.0
2008-06-27 05:00:00	IWM	ETF	69.71	69.71	69.71	69.71	300.0
2008-06-27 07:00:00	IWM	ETF	69.59	69.62	69.25	69.44	316953.0
2008-06-27 08:00:00	IWM	ETF	69.46	69.88	69.38	69.82	974334.0
2008-06-27 09:00:00	IWM	ETF	69.82	69.95	69.0	69.75	13745495.0
2008-06-27 10:00:00	IWM	ETF	69.76	70.25	69.35	69.45	21243894.0
2008-06-27 11:00:00	IWM	ETF	69.44	69.66	69.3	69.51	9122841.0
2008-06-27 12:00:00	IWM	ETF	69.51	69.75	69.48	69.56	9081586.0
2008-06-27 13:00:00	IWM	ETF	69.56	69.59	69.2	69.44	10970424.0
2008-06-27 14:00:00	IWM	ETF	69.44	70.04	69.38	69.89	17284521.0
2008-06-27 15:00:00	IWM	ETF	69.89	70.0	69.67	69.79	18926365.0
2008-06-27 16:00:00	IWM	ETF	69.79	70.57	69.64	69.89	10684784.0
2008-06-27 17:00:00	IWM	ETF	69.9	70.0	69.9	70.0	141900.0
2008-06-27 06:00:00	DIA	ETF	114.7	114.76	114.7	114.76	200.0
2008-06-27 07:00:00	DIA	ETF	114.45	114.45	114.0	114.23	4924.0
2008-06-27 08:00:00	DIA	ETF	114.2	114.67	114.12	114.65	141239.0
2008-06-27 09:00:00	DIA	ETF	114.63	114.74	113.96	114.4	2658142.0
2008-06-27 10:00:00	DIA	ETF	114.4	114.71	113.72	113.8	4030489.0
2008-06-27 11:00:00	DIA	ETF	113.79	114.07	113.56	113.91	3032733.0

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

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