PREVIEW / etf_30min / 2014-03-03

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-03.parquet
  size:    360 KB
  rows:    12,097

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-03-03 04:00:00	SPY	ETF	185.1	185.1	184.84	184.89	43115.0
2014-03-03 04:30:00	SPY	ETF	184.91	184.91	184.6	184.6	23765.0
2014-03-03 05:00:00	SPY	ETF	184.74	184.87	184.64	184.8	76458.0
2014-03-03 05:30:00	SPY	ETF	184.76	184.76	184.46	184.52	73061.0
2014-03-03 06:00:00	SPY	ETF	184.5	184.5	184.25	184.31	113667.0
2014-03-03 06:30:00	SPY	ETF	184.32	184.37	184.1	184.19	214396.0
2014-03-03 07:00:00	SPY	ETF	184.17	184.35	184.09	184.24	590243.0
2014-03-03 07:30:00	SPY	ETF	184.21	184.8	184.21	184.77	682547.0
2014-03-03 08:00:00	SPY	ETF	184.76	184.95	184.18	184.7	1747962.0
2014-03-03 08:30:00	SPY	ETF	184.69	184.77	184.35	184.69	1875459.0
2014-03-03 09:00:00	SPY	ETF	184.69	186.29	184.57	184.68	1735486.0
2014-03-03 09:30:00	SPY	ETF	184.69	185.41	184.41	185.15	19426672.0
2014-03-03 10:00:00	SPY	ETF	185.17	185.45	184.47	184.85	19047960.0
2014-03-03 10:30:00	SPY	ETF	184.84	185.09	184.59	185.06	8098945.0
2014-03-03 11:00:00	SPY	ETF	185.065	185.1	184.37	184.55	10410186.0
2014-03-03 11:30:00	SPY	ETF	184.54	184.6	184.05	184.05	9676463.0
2014-03-03 12:00:00	SPY	ETF	184.06	184.49	183.75	184.3	16331051.0
2014-03-03 12:30:00	SPY	ETF	184.285	184.54	184.22	184.465	5170760.0
2014-03-03 13:00:00	SPY	ETF	184.46	184.87	184.4401	184.68	7036731.0
2014-03-03 13:30:00	SPY	ETF	184.68	185.015	184.5	184.89	5380793.0
2014-03-03 14:00:00	SPY	ETF	184.8905	185.05	184.67	184.69	6748958.0
2014-03-03 14:30:00	SPY	ETF	184.6899	185.22	184.56	184.95	7511546.0
2014-03-03 15:00:00	SPY	ETF	184.93	184.96	184.33	184.6	11358893.0
2014-03-03 15:30:00	SPY	ETF	184.6	184.93	184.45	184.93	17196056.0
2014-03-03 16:00:00	SPY	ETF	184.95	186.2766	184.3575	184.82	12157105.0
2014-03-03 16:30:00	SPY	ETF	184.81	186.2766	184.81	184.9	1984633.0
2014-03-03 17:00:00	SPY	ETF	184.91	184.91	184.86	184.89	18891.0
2014-03-03 17:30:00	SPY	ETF	184.88	184.94	184.87	184.93	22174.0
2014-03-03 18:00:00	SPY	ETF	184.93	185.02	184.9	185.0	55466.0
2014-03-03 18:30:00	SPY	ETF	185.0	185.01	184.92	185.01	43400.0
2014-03-03 19:00:00	SPY	ETF	185.0	185.14	185.0	185.08	95427.0
2014-03-03 19:30:00	SPY	ETF	185.07	185.11	184.98	185.11	105025.0
2014-03-03 04:00:00	QQQ	ETF	89.68	89.68	89.61	89.61	5516.0
2014-03-03 04:30:00	QQQ	ETF	89.63	89.63	89.49	89.53	3400.0
2014-03-03 05:00:00	QQQ	ETF	89.55	89.61	89.54	89.6	29000.0
2014-03-03 05:30:00	QQQ	ETF	89.56	89.56	89.4	89.41	2700.0
2014-03-03 06:00:00	QQQ	ETF	89.36	89.37	89.31	89.32	37073.0
2014-03-03 06:30:00	QQQ	ETF	89.33	89.36	89.29	89.3	244700.0
2014-03-03 07:00:00	QQQ	ETF	89.28	89.36	89.26	89.32	52891.0
2014-03-03 07:30:00	QQQ	ETF	89.34	89.56	89.34	89.54	75755.0
2014-03-03 08:00:00	QQQ	ETF	89.54	89.63	89.28	89.52	268301.0
2014-03-03 08:30:00	QQQ	ETF	89.52	89.56	89.38	89.51	211494.0
2014-03-03 09:00:00	QQQ	ETF	89.51	89.61	89.42	89.48	630803.0
2014-03-03 09:30:00	QQQ	ETF	89.48	89.86	89.27	89.7899	5885553.0
2014-03-03 10:00:00	QQQ	ETF	89.79	89.91	89.285	89.54	5945049.0
2014-03-03 10:30:00	QQQ	ETF	89.535	89.72	89.42	89.71	1851289.0
2014-03-03 11:00:00	QQQ	ETF	89.715	89.72	89.32	89.41	2066731.0
2014-03-03 11:30:00	QQQ	ETF	89.41	89.44	89.081	89.081	2146760.0
2014-03-03 12:00:00	QQQ	ETF	89.09	89.23	88.87	89.1	4121944.0
2014-03-03 12:30:00	QQQ	ETF	89.11	89.31	89.08	89.28	1019439.0

> showing 50 of 12,097 rows — these rows as CSV

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