PREVIEW / etf_1hour / 2010-03-05

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-03-05.parquet
  size:    158 KB
  rows:    4,859

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-03-05 04:00:00	SPY	ETF	112.9	112.9	112.89	112.89	200.0
2010-03-05 05:00:00	SPY	ETF	112.89	113.24	112.89	113.24	33250.0
2010-03-05 06:00:00	SPY	ETF	113.18	113.18	113.1	113.1	28975.0
2010-03-05 07:00:00	SPY	ETF	113.1	113.31	113.1	113.17	267973.0
2010-03-05 08:00:00	SPY	ETF	113.17	113.61	113.02	113.36	6805804.0
2010-03-05 09:00:00	SPY	ETF	113.37	113.54	113.1	113.49	23255440.0
2010-03-05 10:00:00	SPY	ETF	113.49	113.92	113.41	113.81	33225994.0
2010-03-05 11:00:00	SPY	ETF	113.82	113.92	113.75	113.76	18621829.0
2010-03-05 12:00:00	SPY	ETF	113.76	113.89	113.73	113.87	9461648.0
2010-03-05 13:00:00	SPY	ETF	113.88	113.95	113.79	113.89	11713233.0
2010-03-05 14:00:00	SPY	ETF	113.89	114.16	113.81	114.15	21951545.0
2010-03-05 15:00:00	SPY	ETF	114.145	114.34	114.02	114.26	41026787.0
2010-03-05 16:00:00	SPY	ETF	114.25	114.26	113.18	114.09	8668594.0
2010-03-05 17:00:00	SPY	ETF	114.1	114.23	114.09	114.14	226314.0
2010-03-05 18:00:00	SPY	ETF	114.14	114.23	114.08	114.14	40957.0
2010-03-05 19:00:00	SPY	ETF	114.14	114.18	114.14	114.16	30770.0
2010-03-05 04:00:00	QQQ	ETF	45.84	45.85	45.84	45.84	2397.0
2010-03-05 05:00:00	QQQ	ETF	45.91	45.91	45.91	45.91	400.0
2010-03-05 06:00:00	QQQ	ETF	45.89	45.89	45.88	45.89	8000.0
2010-03-05 07:00:00	QQQ	ETF	45.89	45.96	45.88	45.94	145405.0
2010-03-05 08:00:00	QQQ	ETF	45.93	46.09	45.88	46.04	3039380.0
2010-03-05 09:00:00	QQQ	ETF	46.04	46.22	45.99	46.2	11860965.0
2010-03-05 10:00:00	QQQ	ETF	46.1999	46.39	46.16	46.36	11815914.0
2010-03-05 11:00:00	QQQ	ETF	46.36	46.41	46.2865	46.33	5142241.0
2010-03-05 12:00:00	QQQ	ETF	46.3399	46.4201	46.31	46.42	4375447.0
2010-03-05 13:00:00	QQQ	ETF	46.43	46.47	46.38	46.4065	4235663.0
2010-03-05 14:00:00	QQQ	ETF	46.41	46.48	46.37	46.44	7583890.0
2010-03-05 15:00:00	QQQ	ETF	46.45	46.51	46.39	46.45	11848389.0
2010-03-05 16:00:00	QQQ	ETF	46.45	46.4751	45.7708	46.42	7172179.0
2010-03-05 17:00:00	QQQ	ETF	46.42	46.49	46.41	46.42	526524.0
2010-03-05 18:00:00	QQQ	ETF	46.42	46.42	46.4	46.41	11229.0
2010-03-05 19:00:00	QQQ	ETF	46.41	46.45	46.41	46.45	6700.0
2010-03-05 07:00:00	IWM	ETF	65.53	65.63	65.53	65.58	80100.0
2010-03-05 08:00:00	IWM	ETF	65.61	66.0	65.33	65.67	1821265.0
2010-03-05 09:00:00	IWM	ETF	65.68	65.96	65.5	65.94	8144923.0
2010-03-05 10:00:00	IWM	ETF	65.94	66.25	65.89	66.24	9327608.0
2010-03-05 11:00:00	IWM	ETF	66.24	66.37	66.235	66.25	4375737.0
2010-03-05 12:00:00	IWM	ETF	66.25	66.45	66.22	66.4	2609697.0
2010-03-05 13:00:00	IWM	ETF	66.395	66.51	66.36	66.46	3015398.0
2010-03-05 14:00:00	IWM	ETF	66.45	66.63	66.37	66.565	5153747.0
2010-03-05 15:00:00	IWM	ETF	66.565	66.72	66.52	66.61	12501749.0
2010-03-05 16:00:00	IWM	ETF	66.62	66.68	65.3065	66.6	4946957.0
2010-03-05 17:00:00	IWM	ETF	66.6	66.7	66.54	66.56	44422.0
2010-03-05 18:00:00	IWM	ETF	66.58	66.61	66.58	66.61	200.0
2010-03-05 19:00:00	IWM	ETF	66.58	66.58	66.57	66.57	300.0
2010-03-05 07:00:00	DIA	ETF	104.8	104.9	104.8	104.85	4158.0
2010-03-05 08:00:00	DIA	ETF	104.79	105.16	104.73	104.98	76116.0
2010-03-05 09:00:00	DIA	ETF	104.99	105.26	104.87	105.18	1136064.0
2010-03-05 10:00:00	DIA	ETF	105.18	105.4699	105.08	105.4	1182456.0
2010-03-05 11:00:00	DIA	ETF	105.42	105.48	105.31	105.3201	717728.0

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

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