PREVIEW / etf_1hour / 2009-07-20

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-20.parquet
  size:    141 KB
  rows:    4,369

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-07-20 04:00:00	SPY	ETF	94.41	94.46	94.35	94.36	1800.0
2009-07-20 05:00:00	SPY	ETF	94.46	94.83	94.46	94.75	16900.0
2009-07-20 06:00:00	SPY	ETF	94.8	94.91	94.76	94.76	358210.0
2009-07-20 07:00:00	SPY	ETF	94.77	94.83	94.67	94.73	564608.0
2009-07-20 08:00:00	SPY	ETF	94.72	94.98	94.55	94.7	1898980.0
2009-07-20 09:00:00	SPY	ETF	94.71	95.0	94.6	94.75	22104949.0
2009-07-20 10:00:00	SPY	ETF	94.76	95.0	94.19	94.37	31064547.0
2009-07-20 11:00:00	SPY	ETF	94.3617	94.68	94.3	94.56	13907109.0
2009-07-20 12:00:00	SPY	ETF	94.57	94.9	94.54	94.76	9754720.0
2009-07-20 13:00:00	SPY	ETF	94.76	94.82	94.47	94.74	15159603.0
2009-07-20 14:00:00	SPY	ETF	94.74	94.95	94.62	94.73	16723920.0
2009-07-20 15:00:00	SPY	ETF	94.74	95.29	94.73	95.13	34799200.0
2009-07-20 16:00:00	SPY	ETF	95.12	95.37	95.03	95.12	6890053.0
2009-07-20 17:00:00	SPY	ETF	95.13	95.2	95.11	95.17	59031.0
2009-07-20 18:00:00	SPY	ETF	95.17	95.17	95.07	95.09	90691.0
2009-07-20 19:00:00	SPY	ETF	95.09	95.19	95.08	95.11	26481.0
2009-07-20 04:00:00	QQQ	ETF	37.75	37.75	37.69	37.69	394.0
2009-07-20 05:00:00	QQQ	ETF	37.81	37.81	37.81	37.81	100.0
2009-07-20 06:00:00	QQQ	ETF	37.88	37.91	37.85	37.85	57900.0
2009-07-20 07:00:00	QQQ	ETF	37.8	37.82	37.74	37.79	374469.0
2009-07-20 08:00:00	QQQ	ETF	37.77	37.92	37.67	37.72	904554.0
2009-07-20 09:00:00	QQQ	ETF	37.72	37.89	37.61	37.88	16968139.0
2009-07-20 10:00:00	QQQ	ETF	37.88	37.97	37.62	37.68	15593151.0
2009-07-20 11:00:00	QQQ	ETF	37.69	37.85	37.66	37.8	7834953.0
2009-07-20 12:00:00	QQQ	ETF	37.8	37.92	37.79	37.8702	6534267.0
2009-07-20 13:00:00	QQQ	ETF	37.88	37.9	37.74	37.84	8123488.0
2009-07-20 14:00:00	QQQ	ETF	37.84	37.92	37.7	37.73	10189808.0
2009-07-20 15:00:00	QQQ	ETF	37.74	38.0	37.74	37.93	20807721.0
2009-07-20 16:00:00	QQQ	ETF	37.93	37.97	37.8	37.87	5149911.0
2009-07-20 17:00:00	QQQ	ETF	37.87	37.9	37.86	37.88	143840.0
2009-07-20 18:00:00	QQQ	ETF	37.87	37.98	37.85	37.86	123258.0
2009-07-20 19:00:00	QQQ	ETF	37.86	37.89	37.86	37.87	61100.0
2009-07-20 06:00:00	IWM	ETF	52.55	52.55	52.47	52.47	16758.0
2009-07-20 07:00:00	IWM	ETF	52.42	52.45	52.36	52.36	179656.0
2009-07-20 08:00:00	IWM	ETF	52.36	52.63	52.14	52.31	429959.0
2009-07-20 09:00:00	IWM	ETF	52.32	52.475	52.03	52.3	6326608.0
2009-07-20 10:00:00	IWM	ETF	52.3	52.59	52.08	52.2	6831587.0
2009-07-20 11:00:00	IWM	ETF	52.19	52.35	52.12	52.3091	2968660.0
2009-07-20 12:00:00	IWM	ETF	52.305	52.55	52.295	52.42	2355473.0
2009-07-20 13:00:00	IWM	ETF	52.41	52.48	52.16	52.32	3283240.0
2009-07-20 14:00:00	IWM	ETF	52.32	52.46	52.27	52.3	3997207.0
2009-07-20 15:00:00	IWM	ETF	52.31	52.74	52.3	52.6	9745056.0
2009-07-20 16:00:00	IWM	ETF	52.6	52.75	51.9209	52.5	3604836.0
2009-07-20 17:00:00	IWM	ETF	52.5	52.54	52.49	52.49	8028.0
2009-07-20 19:00:00	IWM	ETF	52.51	52.6	52.43	52.55	2700.0
2009-07-20 06:00:00	DIA	ETF	87.95	88.03	87.95	88.03	200.0
2009-07-20 07:00:00	DIA	ETF	88.0	88.09	87.98	88.03	23654.0
2009-07-20 08:00:00	DIA	ETF	87.98	88.03	87.73	87.85	37390.0
2009-07-20 09:00:00	DIA	ETF	87.88	88.22	87.81	88.02	2928800.0
2009-07-20 10:00:00	DIA	ETF	88.03	88.29	87.54	87.68	2228561.0

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

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