PREVIEW / etf_1hour / 2011-06-06

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-06-06.parquet
  size:    181 KB
  rows:    5,535

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-06-06 04:00:00	SPY	ETF	130.05	130.05	129.97	130.0	1800.0
2011-06-06 05:00:00	SPY	ETF	130.2	130.24	130.01	130.1	22300.0
2011-06-06 06:00:00	SPY	ETF	130.01	130.07	129.88	129.88	15250.0
2011-06-06 07:00:00	SPY	ETF	129.92	129.98	129.75	129.79	307020.0
2011-06-06 08:00:00	SPY	ETF	129.75	130.27	129.75	130.16	2118552.0
2011-06-06 09:00:00	SPY	ETF	130.16	130.42	129.855	129.99	25683129.0
2011-06-06 10:00:00	SPY	ETF	129.99	130.02	129.53	129.6671	29343030.0
2011-06-06 11:00:00	SPY	ETF	129.67	130.16	129.62	130.05	16932275.0
2011-06-06 12:00:00	SPY	ETF	130.06	130.12	129.8	129.9	9443585.0
2011-06-06 13:00:00	SPY	ETF	129.8933	130.05	129.39	129.519	14867627.0
2011-06-06 14:00:00	SPY	ETF	129.52	129.72	129.18	129.28	17096584.0
2011-06-06 15:00:00	SPY	ETF	129.2801	129.6	128.87	129.05	48585049.0
2011-06-06 16:00:00	SPY	ETF	129.04	129.6	128.94	129.02	14402215.0
2011-06-06 17:00:00	SPY	ETF	129.0	129.01	128.92	128.93	411037.0
2011-06-06 18:00:00	SPY	ETF	128.96	129.11	128.94	129.01	627541.0
2011-06-06 19:00:00	SPY	ETF	129.03	129.08	129.03	129.04	100976.0
2011-06-06 05:00:00	QQQ	ETF	56.26	56.26	56.23	56.23	300.0
2011-06-06 06:00:00	QQQ	ETF	56.13	56.14	56.0	56.14	700.0
2011-06-06 07:00:00	QQQ	ETF	56.14	56.15	56.06	56.06	37255.0
2011-06-06 08:00:00	QQQ	ETF	56.05	56.31	56.05	56.27	414621.0
2011-06-06 09:00:00	QQQ	ETF	56.26	56.47	56.22	56.46	4452403.0
2011-06-06 10:00:00	QQQ	ETF	56.46	56.47	56.21	56.27	8085438.0
2011-06-06 11:00:00	QQQ	ETF	56.26	56.53	56.25	56.41	4731115.0
2011-06-06 12:00:00	QQQ	ETF	56.41	56.43	56.27	56.33	2158889.0
2011-06-06 13:00:00	QQQ	ETF	56.33	56.47	56.08	56.13	6137981.0
2011-06-06 14:00:00	QQQ	ETF	56.13	56.27	55.98	56.04	3908203.0
2011-06-06 15:00:00	QQQ	ETF	56.04	56.1	55.86	55.8978	9120377.0
2011-06-06 16:00:00	QQQ	ETF	55.89	55.94	55.84	55.86	5301706.0
2011-06-06 17:00:00	QQQ	ETF	55.88	55.91	55.81	55.88	65905.0
2011-06-06 18:00:00	QQQ	ETF	55.88	55.9	55.85	55.86	63094.0
2011-06-06 19:00:00	QQQ	ETF	55.88	55.93	55.86	55.92	21290.0
2011-06-06 04:00:00	IWM	ETF	80.8	80.8	80.8	80.8	100.0
2011-06-06 05:00:00	IWM	ETF	80.73	80.73	80.67	80.73	2200.0
2011-06-06 06:00:00	IWM	ETF	80.66	80.72	80.51	80.6	7200.0
2011-06-06 07:00:00	IWM	ETF	80.6	80.6	80.46	80.5	9395.0
2011-06-06 08:00:00	IWM	ETF	80.48	80.86	80.42	80.79	230394.0
2011-06-06 09:00:00	IWM	ETF	80.78	81.07	80.57	80.74	5662539.0
2011-06-06 10:00:00	IWM	ETF	80.74	80.76	80.07	80.225	9934478.0
2011-06-06 11:00:00	IWM	ETF	80.22	80.665	80.16	80.41	5012627.0
2011-06-06 12:00:00	IWM	ETF	80.402	80.43	80.2	80.29	2837872.0
2011-06-06 13:00:00	IWM	ETF	80.28	80.375	79.87	80.072	5641143.0
2011-06-06 14:00:00	IWM	ETF	80.08	80.238	79.8	79.94	6530227.0
2011-06-06 15:00:00	IWM	ETF	79.9289	79.99	79.49	79.55	15828279.0
2011-06-06 16:00:00	IWM	ETF	79.55	79.7	79.54	79.63	2446317.0
2011-06-06 17:00:00	IWM	ETF	79.62	79.66	79.55	79.6	155350.0
2011-06-06 18:00:00	IWM	ETF	79.57	79.63	79.52	79.53	20150.0
2011-06-06 19:00:00	IWM	ETF	79.55	79.63	79.52	79.58	6200.0
2011-06-06 05:00:00	DIA	ETF	121.08	121.08	121.08	121.08	100.0
2011-06-06 06:00:00	DIA	ETF	121.12	121.12	120.91	120.91	520.0
2011-06-06 07:00:00	DIA	ETF	120.92	120.92	120.86	120.86	2100.0

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

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