PREVIEW / etf_30min / 2014-02-04

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-04.parquet
  size:    358 KB
  rows:    11,949

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-02-04 04:00:00	SPY	ETF	174.6	174.66	174.49	174.61	189864.0
2014-02-04 04:30:00	SPY	ETF	174.65	174.8	174.65	174.66	321424.0
2014-02-04 05:00:00	SPY	ETF	174.67	174.73	174.52	174.52	40140.0
2014-02-04 05:30:00	SPY	ETF	174.5	174.5	174.27	174.35	38885.0
2014-02-04 06:00:00	SPY	ETF	174.33	174.42	174.23	174.34	77383.0
2014-02-04 06:30:00	SPY	ETF	174.35	174.5	174.35	174.36	39527.0
2014-02-04 07:00:00	SPY	ETF	174.38	174.5	174.29	174.4	141736.0
2014-02-04 07:30:00	SPY	ETF	174.38	174.48	174.24	174.43	233201.0
2014-02-04 08:00:00	SPY	ETF	174.44	174.95	174.24	174.9	949341.0
2014-02-04 08:30:00	SPY	ETF	174.87	175.06	174.7	175.02	880708.0
2014-02-04 09:00:00	SPY	ETF	174.99	175.06	174.79	174.97	2019179.0
2014-02-04 09:30:00	SPY	ETF	174.95	175.295	174.34	175.15	25070294.0
2014-02-04 10:00:00	SPY	ETF	175.15	175.26	174.68	174.92	15998279.0
2014-02-04 10:30:00	SPY	ETF	174.92	175.26	174.64	174.78	10375162.0
2014-02-04 11:00:00	SPY	ETF	174.78	175.36	174.68	175.09	10286738.0
2014-02-04 11:30:00	SPY	ETF	175.1	175.59	175.01	175.57	8025707.0
2014-02-04 12:00:00	SPY	ETF	175.58	175.7	175.39	175.515	8700231.0
2014-02-04 12:30:00	SPY	ETF	175.53	175.76	175.48	175.63	4972102.0
2014-02-04 13:00:00	SPY	ETF	175.64	175.84	175.35	175.5499	6125504.0
2014-02-04 13:30:00	SPY	ETF	175.541	175.65	175.01	175.1	9499118.0
2014-02-04 14:00:00	SPY	ETF	175.1	175.45	174.96	175.355	6369760.0
2014-02-04 14:30:00	SPY	ETF	175.36	175.61	175.27	175.53	5466302.0
2014-02-04 15:00:00	SPY	ETF	175.52	175.65	174.88	174.94	9531280.0
2014-02-04 15:30:00	SPY	ETF	174.948	175.64	174.84	175.39	25143272.0
2014-02-04 16:00:00	SPY	ETF	175.37	175.4353	174.1055	175.04	5730365.0
2014-02-04 16:30:00	SPY	ETF	175.02	175.385	174.1055	174.94	2893496.0
2014-02-04 17:00:00	SPY	ETF	174.94	174.94	174.68	174.91	1850038.0
2014-02-04 17:30:00	SPY	ETF	174.86	174.93	174.8	174.92	33815.0
2014-02-04 18:00:00	SPY	ETF	174.94	175.05	174.94	175.0	52819.0
2014-02-04 18:30:00	SPY	ETF	175.01	175.08	175.01	175.07	70193.0
2014-02-04 19:00:00	SPY	ETF	175.05	175.05	174.78	174.89	76706.0
2014-02-04 19:30:00	SPY	ETF	174.9	174.96	174.8	174.96	62790.0
2014-02-04 04:30:00	QQQ	ETF	84.53	84.53	84.53	84.53	100.0
2014-02-04 05:00:00	QQQ	ETF	84.44	84.44	84.44	84.44	4000.0
2014-02-04 05:30:00	QQQ	ETF	84.39	84.39	84.39	84.39	4000.0
2014-02-04 06:00:00	QQQ	ETF	84.3	84.3	84.3	84.3	400.0
2014-02-04 06:30:00	QQQ	ETF	84.37	84.38	84.33	84.36	1500.0
2014-02-04 07:00:00	QQQ	ETF	84.38	84.48	84.36	84.48	1100.0
2014-02-04 07:30:00	QQQ	ETF	84.46	84.46	84.36	84.44	16700.0
2014-02-04 08:00:00	QQQ	ETF	84.43	84.65	84.42	84.64	76803.0
2014-02-04 08:30:00	QQQ	ETF	84.63	84.74	84.56	84.73	253719.0
2014-02-04 09:00:00	QQQ	ETF	84.73	84.77	84.66	84.71	529256.0
2014-02-04 09:30:00	QQQ	ETF	84.7	84.91	84.46	84.86	5811706.0
2014-02-04 10:00:00	QQQ	ETF	84.86	84.94	84.6	84.66	4438726.0
2014-02-04 10:30:00	QQQ	ETF	84.66	84.8699	84.54	84.62	2568043.0
2014-02-04 11:00:00	QQQ	ETF	84.63	84.97	84.58	84.92	2316987.0
2014-02-04 11:30:00	QQQ	ETF	84.93	85.18	84.87	85.17	1818028.0
2014-02-04 12:00:00	QQQ	ETF	85.16	85.2	85.01	85.06	1564080.0
2014-02-04 12:30:00	QQQ	ETF	85.07	85.2	85.03	85.16	1124869.0
2014-02-04 13:00:00	QQQ	ETF	85.16	85.25	85.02	85.1499	1495104.0

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

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