PREVIEW / etf_30min / 2014-01-10

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-10.parquet
  size:    344 KB
  rows:    11,438

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-01-10 04:00:00	SPY	ETF	183.8	184.12	183.8	184.11	1278.0
2014-01-10 04:30:00	SPY	ETF	184.12	184.14	184.12	184.14	75492.0
2014-01-10 05:00:00	SPY	ETF	184.09	184.17	184.09	184.12	10700.0
2014-01-10 05:30:00	SPY	ETF	184.11	184.25	184.1	184.25	2820.0
2014-01-10 06:00:00	SPY	ETF	184.23	184.29	184.23	184.25	3350.0
2014-01-10 06:30:00	SPY	ETF	184.26	184.32	184.22	184.22	33853.0
2014-01-10 07:00:00	SPY	ETF	184.25	184.38	184.22	184.35	266649.0
2014-01-10 07:30:00	SPY	ETF	184.38	184.45	184.31	184.415	1145970.0
2014-01-10 08:00:00	SPY	ETF	184.42	184.57	184.25	184.36	929280.0
2014-01-10 08:30:00	SPY	ETF	184.35	184.41	183.26	184.17	7476781.0
2014-01-10 09:00:00	SPY	ETF	184.14	184.14	183.88	183.95	1671812.0
2014-01-10 09:30:00	SPY	ETF	183.95	184.22	183.67	183.68	12894597.0
2014-01-10 10:00:00	SPY	ETF	183.68	183.68	183.12	183.51	10144133.0
2014-01-10 10:30:00	SPY	ETF	183.51	183.56	183.23	183.49	4630825.0
2014-01-10 11:00:00	SPY	ETF	183.49	183.56	183.09	183.2	4872994.0
2014-01-10 11:30:00	SPY	ETF	183.21	183.27	183.01	183.17	5638294.0
2014-01-10 12:00:00	SPY	ETF	183.18	183.49	183.07	183.395	3919812.0
2014-01-10 12:30:00	SPY	ETF	183.395	183.74	183.37	183.44	4659927.0
2014-01-10 13:00:00	SPY	ETF	183.43	183.65	183.39	183.585	2619402.0
2014-01-10 13:30:00	SPY	ETF	183.58	183.72	183.3899	183.44	4208993.0
2014-01-10 14:00:00	SPY	ETF	183.44	183.6599	183.42	183.53	3706492.0
2014-01-10 14:30:00	SPY	ETF	183.525	183.69	183.5	183.53	2784633.0
2014-01-10 15:00:00	SPY	ETF	183.5351	183.97	183.5351	183.93	5972028.0
2014-01-10 15:30:00	SPY	ETF	183.92	184.08	183.86	184.07	12298369.0
2014-01-10 16:00:00	SPY	ETF	184.07	184.17	183.36	184.14	8755057.0
2014-01-10 16:30:00	SPY	ETF	184.15	184.21	183.6101	184.2	1233400.0
2014-01-10 17:00:00	SPY	ETF	184.2	184.25	184.2	184.21	80061.0
2014-01-10 17:30:00	SPY	ETF	184.2	184.29	184.11	184.11	72141.0
2014-01-10 18:00:00	SPY	ETF	184.12	184.19	184.11	184.19	4800.0
2014-01-10 18:30:00	SPY	ETF	184.19	184.2	184.14	184.19	2350.0
2014-01-10 19:00:00	SPY	ETF	184.18	184.2	184.15	184.17	10620.0
2014-01-10 19:30:00	SPY	ETF	184.2	184.25	184.18	184.19	5850.0
2014-01-10 04:00:00	QQQ	ETF	87.29	87.32	87.29	87.32	3700.0
2014-01-10 04:30:00	QQQ	ETF	87.33	87.33	87.33	87.33	1132.0
2014-01-10 05:00:00	QQQ	ETF	87.35	87.38	87.35	87.36	2100.0
2014-01-10 05:30:00	QQQ	ETF	87.37	87.4	87.35	87.4	21700.0
2014-01-10 06:00:00	QQQ	ETF	87.42	87.44	87.42	87.44	7000.0
2014-01-10 06:30:00	QQQ	ETF	87.49	87.49	87.46	87.46	2060.0
2014-01-10 07:00:00	QQQ	ETF	87.43	87.5	87.43	87.5	3100.0
2014-01-10 07:30:00	QQQ	ETF	87.5	87.54	87.49	87.54	25900.0
2014-01-10 08:00:00	QQQ	ETF	87.53	87.6	87.2	87.2	223866.0
2014-01-10 08:30:00	QQQ	ETF	87.38	87.44	86.78	87.25	804570.0
2014-01-10 09:00:00	QQQ	ETF	87.23	87.26	87.13	87.24	232634.0
2014-01-10 09:30:00	QQQ	ETF	87.24	87.4	87.0301	87.09	3725363.0
2014-01-10 10:00:00	QQQ	ETF	87.08	87.09	86.74	87.04	3631299.0
2014-01-10 10:30:00	QQQ	ETF	87.05	87.065	86.8	87.01	2482363.0
2014-01-10 11:00:00	QQQ	ETF	87.02	87.04	86.69	86.7199	2002673.0
2014-01-10 11:30:00	QQQ	ETF	86.72	86.75	86.58	86.72	3017656.0
2014-01-10 12:00:00	QQQ	ETF	86.7199	86.87	86.65	86.78	1416298.0
2014-01-10 12:30:00	QQQ	ETF	86.78	86.93	86.77	86.785	1572471.0

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

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