PREVIEW / etf_1hour / 2008-09-15

all etf 1-hour files

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

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-09-15 04:00:00	SPY	ETF	123.05	123.05	121.71	121.79	34800.0
2008-09-15 05:00:00	SPY	ETF	121.56	122.29	121.56	121.92	103210.0
2008-09-15 06:00:00	SPY	ETF	121.91	121.93	121.21	121.25	309754.0
2008-09-15 07:00:00	SPY	ETF	121.22	121.57	120.73	121.33	6345103.0
2008-09-15 08:00:00	SPY	ETF	121.32	123.35	120.9501	121.78	20107241.0
2008-09-15 09:00:00	SPY	ETF	121.77	123.0	121.35	122.195	58289619.0
2008-09-15 10:00:00	SPY	ETF	122.18	124.28	122.0	123.87	73804191.0
2008-09-15 11:00:00	SPY	ETF	123.87	125.652	122.25	122.38	47281529.0
2008-09-15 12:00:00	SPY	ETF	122.38	125.652	122.3	123.13	50801035.0
2008-09-15 13:00:00	SPY	ETF	123.13	123.52	121.89	122.33	42597353.0
2008-09-15 14:00:00	SPY	ETF	122.302	125.652	121.47	121.77	49819188.0
2008-09-15 15:00:00	SPY	ETF	121.78	122.29	120.14	120.34	100982331.0
2008-09-15 16:00:00	SPY	ETF	120.37	125.652	119.75	119.97	21979791.0
2008-09-15 17:00:00	SPY	ETF	119.99	120.25	119.95	120.0	4368201.0
2008-09-15 18:00:00	SPY	ETF	120.0	120.0	119.42	119.45	435704.0
2008-09-15 19:00:00	SPY	ETF	119.45	119.62	119.31	119.37	335316.0
2008-09-15 07:00:00	QQQ	ETF	42.41	42.57	42.22	42.37	2389702.0
2008-09-15 08:00:00	QQQ	ETF	42.38	42.6	42.25	42.43	4160858.0
2008-09-15 09:00:00	QQQ	ETF	42.43	42.9	42.29	42.62	38168358.0
2008-09-15 10:00:00	QQQ	ETF	42.62	43.29	42.6	43.12	37803037.0
2008-09-15 11:00:00	QQQ	ETF	43.12	43.15	42.3	42.7505	28018580.0
2008-09-15 12:00:00	QQQ	ETF	42.76	43.18	42.3	42.99	84270085.0
2008-09-15 13:00:00	QQQ	ETF	42.99	43.11	42.47	42.61	25818117.0
2008-09-15 14:00:00	QQQ	ETF	42.61	42.85	42.42	42.49	25238672.0
2008-09-15 15:00:00	QQQ	ETF	42.49	42.6	42.03	42.09	62568833.0
2008-09-15 16:00:00	QQQ	ETF	42.088	43.4808	41.97	42.17	14096297.0
2008-09-15 17:00:00	QQQ	ETF	42.15	42.24	41.97	42.23	16079933.0
2008-09-15 18:00:00	QQQ	ETF	42.19	42.19	41.97	41.98	202215.0
2008-09-15 19:00:00	QQQ	ETF	41.98	42.08	41.98	41.99	100208.0
2008-09-15 04:00:00	IWM	ETF	70.27	70.31	70.27	70.27	1200.0
2008-09-15 05:00:00	IWM	ETF	70.2	70.3	70.0	70.3	53000.0
2008-09-15 06:00:00	IWM	ETF	69.86	70.04	69.62	69.62	29600.0
2008-09-15 07:00:00	IWM	ETF	69.6	69.94	68.01	69.83	352128.0
2008-09-15 08:00:00	IWM	ETF	69.84	70.42	69.55	70.03	1580404.0
2008-09-15 09:00:00	IWM	ETF	70.04	70.79	69.71	70.39	18324571.0
2008-09-15 10:00:00	IWM	ETF	70.39	71.49	70.33	71.42	27430565.0
2008-09-15 11:00:00	IWM	ETF	71.42	71.47	70.25	70.27	14325488.0
2008-09-15 12:00:00	IWM	ETF	70.27	71.0	70.21	70.66	16091733.0
2008-09-15 13:00:00	IWM	ETF	70.67	70.85	69.95	70.21	12413097.0
2008-09-15 14:00:00	IWM	ETF	70.2	70.4	69.83	69.96	14308149.0
2008-09-15 15:00:00	IWM	ETF	69.97	70.01	68.79	69.13	46914456.0
2008-09-15 16:00:00	IWM	ETF	69.17	69.39	68.99	69.11	12677399.0
2008-09-15 17:00:00	IWM	ETF	69.12	69.25	69.11	69.24	42982.0
2008-09-15 18:00:00	IWM	ETF	69.22	69.22	68.98	69.0	15872.0
2008-09-15 19:00:00	IWM	ETF	68.96	69.0	68.89	68.89	4605.0
2008-09-15 05:00:00	DIA	ETF	111.95	111.95	111.95	111.95	100.0
2008-09-15 06:00:00	DIA	ETF	111.25	111.31	110.95	110.95	8600.0
2008-09-15 07:00:00	DIA	ETF	111.06	111.34	110.75	111.11	58258.0
2008-09-15 08:00:00	DIA	ETF	111.08	111.5	110.98	111.25	375312.0
2008-09-15 09:00:00	DIA	ETF	111.24	111.88	110.81	111.22	5745098.0

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

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