PREVIEW / etf_30min / 2012-02-17

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-17.parquet
  size:    280 KB
  rows:    9,338

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-02-17 04:00:00	SPY	ETF	135.95	135.95	135.84	135.87	7160.0
2012-02-17 04:30:00	SPY	ETF	135.84	136.05	135.84	136.04	510.0
2012-02-17 05:00:00	SPY	ETF	135.99	136.04	135.94	136.03	29343.0
2012-02-17 05:30:00	SPY	ETF	136.0	136.01	135.94	135.96	13065.0
2012-02-17 06:00:00	SPY	ETF	135.96	136.01	135.89	136.01	5500.0
2012-02-17 06:30:00	SPY	ETF	136.02	136.06	135.93	136.06	17500.0
2012-02-17 07:00:00	SPY	ETF	136.02	136.34	136.02	136.27	220345.0
2012-02-17 07:30:00	SPY	ETF	136.25	136.3	136.12	136.19	136225.0
2012-02-17 08:00:00	SPY	ETF	136.2	136.23	136.08	136.17	246271.0
2012-02-17 08:30:00	SPY	ETF	136.18	136.25	136.1	136.15	976276.0
2012-02-17 09:00:00	SPY	ETF	136.15	136.53	136.14	136.52	2532435.0
2012-02-17 09:30:00	SPY	ETF	136.52	136.57	136.26	136.42	21177874.0
2012-02-17 10:00:00	SPY	ETF	136.42	136.6275	136.15	136.29	14362020.0
2012-02-17 10:30:00	SPY	ETF	136.28	136.35	136.11	136.19	9087804.0
2012-02-17 11:00:00	SPY	ETF	136.18	136.18	135.96	136.09	11729757.0
2012-02-17 11:30:00	SPY	ETF	136.1	136.22	136.05	136.1301	5806326.0
2012-02-17 12:00:00	SPY	ETF	136.14	136.17	136.05	136.12	2976023.0
2012-02-17 12:30:00	SPY	ETF	136.1246	136.19	136.1	136.1499	3429141.0
2012-02-17 13:00:00	SPY	ETF	136.1499	136.29	136.12	136.2501	3995408.0
2012-02-17 13:30:00	SPY	ETF	136.25	136.32	136.25	136.29	3470466.0
2012-02-17 14:00:00	SPY	ETF	136.29	136.34	136.27	136.34	3277204.0
2012-02-17 14:30:00	SPY	ETF	136.34	136.4	136.31	136.35	4529299.0
2012-02-17 15:00:00	SPY	ETF	136.36	136.54	136.31	136.51	8504255.0
2012-02-17 15:30:00	SPY	ETF	136.52	136.54	136.33	136.4	19400699.0
2012-02-17 16:00:00	SPY	ETF	136.41	136.52	136.0527	136.47	9577964.0
2012-02-17 16:30:00	SPY	ETF	136.47	136.51	136.0528	136.5	2499018.0
2012-02-17 17:00:00	SPY	ETF	136.5	136.52	136.39	136.39	216305.0
2012-02-17 17:30:00	SPY	ETF	136.4	136.6	136.4	136.59	405183.0
2012-02-17 18:00:00	SPY	ETF	136.59	136.77	136.57	136.77	358355.0
2012-02-17 18:30:00	SPY	ETF	136.77	136.83	136.72	136.83	357805.0
2012-02-17 19:00:00	SPY	ETF	136.79	136.8	136.72	136.78	43302.0
2012-02-17 19:30:00	SPY	ETF	136.78	136.8	136.71	136.75	34876.0
2012-02-17 07:00:00	QQQ	ETF	63.69	63.78	63.69	63.77	6075.0
2012-02-17 07:30:00	QQQ	ETF	63.73	63.73	63.65	63.69	52694.0
2012-02-17 08:00:00	QQQ	ETF	63.68	63.7	63.65	63.69	50647.0
2012-02-17 08:30:00	QQQ	ETF	63.69	63.7	63.62	63.64	41003.0
2012-02-17 09:00:00	QQQ	ETF	63.64	63.7	63.56	63.64	651802.0
2012-02-17 09:30:00	QQQ	ETF	63.64	63.69	63.43	63.55	7775781.0
2012-02-17 10:00:00	QQQ	ETF	63.55	63.56	63.45	63.5	3524763.0
2012-02-17 10:30:00	QQQ	ETF	63.5	63.55	63.4	63.41	2423446.0
2012-02-17 11:00:00	QQQ	ETF	63.41	63.41	63.15	63.27	7071155.0
2012-02-17 11:30:00	QQQ	ETF	63.27	63.36	63.25	63.336	1865031.0
2012-02-17 12:00:00	QQQ	ETF	63.34	63.36	63.27	63.306	900299.0
2012-02-17 12:30:00	QQQ	ETF	63.309	63.36	63.3	63.321	1091041.0
2012-02-17 13:00:00	QQQ	ETF	63.3201	63.38	63.3	63.3701	716266.0
2012-02-17 13:30:00	QQQ	ETF	63.38	63.42	63.36	63.4	1499578.0
2012-02-17 14:00:00	QQQ	ETF	63.3901	63.43	63.3698	63.425	1161194.0
2012-02-17 14:30:00	QQQ	ETF	63.43	63.46	63.41	63.43	1476987.0
2012-02-17 15:00:00	QQQ	ETF	63.44	63.53	63.4	63.53	2337467.0
2012-02-17 15:30:00	QQQ	ETF	63.525	63.53	63.4	63.43	5579726.0

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

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