PREVIEW / etf_1hour / 2011-12-09

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-12-09.parquet
  size:    180 KB
  rows:    5,539

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
2011-12-09 04:00:00	SPY	ETF	124.55	124.55	124.17	124.32	20724.0
2011-12-09 05:00:00	SPY	ETF	124.32	125.22	124.27	125.22	36592.0
2011-12-09 06:00:00	SPY	ETF	125.22	125.51	125.0	125.39	112968.0
2011-12-09 07:00:00	SPY	ETF	125.38	125.51	125.08	125.14	775918.0
2011-12-09 08:00:00	SPY	ETF	125.12	125.24	124.48	124.59	5045447.0
2011-12-09 09:00:00	SPY	ETF	124.59	125.34	124.4	125.1	31619740.0
2011-12-09 10:00:00	SPY	ETF	125.1	125.55	124.96	125.47	35915956.0
2011-12-09 11:00:00	SPY	ETF	125.46	126.08	125.43	125.71	32185218.0
2011-12-09 12:00:00	SPY	ETF	125.71	126.0	125.58	125.83	16274815.0
2011-12-09 13:00:00	SPY	ETF	125.83	126.11	125.7304	125.89	10948847.0
2011-12-09 14:00:00	SPY	ETF	125.9	126.37	125.8	126.181	19209475.0
2011-12-09 15:00:00	SPY	ETF	126.18	126.36	125.92	126.03	37316418.0
2011-12-09 16:00:00	SPY	ETF	126.04	126.61	126.04	126.52	17759705.0
2011-12-09 17:00:00	SPY	ETF	126.53	126.57	126.42	126.5	396255.0
2011-12-09 18:00:00	SPY	ETF	126.48	126.6	126.03	126.56	185154.0
2011-12-09 19:00:00	SPY	ETF	126.56	126.6	126.5	126.6	96901.0
2011-12-09 04:00:00	QQQ	ETF	56.3	56.37	56.3	56.37	1300.0
2011-12-09 05:00:00	QQQ	ETF	56.34	56.52	56.34	56.52	1100.0
2011-12-09 06:00:00	QQQ	ETF	56.5	56.72	56.5	56.67	72100.0
2011-12-09 07:00:00	QQQ	ETF	56.7	56.75	56.51	56.54	400455.0
2011-12-09 08:00:00	QQQ	ETF	56.51	56.72	56.23	56.3	1894943.0
2011-12-09 09:00:00	QQQ	ETF	56.29	56.63	56.23	56.49	6587054.0
2011-12-09 10:00:00	QQQ	ETF	56.49	56.79	56.44	56.7699	10694657.0
2011-12-09 11:00:00	QQQ	ETF	56.77	56.97	56.74	56.84	5431810.0
2011-12-09 12:00:00	QQQ	ETF	56.8332	56.98	56.76	56.93	4402121.0
2011-12-09 13:00:00	QQQ	ETF	56.9399	57.1	56.89	56.99	3258121.0
2011-12-09 14:00:00	QQQ	ETF	56.99	57.19	56.96	57.13	5797645.0
2011-12-09 15:00:00	QQQ	ETF	57.14	57.16	56.99	57.02	8614798.0
2011-12-09 16:00:00	QQQ	ETF	57.02	57.19	57.01	57.14	1258184.0
2011-12-09 17:00:00	QQQ	ETF	57.12	57.18	57.0	57.09	148900.0
2011-12-09 18:00:00	QQQ	ETF	57.13	57.15	57.1	57.1	12700.0
2011-12-09 19:00:00	QQQ	ETF	57.15	57.18	57.1	57.18	31025.0
2011-12-09 04:00:00	IWM	ETF	72.58	72.58	72.36	72.36	1075.0
2011-12-09 05:00:00	IWM	ETF	72.63	72.74	72.58	72.74	1022.0
2011-12-09 07:00:00	IWM	ETF	73.0	73.21	72.85	72.96	41640.0
2011-12-09 08:00:00	IWM	ETF	72.96	73.25	72.49	72.55	829606.0
2011-12-09 09:00:00	IWM	ETF	72.55	73.155	72.38	72.95	8582238.0
2011-12-09 10:00:00	IWM	ETF	72.95	73.64	72.93	73.6	10215775.0
2011-12-09 11:00:00	IWM	ETF	73.61	74.09	73.58	73.93	7704387.0
2011-12-09 12:00:00	IWM	ETF	73.935	74.26	73.87	74.11	5404792.0
2011-12-09 13:00:00	IWM	ETF	74.12	74.36	74.02	74.3	3173089.0
2011-12-09 14:00:00	IWM	ETF	74.295	74.77	74.27	74.59	6224190.0
2011-12-09 15:00:00	IWM	ETF	74.59	74.97	74.4	74.56	10192521.0
2011-12-09 16:00:00	IWM	ETF	74.56	74.81	72.3219	74.74	6224081.0
2011-12-09 17:00:00	IWM	ETF	74.74	74.8	74.69	74.7	22674.0
2011-12-09 18:00:00	IWM	ETF	74.7	74.83	74.62	74.8	7533.0
2011-12-09 19:00:00	IWM	ETF	74.84	74.86	74.77	74.85	12022.0
2011-12-09 06:00:00	DIA	ETF	120.64	120.64	120.64	120.64	100.0
2011-12-09 07:00:00	DIA	ETF	121.1	121.31	121.1	121.13	7000.0
2011-12-09 08:00:00	DIA	ETF	121.0	121.0	120.35	120.46	96320.0

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

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