PREVIEW / etf_30min / 2014-03-17

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-17.parquet
  size:    329 KB
  rows:    11,266

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
2014-03-17 04:00:00	SPY	ETF	184.32	185.17	184.32	185.17	9825.0
2014-03-17 04:30:00	SPY	ETF	185.2	185.68	185.2	185.57	43950.0
2014-03-17 05:00:00	SPY	ETF	185.58	185.77	185.58	185.64	66270.0
2014-03-17 05:30:00	SPY	ETF	185.6	185.62	185.42	185.57	13040.0
2014-03-17 06:00:00	SPY	ETF	185.56	185.66	185.47	185.66	19543.0
2014-03-17 06:30:00	SPY	ETF	185.68	185.68	185.45	185.46	35077.0
2014-03-17 07:00:00	SPY	ETF	185.42	185.49	185.35	185.37	209843.0
2014-03-17 07:30:00	SPY	ETF	185.38	185.55	185.38	185.47	115349.0
2014-03-17 08:00:00	SPY	ETF	184.45	185.57	184.38	185.33	833048.0
2014-03-17 08:30:00	SPY	ETF	185.33	185.42	183.87	185.35	402934.0
2014-03-17 09:00:00	SPY	ETF	185.36	185.69	185.36	185.59	674659.0
2014-03-17 09:30:00	SPY	ETF	185.59	186.54	185.51	186.381	17599806.0
2014-03-17 10:00:00	SPY	ETF	186.38	186.77	186.27	186.32	12202695.0
2014-03-17 10:30:00	SPY	ETF	186.32	186.38	185.94	186.05	9467802.0
2014-03-17 11:00:00	SPY	ETF	186.05	186.34	185.9	185.96	6182851.0
2014-03-17 11:30:00	SPY	ETF	185.97	186.255	185.8	186.25	4556529.0
2014-03-17 12:00:00	SPY	ETF	186.26	186.58	186.14	186.5	4605512.0
2014-03-17 12:30:00	SPY	ETF	186.5	186.59	186.24	186.37	3969800.0
2014-03-17 13:00:00	SPY	ETF	186.378	186.47	186.155	186.22	3382179.0
2014-03-17 13:30:00	SPY	ETF	186.225	186.45	186.2	186.35	2576941.0
2014-03-17 14:00:00	SPY	ETF	186.3401	186.66	186.23	186.59	3725253.0
2014-03-17 14:30:00	SPY	ETF	186.59	186.6	186.34	186.48	2858352.0
2014-03-17 15:00:00	SPY	ETF	186.48	186.615	186.36	186.44	3578486.0
2014-03-17 15:30:00	SPY	ETF	186.45	186.5	186.13	186.34	12280388.0
2014-03-17 16:00:00	SPY	ETF	186.33	186.397	186.1814	186.37	6257068.0
2014-03-17 16:30:00	SPY	ETF	186.37	186.41	186.2724	186.41	587296.0
2014-03-17 17:00:00	SPY	ETF	186.4	186.47	186.35	186.46	112115.0
2014-03-17 17:30:00	SPY	ETF	186.46	186.5	186.33	186.43	335888.0
2014-03-17 18:00:00	SPY	ETF	186.43	186.45	186.38	186.41	52908.0
2014-03-17 18:30:00	SPY	ETF	186.41	186.47	186.41	186.45	3770.0
2014-03-17 19:00:00	SPY	ETF	186.479	186.48	186.43	186.45	10205.0
2014-03-17 19:30:00	SPY	ETF	186.45	186.48	186.36	186.36	58751.0
2014-03-17 04:00:00	QQQ	ETF	88.99	88.99	88.99	88.99	6000.0
2014-03-17 04:30:00	QQQ	ETF	89.01	89.19	89.01	89.19	6300.0
2014-03-17 05:00:00	QQQ	ETF	89.35	89.35	89.27	89.27	300.0
2014-03-17 05:30:00	QQQ	ETF	89.28	89.28	89.28	89.28	100.0
2014-03-17 06:00:00	QQQ	ETF	89.28	89.28	89.28	89.28	300.0
2014-03-17 06:30:00	QQQ	ETF	89.35	89.35	89.21	89.21	3620.0
2014-03-17 07:00:00	QQQ	ETF	89.21	89.21	89.17	89.17	7280.0
2014-03-17 07:30:00	QQQ	ETF	89.18	89.19	89.15	89.15	11800.0
2014-03-17 08:00:00	QQQ	ETF	89.14	89.22	89.09	89.1	322930.0
2014-03-17 08:30:00	QQQ	ETF	89.08	89.15	88.56	89.08	63720.0
2014-03-17 09:00:00	QQQ	ETF	89.11	89.26	88.65	89.24	246399.0
2014-03-17 09:30:00	QQQ	ETF	89.24	89.77	89.19	89.66	5079698.0
2014-03-17 10:00:00	QQQ	ETF	89.66	89.91	89.621	89.65	2970938.0
2014-03-17 10:30:00	QQQ	ETF	89.65	89.71	89.395	89.55	2139201.0
2014-03-17 11:00:00	QQQ	ETF	89.54	89.7	89.4101	89.45	1879398.0
2014-03-17 11:30:00	QQQ	ETF	89.45	89.64	89.35	89.64	1269582.0
2014-03-17 12:00:00	QQQ	ETF	89.64	89.81	89.57	89.8	1156145.0
2014-03-17 12:30:00	QQQ	ETF	89.81	89.85	89.68	89.75	1386024.0

> showing 50 of 11,266 rows — these rows as CSV

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