PREVIEW / etf_1hour / 2010-06-21

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-06-21.parquet
  size:    165 KB
  rows:    5,063

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
2010-06-21 04:00:00	SPY	ETF	112.99	113.22	112.97	113.2	13565.0
2010-06-21 05:00:00	SPY	ETF	113.12	113.14	112.99	113.02	9900.0
2010-06-21 06:00:00	SPY	ETF	113.11	113.28	113.08	113.09	82591.0
2010-06-21 07:00:00	SPY	ETF	113.12	113.21	113.03	113.06	599495.0
2010-06-21 08:00:00	SPY	ETF	113.03	113.08	111.66	112.86	1484351.0
2010-06-21 09:00:00	SPY	ETF	112.85	113.2	112.61	113.04	28199317.0
2010-06-21 10:00:00	SPY	ETF	113.0383	113.15	112.4883	112.52	27805355.0
2010-06-21 11:00:00	SPY	ETF	112.5275	112.78	112.46	112.57	18542104.0
2010-06-21 12:00:00	SPY	ETF	112.57	112.75	112.1	112.28	19211475.0
2010-06-21 13:00:00	SPY	ETF	112.29	112.7546	111.93	112.07	15968555.0
2010-06-21 14:00:00	SPY	ETF	112.065	112.42	111.79	111.835	21284132.0
2010-06-21 15:00:00	SPY	ETF	111.83	111.91	110.79	111.36	62097172.0
2010-06-21 16:00:00	SPY	ETF	111.37	113.1	111.04	111.53	11861217.0
2010-06-21 17:00:00	SPY	ETF	111.56	111.6	111.41	111.57	393241.0
2010-06-21 18:00:00	SPY	ETF	111.57	111.62	111.41	111.58	185253.0
2010-06-21 19:00:00	SPY	ETF	111.58	111.65	111.58	111.6	102549.0
2010-06-21 04:00:00	QQQ	ETF	47.67	47.71	47.63	47.69	22937.0
2010-06-21 05:00:00	QQQ	ETF	47.65	47.67	47.65	47.67	3350.0
2010-06-21 06:00:00	QQQ	ETF	47.65	47.71	47.63	47.63	8050.0
2010-06-21 07:00:00	QQQ	ETF	47.65	47.67	47.56	47.56	300649.0
2010-06-21 08:00:00	QQQ	ETF	47.6	47.6	47.45	47.55	1726977.0
2010-06-21 09:00:00	QQQ	ETF	47.54	47.66	47.36	47.63	12968560.0
2010-06-21 10:00:00	QQQ	ETF	47.63	47.68	47.23	47.27	9654435.0
2010-06-21 11:00:00	QQQ	ETF	47.27	47.42	47.17	47.23	8062712.0
2010-06-21 12:00:00	QQQ	ETF	47.22	47.27	47.04	47.17	6528912.0
2010-06-21 13:00:00	QQQ	ETF	47.16	47.22	46.95	47.0	5833201.0
2010-06-21 14:00:00	QQQ	ETF	47.01	47.2	46.85	46.86	11219170.0
2010-06-21 15:00:00	QQQ	ETF	46.86	46.9	46.33	46.6	32879782.0
2010-06-21 16:00:00	QQQ	ETF	46.61	47.3602	46.4379	46.73	3311224.0
2010-06-21 17:00:00	QQQ	ETF	46.73	46.75	46.7	46.73	34010.0
2010-06-21 18:00:00	QQQ	ETF	46.73	46.76	46.71	46.74	50000.0
2010-06-21 19:00:00	QQQ	ETF	46.74	46.75	46.73	46.75	16615.0
2010-06-21 04:00:00	IWM	ETF	67.79	67.83	67.74	67.83	3455.0
2010-06-21 05:00:00	IWM	ETF	67.8	67.8	67.8	67.8	300.0
2010-06-21 06:00:00	IWM	ETF	67.85	67.96	67.85	67.95	1800.0
2010-06-21 07:00:00	IWM	ETF	67.89	67.91	67.75	67.77	134601.0
2010-06-21 08:00:00	IWM	ETF	67.75	67.78	67.58	67.69	164946.0
2010-06-21 09:00:00	IWM	ETF	67.69	67.995	67.42	67.78	6338811.0
2010-06-21 10:00:00	IWM	ETF	67.78	67.88	67.34	67.35	8184897.0
2010-06-21 11:00:00	IWM	ETF	67.35	67.47	67.072	67.17	4378486.0
2010-06-21 12:00:00	IWM	ETF	67.17	67.17	66.73	66.96	5544967.0
2010-06-21 13:00:00	IWM	ETF	66.96	67.11	66.73	66.83	4042707.0
2010-06-21 14:00:00	IWM	ETF	66.839	67.08	66.61	66.665	4634396.0
2010-06-21 15:00:00	IWM	ETF	66.65	66.79	65.72	66.14	17129986.0
2010-06-21 16:00:00	IWM	ETF	66.14	67.85	65.75	66.29	4869244.0
2010-06-21 17:00:00	IWM	ETF	66.28	66.33	66.1354	66.32	34066.0
2010-06-21 18:00:00	IWM	ETF	66.35	66.35	66.31	66.33	1600.0
2010-06-21 19:00:00	IWM	ETF	66.31	66.38	66.31	66.36	1500.0
2010-06-21 04:00:00	DIA	ETF	104.61	104.61	104.61	104.61	200.0
2010-06-21 07:00:00	DIA	ETF	105.65	105.72	105.65	105.65	2000.0

> showing 50 of 5,063 rows — these rows as CSV

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