PREVIEW / etf_30min / 2014-09-09

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-09.parquet
  size:    345 KB
  rows:    11,587

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-09-09 04:00:00	SPY	ETF	200.57	200.72	200.43	200.43	1942.0
2014-09-09 05:00:00	SPY	ETF	200.45	200.47	200.4	200.47	3072.0
2014-09-09 05:30:00	SPY	ETF	200.47	200.56	200.46	200.56	5283.0
2014-09-09 06:00:00	SPY	ETF	200.59	200.64	200.56	200.57	4698.0
2014-09-09 06:30:00	SPY	ETF	200.61	200.75	200.61	200.74	17436.0
2014-09-09 07:00:00	SPY	ETF	200.69	200.9	200.69	200.77	66239.0
2014-09-09 07:30:00	SPY	ETF	200.85	200.85	200.74	200.74	106269.0
2014-09-09 08:00:00	SPY	ETF	200.73	200.74	200.5	200.58	264557.0
2014-09-09 08:30:00	SPY	ETF	200.59	200.59	200.46	200.55	164537.0
2014-09-09 09:00:00	SPY	ETF	200.55	200.56	200.21	200.42	541901.0
2014-09-09 09:30:00	SPY	ETF	200.41	200.42	199.76	199.78	9078490.0
2014-09-09 10:00:00	SPY	ETF	199.78	200.02	199.59	199.8499	6425529.0
2014-09-09 10:30:00	SPY	ETF	199.84	199.93	199.57	199.86	5429585.0
2014-09-09 11:00:00	SPY	ETF	199.86	200.19	199.8	200.07	3999467.0
2014-09-09 11:30:00	SPY	ETF	200.08	200.14	199.89	200.005	2266554.0
2014-09-09 12:00:00	SPY	ETF	200.0	200.16	199.85	200.1	3705800.0
2014-09-09 12:30:00	SPY	ETF	200.11	200.15	199.84	199.9	2675034.0
2014-09-09 13:00:00	SPY	ETF	199.9	200.02	199.66	199.8601	4343677.0
2014-09-09 13:30:00	SPY	ETF	199.87	200.55	199.87	200.45	5009021.0
2014-09-09 14:00:00	SPY	ETF	200.445	200.47	199.76	199.78	5110884.0
2014-09-09 14:30:00	SPY	ETF	199.785	199.94	199.6	199.74	5880102.0
2014-09-09 15:00:00	SPY	ETF	199.74	199.74	198.91	199.27	13919782.0
2014-09-09 15:30:00	SPY	ETF	199.28	199.37	199.14	199.33	12123233.0
2014-09-09 16:00:00	SPY	ETF	199.33	199.58	199.32	199.55	5061986.0
2014-09-09 16:30:00	SPY	ETF	199.57	199.58	199.32	199.52	428710.0
2014-09-09 17:00:00	SPY	ETF	199.52	199.57	199.51	199.57	37568.0
2014-09-09 17:30:00	SPY	ETF	199.56	199.57	199.51	199.55	26000.0
2014-09-09 18:00:00	SPY	ETF	199.55	199.57	199.48	199.48	16262.0
2014-09-09 18:30:00	SPY	ETF	199.48	199.52	199.48	199.5	11030.0
2014-09-09 19:00:00	SPY	ETF	199.51	199.51	199.36	199.36	19963.0
2014-09-09 19:30:00	SPY	ETF	199.38	199.38	199.3	199.34	37906.0
2014-09-09 04:00:00	QQQ	ETF	99.99	99.99	99.96	99.96	200.0
2014-09-09 06:00:00	QQQ	ETF	100.05	100.07	100.05	100.07	1000.0
2014-09-09 06:30:00	QQQ	ETF	100.13	100.13	100.13	100.13	100.0
2014-09-09 07:00:00	QQQ	ETF	100.14	100.23	100.14	100.18	32300.0
2014-09-09 07:30:00	QQQ	ETF	100.19	100.21	100.17	100.19	6200.0
2014-09-09 08:00:00	QQQ	ETF	100.18	100.18	100.05	100.1	72767.0
2014-09-09 08:30:00	QQQ	ETF	100.11	100.11	100.05	100.08	19178.0
2014-09-09 09:00:00	QQQ	ETF	100.1	100.1	99.95	100.06	144729.0
2014-09-09 09:30:00	QQQ	ETF	100.06	100.09	99.7	99.76	3299752.0
2014-09-09 10:00:00	QQQ	ETF	99.751	99.95	99.69	99.85	2086934.0
2014-09-09 10:30:00	QQQ	ETF	99.86	99.885	99.69	99.73	1595165.0
2014-09-09 11:00:00	QQQ	ETF	99.73	99.94	99.68	99.885	1353534.0
2014-09-09 11:30:00	QQQ	ETF	99.89	99.91	99.8	99.86	549763.0
2014-09-09 12:00:00	QQQ	ETF	99.85	99.985	99.79	99.96	703890.0
2014-09-09 12:30:00	QQQ	ETF	99.96	99.99	99.8201	99.89	577407.0
2014-09-09 13:00:00	QQQ	ETF	99.89	99.995	99.54	99.84	2332044.0
2014-09-09 13:30:00	QQQ	ETF	99.85	100.46	99.85	100.38	4024198.0
2014-09-09 14:00:00	QQQ	ETF	100.39	100.44	99.71	99.73	3264284.0
2014-09-09 14:30:00	QQQ	ETF	99.72	99.93	99.52	99.65	3078407.0

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

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