PREVIEW / etf_30min / 2012-10-16

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-16.parquet
  size:    286 KB
  rows:    9,680

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
2012-10-16 04:00:00	SPY	ETF	144.25	144.25	144.18	144.18	600.0
2012-10-16 04:30:00	SPY	ETF	144.23	144.28	144.23	144.26	21400.0
2012-10-16 05:00:00	SPY	ETF	144.24	144.27	144.15	144.15	24100.0
2012-10-16 05:30:00	SPY	ETF	144.14	144.29	144.14	144.29	30700.0
2012-10-16 06:00:00	SPY	ETF	144.32	144.35	144.27	144.3	40600.0
2012-10-16 06:30:00	SPY	ETF	144.29	144.5	144.29	144.45	13119.0
2012-10-16 07:00:00	SPY	ETF	144.47	144.5	144.44	144.5	51420.0
2012-10-16 07:30:00	SPY	ETF	144.47	144.98	144.47	144.92	594946.0
2012-10-16 08:00:00	SPY	ETF	144.92	144.92	144.14	144.73	865761.0
2012-10-16 08:30:00	SPY	ETF	144.8	144.89	144.74	144.85	390930.0
2012-10-16 09:00:00	SPY	ETF	144.86	144.91	144.72	144.76	725110.0
2012-10-16 09:30:00	SPY	ETF	144.76	145.13	144.66	145.08	16074109.0
2012-10-16 10:00:00	SPY	ETF	145.08	145.2	145.015	145.13	10379295.0
2012-10-16 10:30:00	SPY	ETF	145.14	145.28	144.99	145.19	8843246.0
2012-10-16 11:00:00	SPY	ETF	145.19	145.42	145.1	145.41	5244192.0
2012-10-16 11:30:00	SPY	ETF	145.41	145.5	145.32	145.43	5409115.0
2012-10-16 12:00:00	SPY	ETF	145.43	145.64	145.38	145.47	8513906.0
2012-10-16 12:30:00	SPY	ETF	145.47	145.57	145.44	145.45	3583626.0
2012-10-16 13:00:00	SPY	ETF	145.46	145.57	145.44	145.535	2776604.0
2012-10-16 13:30:00	SPY	ETF	145.53	145.6	145.485	145.54	3962840.0
2012-10-16 14:00:00	SPY	ETF	145.541	145.55	145.27	145.36	6448244.0
2012-10-16 14:30:00	SPY	ETF	145.36	145.42	145.29	145.37	4686032.0
2012-10-16 15:00:00	SPY	ETF	145.37	145.41	145.19	145.34	6908578.0
2012-10-16 15:30:00	SPY	ETF	145.35	145.64	145.32	145.57	12872091.0
2012-10-16 16:00:00	SPY	ETF	145.57	145.71	145.0725	145.52	4890007.0
2012-10-16 16:30:00	SPY	ETF	145.51	145.68	144.0847	145.57	3055468.0
2012-10-16 17:00:00	SPY	ETF	145.55	145.73	145.54	145.65	165582.0
2012-10-16 17:30:00	SPY	ETF	145.65	145.66	145.55	145.6	155488.0
2012-10-16 18:00:00	SPY	ETF	145.62	145.7	145.58	145.65	59103.0
2012-10-16 18:30:00	SPY	ETF	145.65	145.65	145.57	145.6	4707.0
2012-10-16 19:00:00	SPY	ETF	145.64	145.7	145.61	145.7	10740.0
2012-10-16 19:30:00	SPY	ETF	145.71	145.79	145.65	145.66	160017.0
2012-10-16 04:00:00	QQQ	ETF	67.24	67.24	67.22	67.22	500.0
2012-10-16 06:30:00	QQQ	ETF	67.29	67.36	67.27	67.36	32700.0
2012-10-16 07:00:00	QQQ	ETF	67.32	67.35	67.32	67.34	2900.0
2012-10-16 07:30:00	QQQ	ETF	67.32	67.54	67.32	67.54	76835.0
2012-10-16 08:00:00	QQQ	ETF	67.51	67.53	67.47	67.51	56932.0
2012-10-16 08:30:00	QQQ	ETF	67.49	67.51	67.41	67.48	190113.0
2012-10-16 09:00:00	QQQ	ETF	67.49	67.49	67.27	67.28	303146.0
2012-10-16 09:30:00	QQQ	ETF	67.295	67.5	67.25	67.47	4280809.0
2012-10-16 10:00:00	QQQ	ETF	67.48	67.59	67.41	67.54	2193243.0
2012-10-16 10:30:00	QQQ	ETF	67.54	67.71	67.51	67.67	1845770.0
2012-10-16 11:00:00	QQQ	ETF	67.67	67.91	67.6	67.89	2426165.0
2012-10-16 11:30:00	QQQ	ETF	67.8908	67.99	67.88	67.95	2617661.0
2012-10-16 12:00:00	QQQ	ETF	67.95	68.19	67.92	68.06	4286270.0
2012-10-16 12:30:00	QQQ	ETF	68.06	68.1299	68.03	68.03	1131700.0
2012-10-16 13:00:00	QQQ	ETF	68.04	68.1	68.03	68.05	600243.0
2012-10-16 13:30:00	QQQ	ETF	68.0499	68.08	68.0	68.04	658223.0
2012-10-16 14:00:00	QQQ	ETF	68.04	68.0499	67.92	68.0	1022350.0
2012-10-16 14:30:00	QQQ	ETF	68.0	68.06	67.96	68.04	961451.0

> showing 50 of 9,680 rows — these rows as CSV

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