PREVIEW / etf_1hour / 2010-09-23

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-23.parquet
  size:    168 KB
  rows:    5,128

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-09-23 04:00:00	SPY	ETF	113.4	113.4	112.76	112.76	7350.0
2010-09-23 05:00:00	SPY	ETF	112.83	112.85	112.74	112.77	2800.0
2010-09-23 06:00:00	SPY	ETF	112.86	112.96	112.65	112.74	148950.0
2010-09-23 07:00:00	SPY	ETF	112.71	112.79	112.55	112.66	453985.0
2010-09-23 08:00:00	SPY	ETF	112.92	112.92	112.22	112.36	5461996.0
2010-09-23 09:00:00	SPY	ETF	112.34	113.43	112.27	112.54	25235755.0
2010-09-23 10:00:00	SPY	ETF	112.55	113.43	112.522	113.19	46567771.0
2010-09-23 11:00:00	SPY	ETF	113.18	113.67	113.1079	113.4593	23208451.0
2010-09-23 12:00:00	SPY	ETF	113.45	113.52	113.25	113.35	11475176.0
2010-09-23 13:00:00	SPY	ETF	113.34	113.43	113.14	113.21	9558757.0
2010-09-23 14:00:00	SPY	ETF	113.215	113.38	112.78	112.825	17611018.0
2010-09-23 15:00:00	SPY	ETF	112.83	112.91	112.18	112.49	50740875.0
2010-09-23 16:00:00	SPY	ETF	112.49	113.615	112.315	112.46	9723699.0
2010-09-23 17:00:00	SPY	ETF	112.46	112.52	112.44	112.52	81695.0
2010-09-23 18:00:00	SPY	ETF	112.5	112.57	112.38	112.43	100415.0
2010-09-23 19:00:00	SPY	ETF	112.42	112.43	112.33	112.33	134621.0
2010-09-23 04:00:00	QQQ	ETF	48.78	48.78	48.5	48.5	2100.0
2010-09-23 05:00:00	QQQ	ETF	48.53	48.53	48.49	48.49	200.0
2010-09-23 06:00:00	QQQ	ETF	48.56	48.56	48.46	48.48	2250.0
2010-09-23 07:00:00	QQQ	ETF	48.48	48.49	48.38	48.43	339905.0
2010-09-23 08:00:00	QQQ	ETF	48.43	48.5	48.24	48.31	1423186.0
2010-09-23 09:00:00	QQQ	ETF	48.3	48.65	48.28	48.59	10003851.0
2010-09-23 10:00:00	QQQ	ETF	48.58	48.99	48.58	48.9	15596022.0
2010-09-23 11:00:00	QQQ	ETF	48.89	49.16	48.86	49.0747	10547246.0
2010-09-23 12:00:00	QQQ	ETF	49.07	49.12	49.0	49.02	3997014.0
2010-09-23 13:00:00	QQQ	ETF	49.03	49.095	48.97	49.0	3710074.0
2010-09-23 14:00:00	QQQ	ETF	49.0	49.08	48.72	48.76	7126969.0
2010-09-23 15:00:00	QQQ	ETF	48.76	48.78	48.49	48.67	20415549.0
2010-09-23 16:00:00	QQQ	ETF	48.66	48.76	48.6103	48.7	7572371.0
2010-09-23 17:00:00	QQQ	ETF	48.71	48.75	48.6741	48.71	1095523.0
2010-09-23 18:00:00	QQQ	ETF	48.73	48.74	48.67	48.68	31600.0
2010-09-23 19:00:00	QQQ	ETF	48.67	48.68	48.62	48.62	91217.0
2010-09-23 05:00:00	IWM	ETF	65.32	65.32	65.27	65.31	2300.0
2010-09-23 06:00:00	IWM	ETF	65.36	65.36	65.15	65.22	6200.0
2010-09-23 07:00:00	IWM	ETF	65.26	65.26	65.12	65.17	92350.0
2010-09-23 08:00:00	IWM	ETF	65.18	65.74	64.89	64.99	578502.0
2010-09-23 09:00:00	IWM	ETF	64.99	65.32	64.881	65.04	7914996.0
2010-09-23 10:00:00	IWM	ETF	65.04	65.95	65.04	65.59	11280596.0
2010-09-23 11:00:00	IWM	ETF	65.59	66.16	65.51	65.97	6177814.0
2010-09-23 12:00:00	IWM	ETF	65.96	66.04	65.69	65.79	2482218.0
2010-09-23 13:00:00	IWM	ETF	65.79	65.87	65.445	65.53	2969787.0
2010-09-23 14:00:00	IWM	ETF	65.53	65.67	65.0	65.08	9087588.0
2010-09-23 15:00:00	IWM	ETF	65.08	65.13	64.66	64.87	11054719.0
2010-09-23 16:00:00	IWM	ETF	64.87	65.6265	64.8022	64.88	8103526.0
2010-09-23 17:00:00	IWM	ETF	64.91	64.93	64.89	64.89	7600.0
2010-09-23 18:00:00	IWM	ETF	64.9	64.9	64.87	64.87	900.0
2010-09-23 19:00:00	IWM	ETF	64.84	64.84	64.84	64.84	100.0
2010-09-23 08:00:00	DIA	ETF	106.87	106.87	106.53	106.59	91349.0
2010-09-23 09:00:00	DIA	ETF	106.58	106.82	106.43	106.65	1388718.0
2010-09-23 10:00:00	DIA	ETF	106.65	107.45	106.63	107.25	1512769.0

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

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