PREVIEW / etf_1hour / 2009-01-15

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-15.parquet
  size:    129 KB
  rows:    3,981

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-15 04:00:00	SPY	ETF	83.55	84.05	83.54	84.05	2400.0
2009-01-15 05:00:00	SPY	ETF	84.02	84.25	84.02	84.25	20718.0
2009-01-15 06:00:00	SPY	ETF	84.32	84.6	83.93	84.27	247405.0
2009-01-15 07:00:00	SPY	ETF	84.26	84.35	83.37	83.62	1381464.0
2009-01-15 08:00:00	SPY	ETF	83.62	84.49	83.53	84.24	4528636.0
2009-01-15 09:00:00	SPY	ETF	84.22	84.29	82.91	83.3	46214966.0
2009-01-15 10:00:00	SPY	ETF	83.3	84.3098	82.02	82.38	76006561.0
2009-01-15 11:00:00	SPY	ETF	82.37	82.85	82.29	82.49	38589202.0
2009-01-15 12:00:00	SPY	ETF	82.49	82.62	81.72	82.13	45323651.0
2009-01-15 13:00:00	SPY	ETF	82.13	83.84	82.08	83.67	67027156.0
2009-01-15 14:00:00	SPY	ETF	83.67	85.25	83.3	84.59	103734945.0
2009-01-15 15:00:00	SPY	ETF	84.59	85.03	83.3	84.49	92675711.0
2009-01-15 16:00:00	SPY	ETF	84.54	85.23	82.8	84.49	36645185.0
2009-01-15 17:00:00	SPY	ETF	84.49	84.77	84.46	84.77	3735629.0
2009-01-15 18:00:00	SPY	ETF	84.74	84.98	84.7	84.9	845155.0
2009-01-15 19:00:00	SPY	ETF	84.89	84.95	84.78	84.95	185366.0
2009-01-15 05:00:00	QQQ	ETF	28.2	28.31	28.2	28.31	1500.0
2009-01-15 06:00:00	QQQ	ETF	28.23	28.33	28.15	28.28	26000.0
2009-01-15 07:00:00	QQQ	ETF	28.35	28.35	28.2	28.35	602477.0
2009-01-15 08:00:00	QQQ	ETF	28.33	28.67	28.15	28.59	2717248.0
2009-01-15 09:00:00	QQQ	ETF	28.58	28.62	28.19	28.36	19314738.0
2009-01-15 10:00:00	QQQ	ETF	28.36	28.5	28.07	28.18	28736823.0
2009-01-15 11:00:00	QQQ	ETF	28.18	28.4	28.16	28.31	15186464.0
2009-01-15 12:00:00	QQQ	ETF	28.31	28.36	28.12	28.29	10913618.0
2009-01-15 13:00:00	QQQ	ETF	28.3	28.93	28.3	28.84	24608973.0
2009-01-15 14:00:00	QQQ	ETF	28.85	29.29	28.83	29.12	46517999.0
2009-01-15 15:00:00	QQQ	ETF	29.12	29.34	28.79	29.1	38719859.0
2009-01-15 16:00:00	QQQ	ETF	29.09	29.19	28.9	29.07	4261491.0
2009-01-15 17:00:00	QQQ	ETF	29.08	29.22	29.08	29.22	213045.0
2009-01-15 18:00:00	QQQ	ETF	29.16	29.27	29.16	29.23	144844.0
2009-01-15 19:00:00	QQQ	ETF	29.22	29.25	29.2	29.25	24250.0
2009-01-15 06:00:00	IWM	ETF	45.3	45.3	45.06	45.06	10600.0
2009-01-15 07:00:00	IWM	ETF	45.19	45.19	44.78	44.9	40400.0
2009-01-15 08:00:00	IWM	ETF	44.88	45.53	44.83	45.44	203645.0
2009-01-15 09:00:00	IWM	ETF	45.4	45.45	44.7	44.83	6339072.0
2009-01-15 10:00:00	IWM	ETF	44.83	44.94	43.85	44.3	17276056.0
2009-01-15 11:00:00	IWM	ETF	44.3	45.2	44.07	44.09	7803805.0
2009-01-15 12:00:00	IWM	ETF	44.09	44.19	43.81	44.02	9331775.0
2009-01-15 13:00:00	IWM	ETF	44.01	45.2	43.93	45.17	10719055.0
2009-01-15 14:00:00	IWM	ETF	45.17	46.52	45.12	46.05	17657381.0
2009-01-15 15:00:00	IWM	ETF	46.05	46.4	45.34	46.02	17602694.0
2009-01-15 16:00:00	IWM	ETF	46.01	46.47	44.75	46.3	7925710.0
2009-01-15 17:00:00	IWM	ETF	46.28	46.45	46.23	46.24	24638.0
2009-01-15 18:00:00	IWM	ETF	46.43	46.44	46.36	46.36	8000.0
2009-01-15 19:00:00	IWM	ETF	46.36	46.56	46.36	46.55	9500.0
2009-01-15 04:00:00	DIA	ETF	81.49	81.49	81.49	81.49	100.0
2009-01-15 06:00:00	DIA	ETF	82.27	82.34	82.12	82.16	4229.0
2009-01-15 07:00:00	DIA	ETF	82.15	82.15	81.43	81.6	14656.0
2009-01-15 08:00:00	DIA	ETF	81.55	82.4	81.54	82.23	144410.0
2009-01-15 09:00:00	DIA	ETF	82.15	82.25	80.93	81.29	4305749.0

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

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