PREVIEW / etf_1hour / 2009-01-20

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-20.parquet
  size:    130 KB
  rows:    4,028

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
2009-01-20 04:00:00	SPY	ETF	84.95	85.01	84.85	84.9	18300.0
2009-01-20 05:00:00	SPY	ETF	84.88	84.88	84.2	84.2	26049.0
2009-01-20 06:00:00	SPY	ETF	84.31	84.47	83.92	84.28	67422.0
2009-01-20 07:00:00	SPY	ETF	84.22	84.78	84.19	84.2	865277.0
2009-01-20 08:00:00	SPY	ETF	84.2	86.2969	83.8	84.16	3310113.0
2009-01-20 09:00:00	SPY	ETF	84.17	84.46	82.62	82.85	42184713.0
2009-01-20 10:00:00	SPY	ETF	82.85	83.46	82.43	82.81	51343861.0
2009-01-20 11:00:00	SPY	ETF	82.81	83.29	82.45	82.74	38737365.0
2009-01-20 12:00:00	SPY	ETF	82.75	83.24	82.11	82.47	48372916.0
2009-01-20 13:00:00	SPY	ETF	82.46	82.88	82.0	82.01	42960993.0
2009-01-20 14:00:00	SPY	ETF	82.02	84.03	81.33	81.48	48352203.0
2009-01-20 15:00:00	SPY	ETF	81.48	85.059	80.05	80.62	92378931.0
2009-01-20 16:00:00	SPY	ETF	80.56	85.059	80.18	80.9	18102054.0
2009-01-20 17:00:00	SPY	ETF	80.88	85.059	80.54	80.95	18310690.0
2009-01-20 18:00:00	SPY	ETF	80.91	81.13	80.71	80.8	335525.0
2009-01-20 19:00:00	SPY	ETF	80.85	81.14	80.85	80.99	108622.0
2009-01-20 04:00:00	QQQ	ETF	29.39	29.39	29.39	29.39	500.0
2009-01-20 05:00:00	QQQ	ETF	29.36	29.36	29.16	29.16	3675.0
2009-01-20 06:00:00	QQQ	ETF	29.18	29.22	29.16	29.16	1100.0
2009-01-20 07:00:00	QQQ	ETF	29.25	29.37	29.24	29.24	117421.0
2009-01-20 08:00:00	QQQ	ETF	29.24	29.28	29.11	29.22	781907.0
2009-01-20 09:00:00	QQQ	ETF	29.24	29.43	28.77	28.8	18375223.0
2009-01-20 10:00:00	QQQ	ETF	28.8	28.92	28.6143	28.69	20252269.0
2009-01-20 11:00:00	QQQ	ETF	28.7	28.81	28.55	28.61	12781219.0
2009-01-20 12:00:00	QQQ	ETF	28.61	28.81	28.47	28.53	13001077.0
2009-01-20 13:00:00	QQQ	ETF	28.53	28.64	28.31	28.32	14642688.0
2009-01-20 14:00:00	QQQ	ETF	28.32	28.42	28.16	28.25	14783675.0
2009-01-20 15:00:00	QQQ	ETF	28.24	28.38	27.96	28.01	29103666.0
2009-01-20 16:00:00	QQQ	ETF	28.0	28.32	27.91	28.16	6307265.0
2009-01-20 17:00:00	QQQ	ETF	28.13	29.47	28.08	28.15	2772484.0
2009-01-20 18:00:00	QQQ	ETF	28.15	28.21	28.13	28.18	162770.0
2009-01-20 19:00:00	QQQ	ETF	28.17	28.24	28.14	28.24	45636.0
2009-01-20 06:00:00	IWM	ETF	45.98	45.98	45.67	45.67	400.0
2009-01-20 07:00:00	IWM	ETF	46.04	46.17	45.92	45.92	12540.0
2009-01-20 08:00:00	IWM	ETF	45.95	45.96	45.69	45.83	185461.0
2009-01-20 09:00:00	IWM	ETF	45.84	46.25	44.61	44.88	12751242.0
2009-01-20 10:00:00	IWM	ETF	44.91	45.33	44.47	44.8	8617235.0
2009-01-20 11:00:00	IWM	ETF	44.79	45.16	44.6	44.76	6529551.0
2009-01-20 12:00:00	IWM	ETF	44.76	45.13	44.52	44.62	8025881.0
2009-01-20 13:00:00	IWM	ETF	44.61	44.85	44.31	44.36	8792802.0
2009-01-20 14:00:00	IWM	ETF	44.36	45.61	43.87	44.07	8140238.0
2009-01-20 15:00:00	IWM	ETF	44.06	44.16	43.31	43.31	19556721.0
2009-01-20 16:00:00	IWM	ETF	43.32	46.5575	42.81	43.26	6088256.0
2009-01-20 17:00:00	IWM	ETF	43.31	46.5575	43.24	43.37	1034007.0
2009-01-20 18:00:00	IWM	ETF	43.37	43.37	43.3	43.3	700.0
2009-01-20 06:00:00	DIA	ETF	82.12	82.12	81.8	82.0	2827.0
2009-01-20 07:00:00	DIA	ETF	82.01	82.42	81.99	82.0	16341.0
2009-01-20 08:00:00	DIA	ETF	82.0	82.2	81.66	82.11	80425.0
2009-01-20 09:00:00	DIA	ETF	82.01	82.41	81.09	81.2	4995888.0
2009-01-20 10:00:00	DIA	ETF	81.22	81.74	80.88	81.11	4749211.0

> showing 50 of 4,028 rows — these rows as CSV

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