PREVIEW / etf_30min / 2014-05-22

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-05-22.parquet
  size:    323 KB
  rows:    11,140

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
2014-05-22 04:00:00	SPY	ETF	189.23	189.28	189.22	189.25	3190.0
2014-05-22 04:30:00	SPY	ETF	189.31	189.37	189.27	189.29	2256.0
2014-05-22 05:00:00	SPY	ETF	189.19	189.24	189.17	189.24	2450.0
2014-05-22 05:30:00	SPY	ETF	189.16	189.39	189.16	189.23	3300.0
2014-05-22 06:00:00	SPY	ETF	189.19	189.31	189.15	189.27	3899.0
2014-05-22 06:30:00	SPY	ETF	189.24	189.3	189.17	189.17	60987.0
2014-05-22 07:00:00	SPY	ETF	189.17	189.18	189.08	189.12	39076.0
2014-05-22 07:30:00	SPY	ETF	189.12	189.17	189.01	189.15	100144.0
2014-05-22 08:00:00	SPY	ETF	189.12	189.47	189.04	189.29	246792.0
2014-05-22 08:30:00	SPY	ETF	189.28	189.28	189.08	189.2	239888.0
2014-05-22 09:00:00	SPY	ETF	189.18	189.29	189.12	189.19	496076.0
2014-05-22 09:30:00	SPY	ETF	189.18	189.55	188.86	189.43	9497456.0
2014-05-22 10:00:00	SPY	ETF	189.45	189.52	189.12	189.33	6101625.0
2014-05-22 10:30:00	SPY	ETF	189.33	189.7	189.325	189.62	4582356.0
2014-05-22 11:00:00	SPY	ETF	189.62	189.85	189.54	189.79	4847513.0
2014-05-22 11:30:00	SPY	ETF	189.8	189.95	189.72	189.77	4137659.0
2014-05-22 12:00:00	SPY	ETF	189.77	189.81	189.66	189.77	2095448.0
2014-05-22 12:30:00	SPY	ETF	189.77	189.83	189.64	189.67	5123557.0
2014-05-22 13:00:00	SPY	ETF	189.67	189.88	189.67	189.869	1648319.0
2014-05-22 13:30:00	SPY	ETF	189.869	189.96	189.83	189.875	2455415.0
2014-05-22 14:00:00	SPY	ETF	189.87	189.91	189.83	189.881	2590702.0
2014-05-22 14:30:00	SPY	ETF	189.881	189.98	189.85	189.975	1882885.0
2014-05-22 15:00:00	SPY	ETF	189.97	189.97	189.71	189.75	3864453.0
2014-05-22 15:30:00	SPY	ETF	189.755	189.79	189.58	189.595	8890280.0
2014-05-22 16:00:00	SPY	ETF	189.59	189.77	189.53	189.6	1547136.0
2014-05-22 16:30:00	SPY	ETF	189.6	189.64	189.4962	189.6	627075.0
2014-05-22 17:00:00	SPY	ETF	189.61	189.63	189.59	189.61	4569.0
2014-05-22 17:30:00	SPY	ETF	189.6	189.64	189.57	189.63	10780.0
2014-05-22 18:00:00	SPY	ETF	189.6	189.61	189.59	189.61	12630.0
2014-05-22 18:30:00	SPY	ETF	189.61	189.64	189.61	189.64	3600.0
2014-05-22 19:00:00	SPY	ETF	189.64	189.64	189.64	189.64	1400.0
2014-05-22 19:30:00	SPY	ETF	189.63	189.64	189.6	189.63	11842.0
2014-05-22 04:00:00	QQQ	ETF	88.91	88.95	88.91	88.95	300.0
2014-05-22 04:30:00	QQQ	ETF	88.98	88.98	88.98	88.98	100.0
2014-05-22 05:00:00	QQQ	ETF	88.96	89.0	88.96	89.0	23471.0
2014-05-22 05:30:00	QQQ	ETF	88.93	88.93	88.93	88.93	300.0
2014-05-22 06:00:00	QQQ	ETF	88.87	88.87	88.87	88.87	100.0
2014-05-22 06:30:00	QQQ	ETF	88.93	88.95	88.93	88.93	4400.0
2014-05-22 07:00:00	QQQ	ETF	88.9	88.9	88.89	88.89	300.0
2014-05-22 07:30:00	QQQ	ETF	88.91	88.92	88.88	88.92	2400.0
2014-05-22 08:00:00	QQQ	ETF	88.92	89.01	88.89	88.98	118201.0
2014-05-22 08:30:00	QQQ	ETF	88.95	88.98	88.9	88.92	51033.0
2014-05-22 09:00:00	QQQ	ETF	88.93	88.97	88.9	88.95	43529.0
2014-05-22 09:30:00	QQQ	ETF	88.94	89.2	88.83	89.13	4156130.0
2014-05-22 10:00:00	QQQ	ETF	89.14	89.18	88.8	88.96	4694343.0
2014-05-22 10:30:00	QQQ	ETF	88.955	89.27	88.95	89.22	2144095.0
2014-05-22 11:00:00	QQQ	ETF	89.22	89.36	89.15	89.31	2764765.0
2014-05-22 11:30:00	QQQ	ETF	89.32	89.39	89.25	89.3	1371017.0
2014-05-22 12:00:00	QQQ	ETF	89.3	89.3	89.19	89.27	679978.0
2014-05-22 12:30:00	QQQ	ETF	89.265	89.32	89.18	89.2099	645739.0

> showing 50 of 11,140 rows — these rows as CSV

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