PREVIEW / etf_30min / 2013-04-29

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-29.parquet
  size:    307 KB
  rows:    10,517

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
2013-04-29 04:00:00	SPY	ETF	158.44	158.65	158.44	158.65	8359.0
2013-04-29 04:30:00	SPY	ETF	158.6	158.62	158.56	158.56	24300.0
2013-04-29 05:00:00	SPY	ETF	158.6	158.6	158.54	158.54	2900.0
2013-04-29 05:30:00	SPY	ETF	158.52	158.52	158.45	158.5	4300.0
2013-04-29 06:00:00	SPY	ETF	158.47	158.54	158.46	158.54	7600.0
2013-04-29 06:30:00	SPY	ETF	158.53	158.56	158.51	158.51	50983.0
2013-04-29 07:00:00	SPY	ETF	158.53	158.63	158.47	158.61	82060.0
2013-04-29 07:30:00	SPY	ETF	158.59	158.71	158.59	158.65	142928.0
2013-04-29 08:00:00	SPY	ETF	158.65	158.77	158.53	158.66	221674.0
2013-04-29 08:30:00	SPY	ETF	158.65	158.72	158.57	158.59	330219.0
2013-04-29 09:00:00	SPY	ETF	158.59	158.77	158.58	158.66	323987.0
2013-04-29 09:30:00	SPY	ETF	158.67	158.83	158.42	158.69	8506500.0
2013-04-29 10:00:00	SPY	ETF	158.7	159.16	158.63	159.09	9259529.0
2013-04-29 10:30:00	SPY	ETF	159.0899	159.21	159.01	159.15	6667245.0
2013-04-29 11:00:00	SPY	ETF	159.14	159.17	159.01	159.12	4597594.0
2013-04-29 11:30:00	SPY	ETF	159.125	159.18	159.02	159.169	4612451.0
2013-04-29 12:00:00	SPY	ETF	159.16	159.45	159.13	159.4	6354179.0
2013-04-29 12:30:00	SPY	ETF	159.405	159.54	159.35	159.375	4968053.0
2013-04-29 13:00:00	SPY	ETF	159.362	159.4	159.33	159.381	2833116.0
2013-04-29 13:30:00	SPY	ETF	159.3806	159.63	159.37	159.575	3564231.0
2013-04-29 14:00:00	SPY	ETF	159.575	159.65	159.5	159.58	3726185.0
2013-04-29 14:30:00	SPY	ETF	159.59	159.6	159.53	159.56	4230739.0
2013-04-29 15:00:00	SPY	ETF	159.561	159.58	159.245	159.37	6611884.0
2013-04-29 15:30:00	SPY	ETF	159.37	159.52	159.18	159.33	13659546.0
2013-04-29 16:00:00	SPY	ETF	159.29	159.3569	158.9779	159.32	2877921.0
2013-04-29 16:30:00	SPY	ETF	159.31	159.38	158.2111	159.38	2928009.0
2013-04-29 17:00:00	SPY	ETF	159.36	159.38	159.33	159.38	79375.0
2013-04-29 17:30:00	SPY	ETF	159.35	159.35	159.32	159.32	24257.0
2013-04-29 18:00:00	SPY	ETF	159.32	159.34	159.24	159.25	52560.0
2013-04-29 18:30:00	SPY	ETF	159.26	159.26	159.23	159.24	11801.0
2013-04-29 19:00:00	SPY	ETF	159.23	159.23	159.19	159.19	12834.0
2013-04-29 19:30:00	SPY	ETF	159.23	159.24	159.18	159.2	19803.0
2013-04-29 04:00:00	QQQ	ETF	69.73	69.73	69.73	69.73	100.0
2013-04-29 05:30:00	QQQ	ETF	69.68	69.68	69.68	69.68	1600.0
2013-04-29 06:00:00	QQQ	ETF	69.73	69.73	69.73	69.73	200.0
2013-04-29 06:30:00	QQQ	ETF	69.7	69.74	69.7	69.74	900.0
2013-04-29 07:00:00	QQQ	ETF	69.72	69.72	69.71	69.72	4599.0
2013-04-29 07:30:00	QQQ	ETF	69.77	69.77	69.74	69.74	151800.0
2013-04-29 08:00:00	QQQ	ETF	69.73	69.79	69.72	69.78	80730.0
2013-04-29 08:30:00	QQQ	ETF	69.78	69.8	69.73	69.73	53280.0
2013-04-29 09:00:00	QQQ	ETF	69.72	69.81	69.72	69.77	214351.0
2013-04-29 09:30:00	QQQ	ETF	69.78	70.06	69.76	69.98	3009660.0
2013-04-29 10:00:00	QQQ	ETF	69.99	70.34	69.95	70.2769	3219181.0
2013-04-29 10:30:00	QQQ	ETF	70.28	70.34	70.24	70.24	1663674.0
2013-04-29 11:00:00	QQQ	ETF	70.25	70.27	70.19	70.22	1471106.0
2013-04-29 11:30:00	QQQ	ETF	70.21	70.28	70.19	70.28	733824.0
2013-04-29 12:00:00	QQQ	ETF	70.284	70.41	70.26	70.38	1667156.0
2013-04-29 12:30:00	QQQ	ETF	70.3899	70.48	70.36	70.37	1266688.0
2013-04-29 13:00:00	QQQ	ETF	70.36	70.41	70.335	70.37	712911.0
2013-04-29 13:30:00	QQQ	ETF	70.36	70.45	70.341	70.39	765895.0

> showing 50 of 10,517 rows — these rows as CSV

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