PREVIEW / etf_30min / 2014-03-19

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-19.parquet
  size:    335 KB
  rows:    11,327

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-19 04:00:00	SPY	ETF	187.75	187.75	187.58	187.62	1200.0
2014-03-19 04:30:00	SPY	ETF	187.64	187.7	187.55	187.7	12400.0
2014-03-19 05:00:00	SPY	ETF	187.66	187.92	187.66	187.75	8378.0
2014-03-19 05:30:00	SPY	ETF	187.74	187.74	187.69	187.69	1532.0
2014-03-19 06:00:00	SPY	ETF	187.7	187.82	187.68	187.75	12108.0
2014-03-19 06:30:00	SPY	ETF	187.74	187.82	187.72	187.75	10256.0
2014-03-19 07:00:00	SPY	ETF	187.71	187.82	187.71	187.72	56171.0
2014-03-19 07:30:00	SPY	ETF	187.7	187.9	187.67	187.87	119579.0
2014-03-19 08:00:00	SPY	ETF	187.87	187.93	187.75	187.85	250988.0
2014-03-19 08:30:00	SPY	ETF	187.85	187.94	187.79	187.82	303927.0
2014-03-19 09:00:00	SPY	ETF	187.82	187.83	187.68	187.71	477293.0
2014-03-19 09:30:00	SPY	ETF	187.7	187.9	187.44	187.84	9595376.0
2014-03-19 10:00:00	SPY	ETF	187.85	187.94	187.71	187.84	5648900.0
2014-03-19 10:30:00	SPY	ETF	187.845	187.86	187.63	187.72	3671110.0
2014-03-19 11:00:00	SPY	ETF	187.73	187.83	187.68	187.72	2303599.0
2014-03-19 11:30:00	SPY	ETF	187.73	187.73	187.55	187.63	2244175.0
2014-03-19 12:00:00	SPY	ETF	187.62	187.79	187.59	187.65	10590619.0
2014-03-19 12:30:00	SPY	ETF	187.659	187.8	187.545	187.791	3136443.0
2014-03-19 13:00:00	SPY	ETF	187.79	187.87	187.711	187.85	2922999.0
2014-03-19 13:30:00	SPY	ETF	187.86	187.89	187.74	187.86	5706949.0
2014-03-19 14:00:00	SPY	ETF	187.86	187.88	186.78	187.4	31207119.0
2014-03-19 14:30:00	SPY	ETF	187.4	187.58	186.95	187.27	14107968.0
2014-03-19 15:00:00	SPY	ETF	187.27	187.31	185.47	186.33	31243788.0
2014-03-19 15:30:00	SPY	ETF	186.33	186.94	186.23	186.68	24216010.0
2014-03-19 16:00:00	SPY	ETF	186.69	187.8054	186.45	186.52	6130527.0
2014-03-19 16:30:00	SPY	ETF	186.52	187.7332	186.24	186.66	12471085.0
2014-03-19 17:00:00	SPY	ETF	186.28	186.42	186.26	186.38	70685.0
2014-03-19 17:30:00	SPY	ETF	186.37	186.66	186.34	186.37	675733.0
2014-03-19 18:00:00	SPY	ETF	186.37	187.71	186.37	186.5	72092.0
2014-03-19 18:30:00	SPY	ETF	186.46	186.49	186.41	186.45	22620.0
2014-03-19 19:00:00	SPY	ETF	186.46	186.54	186.44	186.54	29919.0
2014-03-19 19:30:00	SPY	ETF	186.5	186.65	186.5	186.59	37680.0
2014-03-19 04:30:00	QQQ	ETF	90.62	90.62	90.62	90.62	300.0
2014-03-19 06:00:00	QQQ	ETF	90.65	90.65	90.61	90.61	15800.0
2014-03-19 06:30:00	QQQ	ETF	90.62	90.65	90.6	90.6	12600.0
2014-03-19 07:00:00	QQQ	ETF	90.65	90.65	90.65	90.65	6000.0
2014-03-19 07:30:00	QQQ	ETF	90.63	90.66	90.62	90.64	205450.0
2014-03-19 08:00:00	QQQ	ETF	90.65	90.66	90.58	90.621	33900.0
2014-03-19 08:30:00	QQQ	ETF	90.64	90.67	90.6	90.62	15903.0
2014-03-19 09:00:00	QQQ	ETF	90.6	90.62	90.53	90.56	132364.0
2014-03-19 09:30:00	QQQ	ETF	90.56	90.64	90.3	90.61	3224726.0
2014-03-19 10:00:00	QQQ	ETF	90.61	90.66	90.4295	90.5	2019339.0
2014-03-19 10:30:00	QQQ	ETF	90.51	90.51	90.23	90.4	2683453.0
2014-03-19 11:00:00	QQQ	ETF	90.39	90.53	90.39	90.45	847003.0
2014-03-19 11:30:00	QQQ	ETF	90.45	90.49	90.35	90.46	756745.0
2014-03-19 12:00:00	QQQ	ETF	90.465	90.58	90.45	90.48	720331.0
2014-03-19 12:30:00	QQQ	ETF	90.48	90.56	90.41	90.56	698335.0
2014-03-19 13:00:00	QQQ	ETF	90.55	90.61	90.53	90.579	438648.0
2014-03-19 13:30:00	QQQ	ETF	90.58	90.62	90.53	90.62	660324.0
2014-03-19 14:00:00	QQQ	ETF	90.6199	90.6199	90.121	90.35	6243541.0

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

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