PREVIEW / etf_30min / 2013-07-03

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-03.parquet
  size:    202 KB
  rows:    6,386

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
2013-07-03 04:00:00	SPY	ETF	160.22	160.24	159.9	160.21	30990.0
2013-07-03 04:30:00	SPY	ETF	160.21	160.32	160.0	160.2	42200.0
2013-07-03 05:00:00	SPY	ETF	160.24	160.45	160.24	160.29	22100.0
2013-07-03 05:30:00	SPY	ETF	160.24	160.34	160.12	160.33	100559.0
2013-07-03 06:00:00	SPY	ETF	160.36	160.4	160.2	160.32	17000.0
2013-07-03 06:30:00	SPY	ETF	160.33	160.46	160.2	160.25	132650.0
2013-07-03 07:00:00	SPY	ETF	160.23	160.43	160.22	160.39	139746.0
2013-07-03 07:30:00	SPY	ETF	160.42	160.46	160.29	160.43	135616.0
2013-07-03 08:00:00	SPY	ETF	160.42	160.76	160.2	160.75	932978.0
2013-07-03 08:30:00	SPY	ETF	160.75	160.99	160.54	160.64	973317.0
2013-07-03 09:00:00	SPY	ETF	160.66	161.16	160.33	160.45	2122195.0
2013-07-03 09:30:00	SPY	ETF	160.48	160.89	160.22	160.6075	12049047.0
2013-07-03 10:00:00	SPY	ETF	160.61	160.89	160.3	160.859	11234077.0
2013-07-03 10:30:00	SPY	ETF	160.87	160.93	160.63	160.71	6505833.0
2013-07-03 11:00:00	SPY	ETF	160.71	161.19	160.7084	161.1	7006083.0
2013-07-03 11:30:00	SPY	ETF	161.08	161.59	161.01	161.59	7727265.0
2013-07-03 12:00:00	SPY	ETF	161.58	161.77	161.5	161.67	6422153.0
2013-07-03 12:30:00	SPY	ETF	161.67	161.72	161.31	161.35	9062803.0
2013-07-03 13:00:00	SPY	ETF	161.34	161.48	161.28	161.45	6785305.0
2013-07-03 13:30:00	SPY	ETF	161.45	161.54	161.263	161.5	2090867.0
2013-07-03 14:00:00	SPY	ETF	161.5	161.53	161.48	161.51	44621.0
2013-07-03 14:30:00	SPY	ETF	161.48	161.54	161.48	161.54	12686.0
2013-07-03 15:00:00	SPY	ETF	161.53	161.54	161.48	161.48	11104.0
2013-07-03 15:30:00	SPY	ETF	161.5199	161.53	161.47	161.47	19380.0
2013-07-03 16:00:00	SPY	ETF	161.47	161.53	161.47	161.47	6680.0
2013-07-03 16:30:00	SPY	ETF	161.5	161.52	161.5	161.5	17255.0
2013-07-03 04:00:00	QQQ	ETF	71.16	71.24	71.16	71.24	17400.0
2013-07-03 04:30:00	QQQ	ETF	71.26	71.29	71.17	71.24	13600.0
2013-07-03 05:00:00	QQQ	ETF	71.23	71.38	71.23	71.28	6200.0
2013-07-03 05:30:00	QQQ	ETF	71.27	71.33	71.23	71.33	7200.0
2013-07-03 06:00:00	QQQ	ETF	71.35	71.36	71.26	71.3	5976.0
2013-07-03 06:30:00	QQQ	ETF	71.27	71.36	71.26	71.3	4576.0
2013-07-03 07:00:00	QQQ	ETF	71.33	71.36	71.32	71.34	2888.0
2013-07-03 07:30:00	QQQ	ETF	71.33	71.38	71.32	71.38	2200.0
2013-07-03 08:00:00	QQQ	ETF	71.35	71.53	71.28	71.53	45525.0
2013-07-03 08:30:00	QQQ	ETF	71.54	71.65	71.5	71.6	79250.0
2013-07-03 09:00:00	QQQ	ETF	71.58	71.62	71.47	71.48	77320.0
2013-07-03 09:30:00	QQQ	ETF	71.48	71.84	71.42	71.72	3024567.0
2013-07-03 10:00:00	QQQ	ETF	71.72	71.92	71.56	71.919	2857279.0
2013-07-03 10:30:00	QQQ	ETF	71.92	71.97	71.79	71.89	1563643.0
2013-07-03 11:00:00	QQQ	ETF	71.89	72.02	71.841	71.99	957772.0
2013-07-03 11:30:00	QQQ	ETF	71.99	72.23	71.92	72.229	1348173.0
2013-07-03 12:00:00	QQQ	ETF	72.23	72.37	72.2	72.28	1714898.0
2013-07-03 12:30:00	QQQ	ETF	72.275	72.29	72.03	72.03	1970259.0
2013-07-03 13:00:00	QQQ	ETF	72.03	72.2409	71.614	72.1	729170.0
2013-07-03 13:30:00	QQQ	ETF	72.06	72.3	71.7631	72.15	2219957.0
2013-07-03 14:00:00	QQQ	ETF	72.14	72.14	72.05	72.05	894.0
2013-07-03 14:30:00	QQQ	ETF	72.06	72.14	72.04	72.14	2510.0
2013-07-03 15:00:00	QQQ	ETF	72.1	72.19	72.1	72.15	6271.0
2013-07-03 16:00:00	QQQ	ETF	72.18	72.2	72.13	72.16	2400.0

> showing 50 of 6,386 rows — these rows as CSV

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