PREVIEW / etf_1hour / 2010-08-05

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-05.parquet
  size:    153 KB
  rows:    4,759

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-08-05 04:00:00	SPY	ETF	112.88	112.95	112.77	112.95	3000.0
2010-08-05 05:00:00	SPY	ETF	112.97	113.0	112.97	113.0	700.0
2010-08-05 06:00:00	SPY	ETF	113.07	113.25	113.07	113.24	20300.0
2010-08-05 07:00:00	SPY	ETF	113.24	113.3	112.95	112.98	908582.0
2010-08-05 08:00:00	SPY	ETF	112.99	113.27	112.36	112.45	6051172.0
2010-08-05 09:00:00	SPY	ETF	112.45	112.64	112.08	112.5	27767778.0
2010-08-05 10:00:00	SPY	ETF	112.5	112.78	112.28	112.32	22662365.0
2010-08-05 11:00:00	SPY	ETF	112.32	112.61	112.16	112.44	17899588.0
2010-08-05 12:00:00	SPY	ETF	112.4301	112.62	112.4	112.465	8794757.0
2010-08-05 13:00:00	SPY	ETF	112.46	112.74	112.31	112.669	9066466.0
2010-08-05 14:00:00	SPY	ETF	112.67	112.73	112.55	112.65	10318327.0
2010-08-05 15:00:00	SPY	ETF	112.659	112.91	112.61	112.84	24638908.0
2010-08-05 16:00:00	SPY	ETF	112.85	112.98	112.295	112.95	8753387.0
2010-08-05 17:00:00	SPY	ETF	112.96	112.98	112.91	112.95	192067.0
2010-08-05 18:00:00	SPY	ETF	112.96	112.96	112.85	112.9	56496.0
2010-08-05 19:00:00	SPY	ETF	112.91	112.91	112.87	112.87	59265.0
2010-08-05 05:00:00	QQQ	ETF	46.94	46.96	46.94	46.96	2682.0
2010-08-05 06:00:00	QQQ	ETF	47.0	47.03	47.0	47.02	770.0
2010-08-05 07:00:00	QQQ	ETF	47.03	47.04	46.9	46.91	16563.0
2010-08-05 08:00:00	QQQ	ETF	46.89	46.96	46.75	46.77	2759750.0
2010-08-05 09:00:00	QQQ	ETF	46.78	46.905	46.64	46.81	7494854.0
2010-08-05 10:00:00	QQQ	ETF	46.81	46.92	46.63	46.6405	5755478.0
2010-08-05 11:00:00	QQQ	ETF	46.65	46.78	46.52	46.71	6689198.0
2010-08-05 12:00:00	QQQ	ETF	46.7138	46.8	46.7	46.74	2922540.0
2010-08-05 13:00:00	QQQ	ETF	46.74	46.89	46.66	46.87	2262209.0
2010-08-05 14:00:00	QQQ	ETF	46.87	46.88	46.8	46.8219	2792326.0
2010-08-05 15:00:00	QQQ	ETF	46.8225	46.92	46.75	46.84	5888922.0
2010-08-05 16:00:00	QQQ	ETF	46.84	46.8505	46.6939	46.84	1987414.0
2010-08-05 17:00:00	QQQ	ETF	46.85	46.85	46.82	46.85	4960.0
2010-08-05 18:00:00	QQQ	ETF	46.83	46.85	46.8	46.8	8640.0
2010-08-05 19:00:00	QQQ	ETF	46.8	46.81	46.78	46.8	10872.0
2010-08-05 07:00:00	IWM	ETF	66.5	66.52	66.31	66.33	77800.0
2010-08-05 08:00:00	IWM	ETF	66.33	66.42	65.91	65.93	1314735.0
2010-08-05 09:00:00	IWM	ETF	65.93	66.15	65.48	65.96	6320620.0
2010-08-05 10:00:00	IWM	ETF	65.97	66.21	65.58	65.6599	7946562.0
2010-08-05 11:00:00	IWM	ETF	65.65	65.88	65.46	65.6799	4589011.0
2010-08-05 12:00:00	IWM	ETF	65.67	65.84	65.59	65.63	1559398.0
2010-08-05 13:00:00	IWM	ETF	65.6309	65.895	65.5	65.82	2163251.0
2010-08-05 14:00:00	IWM	ETF	65.82	65.9	65.73	65.75	2180484.0
2010-08-05 15:00:00	IWM	ETF	65.75	65.86	65.47	65.52	6213919.0
2010-08-05 16:00:00	IWM	ETF	65.53	66.3038	65.5069	65.59	3757708.0
2010-08-05 17:00:00	IWM	ETF	65.63	65.66	65.59	65.59	3041.0
2010-08-05 18:00:00	IWM	ETF	65.53	65.6	65.53	65.6	1100.0
2010-08-05 19:00:00	IWM	ETF	65.58	65.58	65.53	65.54	2500.0
2010-08-05 08:00:00	DIA	ETF	107.0	107.0	106.52	106.62	20739.0
2010-08-05 09:00:00	DIA	ETF	106.57	106.68	106.23	106.55	638121.0
2010-08-05 10:00:00	DIA	ETF	106.55	106.8	106.41	106.44	674863.0
2010-08-05 11:00:00	DIA	ETF	106.43	106.65	106.32	106.52	456984.0
2010-08-05 12:00:00	DIA	ETF	106.51	106.64	106.4845	106.53	241459.0
2010-08-05 13:00:00	DIA	ETF	106.52	106.75	106.38	106.69	252749.0

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

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