PREVIEW / etf_30min / 2014-12-09

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-09.parquet
  size:    381 KB
  rows:    12,742

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-12-09 04:00:00	SPY	ETF	206.05	206.05	205.8	206.04	27173.0
2014-12-09 04:30:00	SPY	ETF	206.04	206.04	205.77	205.77	12275.0
2014-12-09 05:00:00	SPY	ETF	205.89	206.05	205.89	205.96	7939.0
2014-12-09 05:30:00	SPY	ETF	205.97	205.97	205.75	205.83	10340.0
2014-12-09 06:00:00	SPY	ETF	205.88	205.9	205.79	205.79	26426.0
2014-12-09 06:30:00	SPY	ETF	205.79	205.86	205.69	205.85	116339.0
2014-12-09 07:00:00	SPY	ETF	205.75	205.83	205.55	205.55	90470.0
2014-12-09 07:30:00	SPY	ETF	205.53	205.61	204.8	205.03	862121.0
2014-12-09 08:00:00	SPY	ETF	205.04	205.83	204.4	204.47	981319.0
2014-12-09 08:30:00	SPY	ETF	204.47	204.86	204.44	204.78	1325320.0
2014-12-09 09:00:00	SPY	ETF	204.79	204.83	204.33	204.37	1129989.0
2014-12-09 09:30:00	SPY	ETF	204.37	205.05	204.1	205.04	18946062.0
2014-12-09 10:00:00	SPY	ETF	205.04	205.18	204.13	204.2157	11859883.0
2014-12-09 10:30:00	SPY	ETF	204.21	204.9	203.91	204.68	14784030.0
2014-12-09 11:00:00	SPY	ETF	204.685	205.12	204.45	205.01	7230860.0
2014-12-09 11:30:00	SPY	ETF	205.01	205.1	204.64	204.86	5002918.0
2014-12-09 12:00:00	SPY	ETF	204.86	205.04	204.665	205.0	4143313.0
2014-12-09 12:30:00	SPY	ETF	205.009	205.63	204.94	205.63	7152086.0
2014-12-09 13:00:00	SPY	ETF	205.62	206.06	205.46	205.88	5776115.0
2014-12-09 13:30:00	SPY	ETF	205.89	206.32	205.86	205.99	6423735.0
2014-12-09 14:00:00	SPY	ETF	205.99	206.23	205.87	206.12	3955404.0
2014-12-09 14:30:00	SPY	ETF	206.1157	206.13	205.66	205.9899	5614767.0
2014-12-09 15:00:00	SPY	ETF	205.98	206.27	205.95	206.1	5154421.0
2014-12-09 15:30:00	SPY	ETF	206.11	206.6	206.01	206.46	16653487.0
2014-12-09 16:00:00	SPY	ETF	206.47	206.49	205.0	206.3	4381552.0
2014-12-09 16:30:00	SPY	ETF	206.3	206.38	206.3	206.37	334817.0
2014-12-09 17:00:00	SPY	ETF	206.36	206.36	206.3	206.33	51267.0
2014-12-09 17:30:00	SPY	ETF	206.32	206.47	206.31	206.32	13084.0
2014-12-09 18:00:00	SPY	ETF	206.35	206.38	206.32	206.32	39086.0
2014-12-09 18:30:00	SPY	ETF	206.33	206.51	206.32	206.36	12987.0
2014-12-09 19:00:00	SPY	ETF	206.37	206.4	206.35	206.35	19651.0
2014-12-09 19:30:00	SPY	ETF	206.36	206.36	206.31	206.34	53619.0
2014-12-09 04:00:00	QQQ	ETF	104.2	104.2	104.2	104.2	484.0
2014-12-09 04:30:00	QQQ	ETF	104.22	104.3	104.19	104.19	3493.0
2014-12-09 05:00:00	QQQ	ETF	104.14	104.3	104.14	104.23	2838.0
2014-12-09 05:30:00	QQQ	ETF	104.16	104.16	104.16	104.16	300.0
2014-12-09 06:00:00	QQQ	ETF	104.2	104.2	104.18	104.18	12669.0
2014-12-09 06:30:00	QQQ	ETF	104.16	104.2	104.12	104.2	2919.0
2014-12-09 07:00:00	QQQ	ETF	104.17	104.18	104.05	104.05	11760.0
2014-12-09 07:30:00	QQQ	ETF	104.02	104.05	103.67	103.79	177183.0
2014-12-09 08:00:00	QQQ	ETF	103.79	104.01	103.49	103.5	293738.0
2014-12-09 08:30:00	QQQ	ETF	103.51	103.67	103.44	103.63	313962.0
2014-12-09 09:00:00	QQQ	ETF	103.64	104.63	103.39	103.4	584348.0
2014-12-09 09:30:00	QQQ	ETF	103.41	103.68	103.145	103.64	7675684.0
2014-12-09 10:00:00	QQQ	ETF	103.641	103.73	103.1899	103.25	5161812.0
2014-12-09 10:30:00	QQQ	ETF	103.25	103.68	103.0401	103.58	3334313.0
2014-12-09 11:00:00	QQQ	ETF	103.58	104.03	103.45	103.961	2943431.0
2014-12-09 11:30:00	QQQ	ETF	103.98	104.02	103.79	103.91	1822811.0
2014-12-09 12:00:00	QQQ	ETF	103.915	104.0698	103.81	104.06	1428544.0
2014-12-09 12:30:00	QQQ	ETF	104.06	104.48	104.01	104.48	1966808.0

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

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