PREVIEW / etf_30min / 2014-03-21

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-21.parquet
  size:    338 KB
  rows:    11,309

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-21 04:00:00	SPY	ETF	187.3	187.56	187.27	187.42	17242.0
2014-03-21 04:30:00	SPY	ETF	187.43	187.8	187.43	187.64	54530.0
2014-03-21 05:00:00	SPY	ETF	187.62	187.63	187.47	187.48	20963.0
2014-03-21 05:30:00	SPY	ETF	187.54	187.61	187.48	187.61	6891.0
2014-03-21 06:00:00	SPY	ETF	187.6	187.65	187.56	187.56	46232.0
2014-03-21 06:30:00	SPY	ETF	187.6	187.62	187.46	187.53	37408.0
2014-03-21 07:00:00	SPY	ETF	187.53	187.62	187.46	187.62	117942.0
2014-03-21 07:30:00	SPY	ETF	187.59	187.62	187.48	187.48	70985.0
2014-03-21 08:00:00	SPY	ETF	187.5	187.62	187.38	187.46	149456.0
2014-03-21 08:30:00	SPY	ETF	187.46	187.58	187.36	187.58	596439.0
2014-03-21 09:00:00	SPY	ETF	187.58	187.84	187.46	187.72	3237151.0
2014-03-21 09:30:00	SPY	ETF	187.72	189.0239	187.67	187.71	32521768.0
2014-03-21 10:00:00	SPY	ETF	187.71	187.82	187.29	187.425	15864642.0
2014-03-21 10:30:00	SPY	ETF	187.42	187.825	187.29	187.77	7032045.0
2014-03-21 11:00:00	SPY	ETF	187.775	187.92	187.65	187.9	6468374.0
2014-03-21 11:30:00	SPY	ETF	187.91	188.025	187.7	187.76	5121026.0
2014-03-21 12:00:00	SPY	ETF	187.76	187.88	187.68	187.693	5012320.0
2014-03-21 12:30:00	SPY	ETF	187.69	187.7	187.43	187.47	3699161.0
2014-03-21 13:00:00	SPY	ETF	187.468	187.51	186.86	186.95	7034404.0
2014-03-21 13:30:00	SPY	ETF	186.95	187.065	186.72	186.81	6976840.0
2014-03-21 14:00:00	SPY	ETF	186.81	186.97	186.37	186.39	8260365.0
2014-03-21 14:30:00	SPY	ETF	186.4	186.75	186.17	186.6499	9022124.0
2014-03-21 15:00:00	SPY	ETF	186.65	186.695	186.24	186.67	8005420.0
2014-03-21 15:30:00	SPY	ETF	186.67	186.67	186.03	186.21	19996431.0
2014-03-21 16:00:00	SPY	ETF	186.2	187.8	186.1	186.2	10297037.0
2014-03-21 16:30:00	SPY	ETF	186.2	186.8876	186.16	186.34	3673231.0
2014-03-21 17:00:00	SPY	ETF	186.33	187.6862	186.18	186.18	2853721.0
2014-03-21 17:30:00	SPY	ETF	186.19	186.2	186.09	186.11	1674178.0
2014-03-21 18:00:00	SPY	ETF	186.11	186.12	186.08	186.08	46618.0
2014-03-21 18:30:00	SPY	ETF	186.07	186.14	186.07	186.13	3324.0
2014-03-21 19:00:00	SPY	ETF	186.13	186.15	186.13	186.14	2055.0
2014-03-21 19:30:00	SPY	ETF	186.15	186.16	186.1	186.13	11429.0
2014-03-21 04:00:00	QQQ	ETF	90.36	90.36	90.36	90.36	1000.0
2014-03-21 04:30:00	QQQ	ETF	90.52	90.55	90.52	90.55	1200.0
2014-03-21 05:30:00	QQQ	ETF	90.46	90.51	90.46	90.51	12600.0
2014-03-21 06:00:00	QQQ	ETF	90.5	90.52	90.5	90.52	3000.0
2014-03-21 06:30:00	QQQ	ETF	90.5	90.5	90.42	90.44	6600.0
2014-03-21 07:00:00	QQQ	ETF	90.42	90.5	90.42	90.5	4700.0
2014-03-21 07:30:00	QQQ	ETF	90.49	90.52	90.44	90.44	8100.0
2014-03-21 08:00:00	QQQ	ETF	90.5	90.5	90.42	90.48	20670.0
2014-03-21 08:30:00	QQQ	ETF	90.47	90.49	90.42	90.46	29330.0
2014-03-21 09:00:00	QQQ	ETF	90.45	90.73	90.29	90.6	1447215.0
2014-03-21 09:30:00	QQQ	ETF	90.61	90.65	89.89	89.89	9554580.0
2014-03-21 10:00:00	QQQ	ETF	89.9	89.9899	89.4	89.48	7893277.0
2014-03-21 10:30:00	QQQ	ETF	89.48	89.84	89.381	89.77	3752505.0
2014-03-21 11:00:00	QQQ	ETF	89.77	89.825	89.62	89.81	2414119.0
2014-03-21 11:30:00	QQQ	ETF	89.805	89.93	89.75	89.81	1636628.0
2014-03-21 12:00:00	QQQ	ETF	89.81	89.93	89.77	89.86	1478546.0
2014-03-21 12:30:00	QQQ	ETF	89.86	89.86	89.68	89.69	899134.0
2014-03-21 13:00:00	QQQ	ETF	89.69	89.6985	89.38	89.43	2956239.0

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

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