PREVIEW / etf_30min / 2011-07-28

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-28.parquet
  size:    288 KB
  rows:    9,507

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-07-28 04:00:00	SPY	ETF	130.77	131.0	130.77	130.95	1362.0
2011-07-28 04:30:00	SPY	ETF	130.95	130.95	130.92	130.92	1988.0
2011-07-28 05:00:00	SPY	ETF	130.62	130.8	130.62	130.8	1500.0
2011-07-28 05:30:00	SPY	ETF	130.7	130.7	130.4	130.4	2100.0
2011-07-28 06:00:00	SPY	ETF	130.3	130.44	130.11	130.11	4121.0
2011-07-28 06:30:00	SPY	ETF	130.11	130.7	130.11	130.6	119550.0
2011-07-28 07:00:00	SPY	ETF	130.64	130.67	130.43	130.56	210799.0
2011-07-28 07:30:00	SPY	ETF	130.55	130.75	130.48	130.53	245935.0
2011-07-28 08:00:00	SPY	ETF	130.54	130.55	130.18	130.18	664738.0
2011-07-28 08:30:00	SPY	ETF	130.3	131.05	130.3	130.6	6586873.0
2011-07-28 09:00:00	SPY	ETF	130.6	130.7	130.55	130.59	1915649.0
2011-07-28 09:30:00	SPY	ETF	130.6	130.92	130.45	130.79	20139615.0
2011-07-28 10:00:00	SPY	ETF	130.8	131.23	130.48	130.97	17804624.0
2011-07-28 10:30:00	SPY	ETF	130.975	131.2	130.85	131.16	12181315.0
2011-07-28 11:00:00	SPY	ETF	131.15	131.72	131.04	131.65	14754140.0
2011-07-28 11:30:00	SPY	ETF	131.65	131.73	131.5	131.66	10306039.0
2011-07-28 12:00:00	SPY	ETF	131.669	131.77	131.3	131.4	12330656.0
2011-07-28 12:30:00	SPY	ETF	131.4	131.48	131.2	131.39	7439087.0
2011-07-28 13:00:00	SPY	ETF	131.4	131.48	131.14	131.2801	8140062.0
2011-07-28 13:30:00	SPY	ETF	131.29	131.49	131.21	131.32	6865059.0
2011-07-28 14:00:00	SPY	ETF	131.325	131.35	130.82	130.89	9786610.0
2011-07-28 14:30:00	SPY	ETF	130.89	131.07	130.73	130.905	11142412.0
2011-07-28 15:00:00	SPY	ETF	130.9	130.9	130.33	130.36	8991231.0
2011-07-28 15:30:00	SPY	ETF	130.35	130.45	130.01	130.22	38365988.0
2011-07-28 16:00:00	SPY	ETF	130.21	130.5968	130.06	130.21	11016344.0
2011-07-28 16:30:00	SPY	ETF	130.24	130.9188	130.22	130.29	4851417.0
2011-07-28 17:00:00	SPY	ETF	130.3	130.35	129.7	129.89	434555.0
2011-07-28 17:30:00	SPY	ETF	129.88	130.5962	129.74	130.1	1421207.0
2011-07-28 18:00:00	SPY	ETF	130.1	130.34	129.94	129.97	347389.0
2011-07-28 18:30:00	SPY	ETF	129.98	130.03	129.8	130.02	120797.0
2011-07-28 19:00:00	SPY	ETF	130.03	130.08	129.92	130.06	49474.0
2011-07-28 19:30:00	SPY	ETF	130.05	130.13	129.99	130.05	50566.0
2011-07-28 04:00:00	QQQ	ETF	58.3	58.3	58.3	58.3	100.0
2011-07-28 06:30:00	QQQ	ETF	57.94	58.03	57.94	58.03	300.0
2011-07-28 07:00:00	QQQ	ETF	58.05	58.07	58.0	58.03	50200.0
2011-07-28 07:30:00	QQQ	ETF	58.03	58.12	58.03	58.03	3809.0
2011-07-28 08:00:00	QQQ	ETF	58.06	58.06	57.92	57.97	185810.0
2011-07-28 08:30:00	QQQ	ETF	58.05	58.3	58.03	58.14	482935.0
2011-07-28 09:00:00	QQQ	ETF	58.16	58.17	58.07	58.11	206975.0
2011-07-28 09:30:00	QQQ	ETF	58.11	58.3	57.89	58.27	8736463.0
2011-07-28 10:00:00	QQQ	ETF	58.27	58.48	58.12	58.4	4734815.0
2011-07-28 10:30:00	QQQ	ETF	58.399	58.6	58.3401	58.5501	3365907.0
2011-07-28 11:00:00	QQQ	ETF	58.55	58.89	58.51	58.88	3312575.0
2011-07-28 11:30:00	QQQ	ETF	58.89	58.89	58.78	58.87	3997300.0
2011-07-28 12:00:00	QQQ	ETF	58.87	58.93	58.7	58.74	3850339.0
2011-07-28 12:30:00	QQQ	ETF	58.74	58.81	58.69	58.7829	1955241.0
2011-07-28 13:00:00	QQQ	ETF	58.78	58.87	58.68	58.74	3836236.0
2011-07-28 13:30:00	QQQ	ETF	58.74	58.84	58.71	58.75	1723872.0
2011-07-28 14:00:00	QQQ	ETF	58.755	58.7638	58.45	58.4701	2981994.0
2011-07-28 14:30:00	QQQ	ETF	58.4799	58.61	58.355	58.52	4689062.0

> showing 50 of 9,507 rows — these rows as CSV

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