PREVIEW / etf_30min / 2012-09-26

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-09-26.parquet
  size:    295 KB
  rows:    9,955

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-09-26 05:00:00	SPY	ETF	144.31	144.38	144.31	144.38	600.0
2012-09-26 05:30:00	SPY	ETF	144.43	144.43	144.3	144.3	1000.0
2012-09-26 06:00:00	SPY	ETF	144.17	144.29	144.17	144.17	5150.0
2012-09-26 06:30:00	SPY	ETF	144.15	144.21	144.15	144.17	2250.0
2012-09-26 07:00:00	SPY	ETF	144.2	144.23	144.11	144.11	65560.0
2012-09-26 07:30:00	SPY	ETF	144.1	144.12	143.93	144.12	485782.0
2012-09-26 08:00:00	SPY	ETF	144.11	144.13	143.8	143.91	843454.0
2012-09-26 08:30:00	SPY	ETF	143.92	144.06	143.8	144.01	363234.0
2012-09-26 09:00:00	SPY	ETF	144.01	144.19	143.97	144.06	765885.0
2012-09-26 09:30:00	SPY	ETF	144.065	144.11	143.56	143.76	17511895.0
2012-09-26 10:00:00	SPY	ETF	143.7601	143.83	143.28	143.28	10713763.0
2012-09-26 10:30:00	SPY	ETF	143.3	143.4	142.95	143.065	17825265.0
2012-09-26 11:00:00	SPY	ETF	143.06	143.54	143.05	143.49	15704092.0
2012-09-26 11:30:00	SPY	ETF	143.49	144.0839	143.28	143.45	9577994.0
2012-09-26 12:00:00	SPY	ETF	143.445	143.75	143.44	143.53	7261876.0
2012-09-26 12:30:00	SPY	ETF	143.52	143.735	143.36	143.68	5323838.0
2012-09-26 13:00:00	SPY	ETF	143.68	143.8701	143.59	143.809	5144222.0
2012-09-26 13:30:00	SPY	ETF	143.81	144.0839	143.42	143.43	6074533.0
2012-09-26 14:00:00	SPY	ETF	143.42	143.78	143.41	143.6055	6290052.0
2012-09-26 14:30:00	SPY	ETF	143.6	143.65	143.41	143.54	5367991.0
2012-09-26 15:00:00	SPY	ETF	143.55	143.59	143.31	143.37	8063794.0
2012-09-26 15:30:00	SPY	ETF	143.36	143.43	143.19	143.33	14471128.0
2012-09-26 16:00:00	SPY	ETF	143.32	144.1102	143.2	143.29	7049163.0
2012-09-26 16:30:00	SPY	ETF	143.29	143.49	143.29	143.43	5268758.0
2012-09-26 17:00:00	SPY	ETF	143.47	143.51	143.44	143.5	920037.0
2012-09-26 17:30:00	SPY	ETF	143.5	143.51	143.46	143.51	32198.0
2012-09-26 18:00:00	SPY	ETF	143.51	143.58	143.5	143.55	71886.0
2012-09-26 18:30:00	SPY	ETF	143.57	143.57	143.48	143.5	8712.0
2012-09-26 19:00:00	SPY	ETF	143.52	143.57	143.5	143.53	30608.0
2012-09-26 19:30:00	SPY	ETF	143.56	143.61	143.45	143.48	108726.0
2012-09-26 04:00:00	QQQ	ETF	68.71	68.71	68.71	68.71	100.0
2012-09-26 04:30:00	QQQ	ETF	68.74	68.74	68.74	68.74	100.0
2012-09-26 06:00:00	QQQ	ETF	68.74	68.8	68.74	68.8	2100.0
2012-09-26 06:30:00	QQQ	ETF	68.77	68.78	68.77	68.78	5100.0
2012-09-26 07:00:00	QQQ	ETF	68.78	68.78	68.73	68.73	8600.0
2012-09-26 07:30:00	QQQ	ETF	68.67	68.69	68.62	68.68	126300.0
2012-09-26 08:00:00	QQQ	ETF	68.7	68.73	68.59	68.61	164200.0
2012-09-26 08:30:00	QQQ	ETF	68.61	68.68	68.57	68.67	59842.0
2012-09-26 09:00:00	QQQ	ETF	68.67	68.7	68.65	68.66	104502.0
2012-09-26 09:30:00	QQQ	ETF	68.67	68.71	68.37	68.44	4156570.0
2012-09-26 10:00:00	QQQ	ETF	68.44	68.47	68.03	68.03	3573997.0
2012-09-26 10:30:00	QQQ	ETF	68.04	68.12	67.85	67.9208	4810005.0
2012-09-26 11:00:00	QQQ	ETF	67.92	68.17	67.92	68.15	2802554.0
2012-09-26 11:30:00	QQQ	ETF	68.15	68.2088	68.03	68.15	1718672.0
2012-09-26 12:00:00	QQQ	ETF	68.14	68.29	68.13	68.18	1609365.0
2012-09-26 12:30:00	QQQ	ETF	68.18	68.24	68.06	68.21	1634239.0
2012-09-26 13:00:00	QQQ	ETF	68.21	68.4	68.15	68.37	1575470.0
2012-09-26 13:30:00	QQQ	ETF	68.37	68.4	68.15	68.1595	1570424.0
2012-09-26 14:00:00	QQQ	ETF	68.16	68.47	68.15	68.38	1873972.0
2012-09-26 14:30:00	QQQ	ETF	68.39	68.42	68.24	68.32	1492832.0

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

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