PREVIEW / etf_1hour / 2010-09-15

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-15.parquet
  size:    160 KB
  rows:    4,888

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-15 04:00:00	SPY	ETF	112.5	112.84	112.5	112.64	14200.0
2010-09-15 05:00:00	SPY	ETF	112.56	112.62	112.44	112.45	5474.0
2010-09-15 06:00:00	SPY	ETF	112.42	112.42	112.21	112.21	70586.0
2010-09-15 07:00:00	SPY	ETF	112.24	112.52	112.21	112.42	517667.0
2010-09-15 08:00:00	SPY	ETF	112.42	112.44	112.0	112.25	4083143.0
2010-09-15 09:00:00	SPY	ETF	112.24	112.42	111.98	112.41	24131106.0
2010-09-15 10:00:00	SPY	ETF	112.4	112.81	112.37	112.77	33605679.0
2010-09-15 11:00:00	SPY	ETF	112.78	112.9	112.43	112.8	18404815.0
2010-09-15 12:00:00	SPY	ETF	112.81	112.92	112.7	112.78	10480457.0
2010-09-15 13:00:00	SPY	ETF	112.79	113.03	112.78	112.92	11616755.0
2010-09-15 14:00:00	SPY	ETF	112.92	112.98	112.58	112.7901	13694093.0
2010-09-15 15:00:00	SPY	ETF	112.8	113.21	112.74	113.11	35858401.0
2010-09-15 16:00:00	SPY	ETF	113.11	113.24	112.0956	113.09	11132355.0
2010-09-15 17:00:00	SPY	ETF	113.1	113.15	113.09	113.13	293537.0
2010-09-15 18:00:00	SPY	ETF	113.13	113.16	113.06	113.09	139363.0
2010-09-15 19:00:00	SPY	ETF	113.08	113.16	113.07	113.07	55378.0
2010-09-15 04:00:00	QQQ	ETF	47.5	47.52	47.45	47.45	17180.0
2010-09-15 06:00:00	QQQ	ETF	47.34	47.34	47.34	47.34	100.0
2010-09-15 07:00:00	QQQ	ETF	47.29	47.41	47.27	47.36	74055.0
2010-09-15 08:00:00	QQQ	ETF	47.38	47.38	47.07	47.26	1352563.0
2010-09-15 09:00:00	QQQ	ETF	47.26	47.41	47.19	47.39	9224656.0
2010-09-15 10:00:00	QQQ	ETF	47.39	47.54	47.35	47.5301	10434834.0
2010-09-15 11:00:00	QQQ	ETF	47.54	47.61	47.4	47.579	6015486.0
2010-09-15 12:00:00	QQQ	ETF	47.57	47.67	47.57	47.625	4971844.0
2010-09-15 13:00:00	QQQ	ETF	47.63	47.7	47.6	47.66	4295153.0
2010-09-15 14:00:00	QQQ	ETF	47.6615	47.69	47.54	47.655	9377443.0
2010-09-15 15:00:00	QQQ	ETF	47.66	47.8	47.62	47.75	10855392.0
2010-09-15 16:00:00	QQQ	ETF	47.75	47.83	47.725	47.78	2445191.0
2010-09-15 17:00:00	QQQ	ETF	47.78	47.78	47.77	47.77	9442.0
2010-09-15 18:00:00	QQQ	ETF	47.78	47.8	47.75	47.77	24352.0
2010-09-15 19:00:00	QQQ	ETF	47.76	47.8	47.75	47.76	14241.0
2010-09-15 06:00:00	IWM	ETF	64.9	64.91	64.9	64.91	1200.0
2010-09-15 07:00:00	IWM	ETF	64.84	65.02	64.81	64.87	127200.0
2010-09-15 08:00:00	IWM	ETF	64.76	65.15	64.56	64.73	1572852.0
2010-09-15 09:00:00	IWM	ETF	64.73	64.86	64.33	64.62	7548154.0
2010-09-15 10:00:00	IWM	ETF	64.63	65.13	64.53	65.13	10178652.0
2010-09-15 11:00:00	IWM	ETF	65.13	65.26	64.86	65.23	6505357.0
2010-09-15 12:00:00	IWM	ETF	65.23	65.3	65.14	65.2	2480379.0
2010-09-15 13:00:00	IWM	ETF	65.2	65.42	65.195	65.37	4618290.0
2010-09-15 14:00:00	IWM	ETF	65.37	65.4	65.06	65.2	3845633.0
2010-09-15 15:00:00	IWM	ETF	65.2	65.57	65.15	65.36	11081428.0
2010-09-15 16:00:00	IWM	ETF	65.37	65.55	65.0	65.47	8655249.0
2010-09-15 17:00:00	IWM	ETF	65.47	65.5	65.47	65.5	4900.0
2010-09-15 18:00:00	IWM	ETF	65.5	65.55	65.49	65.49	3200.0
2010-09-15 06:00:00	DIA	ETF	105.25	105.25	105.24	105.24	300.0
2010-09-15 07:00:00	DIA	ETF	105.31	105.39	105.31	105.38	2200.0
2010-09-15 08:00:00	DIA	ETF	105.26	105.26	105.0	105.12	18509.0
2010-09-15 09:00:00	DIA	ETF	105.16	105.4	104.98	105.4	853528.0
2010-09-15 10:00:00	DIA	ETF	105.39	105.84	105.37	105.8399	832598.0
2010-09-15 11:00:00	DIA	ETF	105.84	105.89	105.56	105.82	530966.0

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

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