PREVIEW / etf_1hour / 2008-12-09

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-09.parquet
  size:    118 KB
  rows:    3,835

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-12-09 05:00:00	SPY	ETF	91.09	91.5	91.07	91.5	4800.0
2008-12-09 06:00:00	SPY	ETF	91.64	91.68	91.21	91.39	170520.0
2008-12-09 07:00:00	SPY	ETF	91.35	91.51	91.23	91.27	622076.0
2008-12-09 08:00:00	SPY	ETF	91.1	91.48	90.11	90.52	4243485.0
2008-12-09 09:00:00	SPY	ETF	90.53	90.94	89.89	90.13	31774584.0
2008-12-09 10:00:00	SPY	ETF	90.13	92.06	89.95	91.82	51597245.0
2008-12-09 11:00:00	SPY	ETF	91.82	92.13	90.67	91.119	38185325.0
2008-12-09 12:00:00	SPY	ETF	91.12	91.56	90.76	90.91	34225605.0
2008-12-09 13:00:00	SPY	ETF	90.92	91.18	90.01	90.27	36883111.0
2008-12-09 14:00:00	SPY	ETF	90.28	90.3	88.98	90.1	56172074.0
2008-12-09 15:00:00	SPY	ETF	90.09	90.53	89.02	89.4	91629834.0
2008-12-09 16:00:00	SPY	ETF	89.45	91.3756	89.37	89.58	15860253.0
2008-12-09 17:00:00	SPY	ETF	89.58	89.84	89.47	89.71	3386884.0
2008-12-09 18:00:00	SPY	ETF	89.73	89.8	89.42	89.59	175714.0
2008-12-09 19:00:00	SPY	ETF	89.59	89.78	89.56	89.58	43120.0
2008-12-09 04:00:00	QQQ	ETF	29.75	29.93	29.75	29.93	500.0
2008-12-09 05:00:00	QQQ	ETF	30.09	30.09	30.09	30.09	290.0
2008-12-09 06:00:00	QQQ	ETF	30.11	30.11	29.96	29.99	101726.0
2008-12-09 07:00:00	QQQ	ETF	29.98	30.1	29.91	29.96	162026.0
2008-12-09 08:00:00	QQQ	ETF	29.9	29.95	29.58	29.63	987958.0
2008-12-09 09:00:00	QQQ	ETF	29.63	30.1	29.57	29.95	18290088.0
2008-12-09 10:00:00	QQQ	ETF	29.94	30.81	29.93	30.72	29712931.0
2008-12-09 11:00:00	QQQ	ETF	30.72	30.83	30.241	30.41	18817666.0
2008-12-09 12:00:00	QQQ	ETF	30.41	30.61	30.29	30.3399	13197390.0
2008-12-09 13:00:00	QQQ	ETF	30.34	30.42	29.94	30.0999	17672018.0
2008-12-09 14:00:00	QQQ	ETF	30.09	30.11	29.61	30.06	26102688.0
2008-12-09 15:00:00	QQQ	ETF	30.06	30.25	29.73	30.0	39412793.0
2008-12-09 16:00:00	QQQ	ETF	30.0	30.1622	29.7916	30.0	6178331.0
2008-12-09 17:00:00	QQQ	ETF	30.0	30.07	29.99	30.05	72893.0
2008-12-09 18:00:00	QQQ	ETF	30.05	30.1	29.96	30.01	70366.0
2008-12-09 19:00:00	QQQ	ETF	30.0	30.14	30.0	30.05	206159.0
2008-12-09 06:00:00	IWM	ETF	48.35	48.35	48.35	48.35	1000.0
2008-12-09 07:00:00	IWM	ETF	48.27	48.4	48.26	48.26	34914.0
2008-12-09 08:00:00	IWM	ETF	48.24	48.55	47.71	47.78	507931.0
2008-12-09 09:00:00	IWM	ETF	47.8	48.01	47.46	47.62	6218462.0
2008-12-09 10:00:00	IWM	ETF	47.63	49.38	47.61	49.24	15490451.0
2008-12-09 11:00:00	IWM	ETF	49.24	49.41	48.28	48.49	7348532.0
2008-12-09 12:00:00	IWM	ETF	48.49	48.79	47.83	47.86	9882749.0
2008-12-09 13:00:00	IWM	ETF	47.87	48.01	47.12	47.39	8002919.0
2008-12-09 14:00:00	IWM	ETF	47.39	47.53	46.28	47.49	14334042.0
2008-12-09 15:00:00	IWM	ETF	47.49	47.73	46.57	46.67	15170340.0
2008-12-09 16:00:00	IWM	ETF	46.66	48.25	46.63	47.07	3961361.0
2008-12-09 17:00:00	IWM	ETF	47.16	47.29	47.0	47.18	22800.0
2008-12-09 18:00:00	IWM	ETF	47.18	47.18	47.15	47.15	9200.0
2008-12-09 19:00:00	IWM	ETF	47.15	47.19	47.14	47.19	4100.0
2008-12-09 07:00:00	DIA	ETF	89.14	89.18	89.06	89.06	1382.0
2008-12-09 08:00:00	DIA	ETF	89.02	89.07	88.41	88.5	57523.0
2008-12-09 09:00:00	DIA	ETF	88.52	88.75	87.78	87.87	3728879.0
2008-12-09 10:00:00	DIA	ETF	87.87	89.41	87.86	89.09	5240506.0
2008-12-09 11:00:00	DIA	ETF	89.1	89.35	88.02	88.38	2967381.0

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

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