PREVIEW / etf_1hour / 2012-03-08

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-08.parquet
  size:    187 KB
  rows:    5,801

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
2012-03-08 04:00:00	SPY	ETF	136.15	136.79	136.15	136.72	93377.0
2012-03-08 05:00:00	SPY	ETF	136.7	136.89	136.67	136.88	69489.0
2012-03-08 06:00:00	SPY	ETF	136.95	137.03	136.88	137.0	252175.0
2012-03-08 07:00:00	SPY	ETF	137.0	137.05	136.79	136.83	1511910.0
2012-03-08 08:00:00	SPY	ETF	136.86	136.96	136.59	136.61	2154692.0
2012-03-08 09:00:00	SPY	ETF	136.61	136.8257	136.42	136.5	14613938.0
2012-03-08 10:00:00	SPY	ETF	136.49	136.59	136.24	136.57	17486849.0
2012-03-08 11:00:00	SPY	ETF	136.58	136.81	136.55	136.79	14057473.0
2012-03-08 12:00:00	SPY	ETF	136.79	137.02	136.77	136.98	9369577.0
2012-03-08 13:00:00	SPY	ETF	136.985	137.0	136.85	136.86	7911928.0
2012-03-08 14:00:00	SPY	ETF	136.86	137.25	136.8	137.1901	13029304.0
2012-03-08 15:00:00	SPY	ETF	137.2	137.32	137.0	137.02	22782231.0
2012-03-08 16:00:00	SPY	ETF	137.02	137.19	136.0246	137.04	10323700.0
2012-03-08 17:00:00	SPY	ETF	137.03	137.12	137.01	137.07	403078.0
2012-03-08 18:00:00	SPY	ETF	137.07	137.18	137.02	137.09	98207.0
2012-03-08 19:00:00	SPY	ETF	137.1	137.1	136.89	136.94	170553.0
2012-03-08 04:00:00	QQQ	ETF	64.35	64.5	64.35	64.48	1900.0
2012-03-08 05:00:00	QQQ	ETF	64.56	64.56	64.56	64.56	300.0
2012-03-08 06:00:00	QQQ	ETF	64.6	64.64	64.53	64.54	9230.0
2012-03-08 07:00:00	QQQ	ETF	64.56	64.58	64.45	64.48	645061.0
2012-03-08 08:00:00	QQQ	ETF	64.47	64.54	64.41	64.42	1615300.0
2012-03-08 09:00:00	QQQ	ETF	64.43	64.52	64.35	64.45	6142268.0
2012-03-08 10:00:00	QQQ	ETF	64.45	64.52	64.3	64.5	5925785.0
2012-03-08 11:00:00	QQQ	ETF	64.51	64.65	64.5	64.6299	4805330.0
2012-03-08 12:00:00	QQQ	ETF	64.622	64.77	64.61	64.7393	2985337.0
2012-03-08 13:00:00	QQQ	ETF	64.7379	64.79	64.69	64.735	2847124.0
2012-03-08 14:00:00	QQQ	ETF	64.7305	64.87	64.65	64.83	3784659.0
2012-03-08 15:00:00	QQQ	ETF	64.83	64.94	64.74	64.74	7811326.0
2012-03-08 16:00:00	QQQ	ETF	64.74	64.82	64.72	64.73	1736261.0
2012-03-08 17:00:00	QQQ	ETF	64.73	64.75	64.72	64.73	22606.0
2012-03-08 18:00:00	QQQ	ETF	64.73	64.76	64.73	64.75	93345.0
2012-03-08 19:00:00	QQQ	ETF	64.75	64.75	64.64	64.66	70930.0
2012-03-08 04:00:00	IWM	ETF	79.84	80.2	79.84	80.2	693.0
2012-03-08 06:00:00	IWM	ETF	80.4	80.4	80.4	80.4	318.0
2012-03-08 07:00:00	IWM	ETF	80.47	80.52	80.31	80.36	53745.0
2012-03-08 08:00:00	IWM	ETF	80.36	80.42	79.34	80.17	353871.0
2012-03-08 09:00:00	IWM	ETF	80.18	80.21	79.74	79.8	3916794.0
2012-03-08 10:00:00	IWM	ETF	79.8	79.84	79.35	79.81	9149416.0
2012-03-08 11:00:00	IWM	ETF	79.8	80.29	79.79	80.17	4995996.0
2012-03-08 12:00:00	IWM	ETF	80.17	80.37	80.16	80.27	3454737.0
2012-03-08 13:00:00	IWM	ETF	80.275	80.48	80.18	80.4	3124853.0
2012-03-08 14:00:00	IWM	ETF	80.4	80.63	80.23	80.6	3536494.0
2012-03-08 15:00:00	IWM	ETF	80.61	80.69	80.5	80.52	7825079.0
2012-03-08 16:00:00	IWM	ETF	80.53	80.5839	80.42	80.48	2546395.0
2012-03-08 17:00:00	IWM	ETF	80.48	80.51	80.47	80.49	10632.0
2012-03-08 18:00:00	IWM	ETF	80.48	80.52	80.48	80.52	300.0
2012-03-08 19:00:00	IWM	ETF	80.48	80.52	80.43	80.43	22800.0
2012-03-08 06:00:00	DIA	ETF	129.31	129.33	129.31	129.33	200.0
2012-03-08 07:00:00	DIA	ETF	129.34	129.66	129.25	129.26	5000.0
2012-03-08 08:00:00	DIA	ETF	129.2	129.35	128.9	128.9	46853.0

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

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