PREVIEW / etf_30min / 2013-07-12

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-07-12.parquet
  size:    312 KB
  rows:    10,715

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-07-12 04:00:00	SPY	ETF	167.42	167.42	167.21	167.39	129600.0
2013-07-12 04:30:00	SPY	ETF	167.34	167.34	167.26	167.31	48800.0
2013-07-12 05:00:00	SPY	ETF	167.31	167.33	167.26	167.27	26000.0
2013-07-12 05:30:00	SPY	ETF	167.29	167.51	167.29	167.51	7200.0
2013-07-12 06:00:00	SPY	ETF	167.52	167.62	167.52	167.62	28700.0
2013-07-12 06:30:00	SPY	ETF	167.61	167.65	167.51	167.61	15600.0
2013-07-12 07:00:00	SPY	ETF	167.66	167.67	167.39	167.51	235386.0
2013-07-12 07:30:00	SPY	ETF	167.54	167.62	167.54	167.61	207444.0
2013-07-12 08:00:00	SPY	ETF	167.6	167.62	167.41	167.49	222551.0
2013-07-12 08:30:00	SPY	ETF	167.5	167.5	167.29	167.34	1094996.0
2013-07-12 09:00:00	SPY	ETF	167.35	167.51	167.16	167.4	858118.0
2013-07-12 09:30:00	SPY	ETF	167.39	167.54	167.2	167.38	13014196.0
2013-07-12 10:00:00	SPY	ETF	167.38	167.56	167.21	167.47	8903911.0
2013-07-12 10:30:00	SPY	ETF	167.475	167.69	167.4	167.43	6457854.0
2013-07-12 11:00:00	SPY	ETF	167.4393	167.5	167.31	167.33	4002009.0
2013-07-12 11:30:00	SPY	ETF	167.34	167.41	167.15	167.2	6309957.0
2013-07-12 12:00:00	SPY	ETF	167.2	167.26	167.14	167.22	3290158.0
2013-07-12 12:30:00	SPY	ETF	167.21	167.33	167.13	167.3	3335533.0
2013-07-12 13:00:00	SPY	ETF	167.3	167.41	167.14	167.3599	5544852.0
2013-07-12 13:30:00	SPY	ETF	167.36	167.48	167.29	167.4	3279047.0
2013-07-12 14:00:00	SPY	ETF	167.4	167.46	167.24	167.34	3217534.0
2013-07-12 14:30:00	SPY	ETF	167.35	167.43	167.25	167.42	2929865.0
2013-07-12 15:00:00	SPY	ETF	167.42	167.46	167.28	167.45	3920029.0
2013-07-12 15:30:00	SPY	ETF	167.45	167.85	167.41	167.7	17904944.0
2013-07-12 16:00:00	SPY	ETF	167.7	167.9276	167.2969	167.5	8590413.0
2013-07-12 16:30:00	SPY	ETF	167.5	167.52	167.375	167.49	991237.0
2013-07-12 17:00:00	SPY	ETF	167.49	167.55	167.45	167.5	299964.0
2013-07-12 17:30:00	SPY	ETF	167.49	167.52	167.48	167.52	4200.0
2013-07-12 18:00:00	SPY	ETF	167.5	167.53	167.4106	167.53	1553175.0
2013-07-12 18:30:00	SPY	ETF	167.51	167.54	167.47	167.47	4275.0
2013-07-12 19:00:00	SPY	ETF	167.48	167.52	167.46	167.5	3800.0
2013-07-12 19:30:00	SPY	ETF	167.5	167.51	167.48	167.49	13326.0
2013-07-12 04:00:00	QQQ	ETF	74.94	74.97	74.94	74.97	1416.0
2013-07-12 04:30:00	QQQ	ETF	74.95	74.95	74.93	74.95	2800.0
2013-07-12 05:00:00	QQQ	ETF	74.93	74.95	74.93	74.93	1800.0
2013-07-12 05:30:00	QQQ	ETF	74.95	75.0	74.95	75.0	1800.0
2013-07-12 06:00:00	QQQ	ETF	75.03	75.06	75.03	75.06	1900.0
2013-07-12 06:30:00	QQQ	ETF	75.09	75.1	75.06	75.06	3630.0
2013-07-12 07:00:00	QQQ	ETF	75.09	75.1	75.04	75.08	21409.0
2013-07-12 07:30:00	QQQ	ETF	75.09	75.11	75.06	75.08	6637.0
2013-07-12 08:00:00	QQQ	ETF	75.09	75.12	75.03	75.05	41522.0
2013-07-12 08:30:00	QQQ	ETF	75.03	75.03	74.94	75.0	40393.0
2013-07-12 09:00:00	QQQ	ETF	75.02	75.03	74.92	75.03	231805.0
2013-07-12 09:30:00	QQQ	ETF	75.02	75.11	74.94	75.0	4274560.0
2013-07-12 10:00:00	QQQ	ETF	75.01	75.15	74.961	75.1	2904177.0
2013-07-12 10:30:00	QQQ	ETF	75.1	75.14	74.98	75.0	1730997.0
2013-07-12 11:00:00	QQQ	ETF	75.0	75.03	74.92	74.92	985632.0
2013-07-12 11:30:00	QQQ	ETF	74.92	74.94	74.83	74.8801	1660418.0
2013-07-12 12:00:00	QQQ	ETF	74.88	74.91	74.859	74.871	1190739.0
2013-07-12 12:30:00	QQQ	ETF	74.88	74.93	74.82	74.9	907661.0

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

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