PREVIEW / etf_1hour / 2009-04-03

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-03.parquet
  size:    133 KB
  rows:    4,084

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-04-03 04:00:00	SPY	ETF	83.48	83.96	83.48	83.96	8650.0
2009-04-03 05:00:00	SPY	ETF	84.0	84.2	83.99	84.08	9500.0
2009-04-03 06:00:00	SPY	ETF	84.23	84.3	83.9	84.2	22350.0
2009-04-03 07:00:00	SPY	ETF	84.2	84.27	83.95	84.21	427731.0
2009-04-03 08:00:00	SPY	ETF	84.21	84.83	83.48	83.61	10383882.0
2009-04-03 09:00:00	SPY	ETF	83.61	84.4	83.1	83.37	36348784.0
2009-04-03 10:00:00	SPY	ETF	83.35	83.4125	82.67	82.9499	40709974.0
2009-04-03 11:00:00	SPY	ETF	82.94	83.38	82.73	83.35	27904812.0
2009-04-03 12:00:00	SPY	ETF	83.35	83.76	83.3	83.43	31050041.0
2009-04-03 13:00:00	SPY	ETF	83.43	83.77	83.26	83.75	27841883.0
2009-04-03 14:00:00	SPY	ETF	83.75	84.2	83.58	84.0	35207952.0
2009-04-03 15:00:00	SPY	ETF	83.99	84.28	82.9	84.25	60971974.0
2009-04-03 16:00:00	SPY	ETF	84.25	84.62	83.4746	84.55	10130048.0
2009-04-03 17:00:00	SPY	ETF	84.54	84.54	84.43	84.47	169123.0
2009-04-03 18:00:00	SPY	ETF	84.47	84.5	84.42	84.43	67464.0
2009-04-03 19:00:00	SPY	ETF	84.45	84.49	84.35	84.4	65374.0
2009-04-03 04:00:00	QQQ	ETF	32.01	32.07	32.01	32.07	200.0
2009-04-03 05:00:00	QQQ	ETF	32.1	32.19	32.1	32.19	4800.0
2009-04-03 06:00:00	QQQ	ETF	32.25	32.25	32.15	32.25	48069.0
2009-04-03 07:00:00	QQQ	ETF	32.22	32.29	32.12	32.22	137511.0
2009-04-03 08:00:00	QQQ	ETF	32.21	32.36	31.85	32.07	2970293.0
2009-04-03 09:00:00	QQQ	ETF	32.08	32.22	31.91	32.01	19540040.0
2009-04-03 10:00:00	QQQ	ETF	32.02	32.04	31.83	31.959	19521430.0
2009-04-03 11:00:00	QQQ	ETF	31.96	32.13	31.89	32.12	11924525.0
2009-04-03 12:00:00	QQQ	ETF	32.12	32.27	32.08	32.1301	13251403.0
2009-04-03 13:00:00	QQQ	ETF	32.14	32.3	32.105	32.2575	10858694.0
2009-04-03 14:00:00	QQQ	ETF	32.2699	32.4	32.18	32.3299	15770767.0
2009-04-03 15:00:00	QQQ	ETF	32.32	32.36	32.06	32.35	30354776.0
2009-04-03 16:00:00	QQQ	ETF	32.35	32.43	32.1232	32.38	5089982.0
2009-04-03 17:00:00	QQQ	ETF	32.41	32.41	32.38	32.4	41938.0
2009-04-03 18:00:00	QQQ	ETF	32.39	32.4	32.38	32.4	9050.0
2009-04-03 19:00:00	QQQ	ETF	32.4	32.4	32.38	32.39	11506.0
2009-04-03 07:00:00	IWM	ETF	45.34	45.34	45.15	45.29	16767.0
2009-04-03 08:00:00	IWM	ETF	45.28	45.64	44.85	44.95	821330.0
2009-04-03 09:00:00	IWM	ETF	44.96	45.0	44.64	44.82	4675950.0
2009-04-03 10:00:00	IWM	ETF	44.83	44.85	44.46	44.58	7094104.0
2009-04-03 11:00:00	IWM	ETF	44.58	44.95	44.36	44.93	5538557.0
2009-04-03 12:00:00	IWM	ETF	44.92	45.16	44.83	44.9001	5508725.0
2009-04-03 13:00:00	IWM	ETF	44.91	45.26	44.8	45.19	4587179.0
2009-04-03 14:00:00	IWM	ETF	45.2	45.49	44.96	45.46	8667404.0
2009-04-03 15:00:00	IWM	ETF	45.464	45.6	44.65	45.58	10497498.0
2009-04-03 16:00:00	IWM	ETF	45.6	45.89	45.1	45.83	1373346.0
2009-04-03 17:00:00	IWM	ETF	45.81	45.86	45.79	45.79	7200.0
2009-04-03 18:00:00	IWM	ETF	45.84	45.84	45.78	45.78	300.0
2009-04-03 19:00:00	IWM	ETF	45.77	45.8	45.75	45.8	6057.0
2009-04-03 06:00:00	DIA	ETF	80.14	80.14	80.14	80.14	1600.0
2009-04-03 07:00:00	DIA	ETF	80.25	80.25	80.07	80.21	2610.0
2009-04-03 08:00:00	DIA	ETF	80.22	80.83	79.58	79.65	257411.0
2009-04-03 09:00:00	DIA	ETF	79.67	79.97	79.38	79.62	2548180.0
2009-04-03 10:00:00	DIA	ETF	79.61	79.62	78.96	79.1816	3612586.0

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

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