PREVIEW / etf_1hour / 2008-04-02

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-02.parquet
  size:    102 KB
  rows:    3,442

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-04-02 04:00:00	SPY	ETF	136.15	136.24	136.15	136.24	1800.0
2008-04-02 05:00:00	SPY	ETF	136.23	136.23	136.02	136.15	10200.0
2008-04-02 06:00:00	SPY	ETF	136.19	136.51	136.16	136.48	126100.0
2008-04-02 07:00:00	SPY	ETF	136.5	136.95	136.44	136.93	1295000.0
2008-04-02 08:00:00	SPY	ETF	136.92	137.4	136.1	137.07	5904100.0
2008-04-02 09:00:00	SPY	ETF	137.06	137.1	136.3	136.5	23228206.0
2008-04-02 10:00:00	SPY	ETF	136.49	137.67	136.25	137.52	41612336.0
2008-04-02 11:00:00	SPY	ETF	137.52	137.61	137.0	137.51	27712035.0
2008-04-02 12:00:00	SPY	ETF	137.51	137.64	136.89	137.06	19868310.0
2008-04-02 13:00:00	SPY	ETF	137.07	137.36	136.69	137.19	20975440.0
2008-04-02 14:00:00	SPY	ETF	137.19	137.51	136.0	136.46	31365099.0
2008-04-02 15:00:00	SPY	ETF	136.4609	136.66	135.98	136.65	30809993.0
2008-04-02 16:00:00	SPY	ETF	136.62	137.42	136.45	136.5	3583273.0
2008-04-02 17:00:00	SPY	ETF	136.49	136.59	136.43	136.53	1635200.0
2008-04-02 18:00:00	SPY	ETF	136.53	136.56	136.45	136.48	36600.0
2008-04-02 19:00:00	SPY	ETF	136.47	136.51	136.38	136.48	23500.0
2008-04-02 04:00:00	QQQ	ETF	45.37	45.47	45.37	45.4	14683.0
2008-04-02 05:00:00	QQQ	ETF	45.37	45.42	45.37	45.42	5400.0
2008-04-02 06:00:00	QQQ	ETF	45.54	45.56	45.53	45.54	16800.0
2008-04-02 07:00:00	QQQ	ETF	45.55	45.67	45.55	45.65	286406.0
2008-04-02 08:00:00	QQQ	ETF	45.65	45.8	45.64	45.72	2436071.0
2008-04-02 09:00:00	QQQ	ETF	45.71	45.71	45.45	45.54	15312681.0
2008-04-02 10:00:00	QQQ	ETF	45.54	46.02	45.45	45.92	28719428.0
2008-04-02 11:00:00	QQQ	ETF	45.92	45.95	45.75	45.89	12316941.0
2008-04-02 12:00:00	QQQ	ETF	45.89	45.97	45.6101	45.67	9659409.0
2008-04-02 13:00:00	QQQ	ETF	45.68	45.76	45.5	45.67	15878614.0
2008-04-02 14:00:00	QQQ	ETF	45.67	45.78	45.27	45.36	16002241.0
2008-04-02 15:00:00	QQQ	ETF	45.36	45.49	45.17	45.49	24166924.0
2008-04-02 16:00:00	QQQ	ETF	45.5	45.72	45.41	45.56	6594224.0
2008-04-02 17:00:00	QQQ	ETF	45.58	45.67	45.57	45.62	423868.0
2008-04-02 18:00:00	QQQ	ETF	45.61	45.63	45.6	45.62	22222.0
2008-04-02 19:00:00	QQQ	ETF	45.59	45.61	45.57	45.58	26088.0
2008-04-02 04:00:00	IWM	ETF	70.63	70.63	70.63	70.63	100.0
2008-04-02 06:00:00	IWM	ETF	70.47	70.47	70.47	70.47	400.0
2008-04-02 07:00:00	IWM	ETF	70.46	70.75	70.46	70.73	160000.0
2008-04-02 08:00:00	IWM	ETF	70.75	71.09	70.72	70.89	866300.0
2008-04-02 09:00:00	IWM	ETF	70.88	70.91	70.43	70.52	4778402.0
2008-04-02 10:00:00	IWM	ETF	70.52	71.48	70.37	71.42	11034362.0
2008-04-02 11:00:00	IWM	ETF	71.42	71.47	71.1	71.4	7997875.0
2008-04-02 12:00:00	IWM	ETF	71.4	71.52	70.84	71.34	6540317.0
2008-04-02 13:00:00	IWM	ETF	71.34	71.4	71.0	71.22	4691406.0
2008-04-02 14:00:00	IWM	ETF	71.22	71.39	70.75	70.86	7008126.0
2008-04-02 15:00:00	IWM	ETF	70.86	71.07	70.54	70.99	11168876.0
2008-04-02 16:00:00	IWM	ETF	70.99	71.22	70.91	70.98	1373500.0
2008-04-02 17:00:00	IWM	ETF	70.99	70.99	70.99	70.99	1500.0
2008-04-02 18:00:00	IWM	ETF	71.01	71.01	70.89	70.89	1200.0
2008-04-02 19:00:00	IWM	ETF	70.98	70.98	70.98	70.98	3000.0
2008-04-02 05:00:00	DIA	ETF	125.91	125.91	125.91	125.91	100.0
2008-04-02 07:00:00	DIA	ETF	126.45	126.48	126.45	126.48	3000.0
2008-04-02 08:00:00	DIA	ETF	126.48	126.85	126.43	126.47	119000.0

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

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