PREVIEW / etf_30min / 2014-01-28

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-28.parquet
  size:    352 KB
  rows:    11,767

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-28 04:00:00	SPY	ETF	178.6	178.95	178.6	178.95	94063.0
2014-01-28 04:30:00	SPY	ETF	178.93	179.07	178.89	178.97	43477.0
2014-01-28 05:00:00	SPY	ETF	178.93	178.95	178.84	178.9	123741.0
2014-01-28 05:30:00	SPY	ETF	178.89	178.96	178.85	178.9	22088.0
2014-01-28 06:00:00	SPY	ETF	178.93	178.93	178.71	178.71	26852.0
2014-01-28 06:30:00	SPY	ETF	178.72	178.86	178.65	178.86	94591.0
2014-01-28 07:00:00	SPY	ETF	178.84	178.86	178.67	178.7	115296.0
2014-01-28 07:30:00	SPY	ETF	178.6	178.73	178.47	178.48	403460.0
2014-01-28 08:00:00	SPY	ETF	178.96	178.96	178.5	178.8	403242.0
2014-01-28 08:30:00	SPY	ETF	178.8	178.8	177.99	178.56	2805336.0
2014-01-28 09:00:00	SPY	ETF	178.58	178.6	178.02	178.15	1934904.0
2014-01-28 09:30:00	SPY	ETF	178.14	178.94	178.12	178.866	13645923.0
2014-01-28 10:00:00	SPY	ETF	178.89	179.26	178.74	178.95	14106799.0
2014-01-28 10:30:00	SPY	ETF	178.94	179.2	178.85	179.06	6771216.0
2014-01-28 11:00:00	SPY	ETF	179.06	179.3	178.64	178.71	8723309.0
2014-01-28 11:30:00	SPY	ETF	178.72	178.815	178.28	178.59	8209456.0
2014-01-28 12:00:00	SPY	ETF	178.59	178.82	178.48	178.81	5075601.0
2014-01-28 12:30:00	SPY	ETF	178.81	179.01	178.64	178.81	4001151.0
2014-01-28 13:00:00	SPY	ETF	178.83	179.08	178.72	178.99	3333000.0
2014-01-28 13:30:00	SPY	ETF	178.98	179.07	178.75	178.85	3340325.0
2014-01-28 14:00:00	SPY	ETF	178.86	179.095	178.78	178.98	3559584.0
2014-01-28 14:30:00	SPY	ETF	178.98	179.19	178.97	179.1	3884263.0
2014-01-28 15:00:00	SPY	ETF	179.105	179.16	178.92	179.09	3923736.0
2014-01-28 15:30:00	SPY	ETF	179.0901	179.27	178.93	179.07	12869707.0
2014-01-28 16:00:00	SPY	ETF	179.08	179.29	178.0287	179.21	6713372.0
2014-01-28 16:30:00	SPY	ETF	179.23	179.33	178.71	179.3	476778.0
2014-01-28 17:00:00	SPY	ETF	179.3	180.11	179.3	179.78	1741151.0
2014-01-28 17:30:00	SPY	ETF	179.77	179.88	179.74	179.88	295325.0
2014-01-28 18:00:00	SPY	ETF	179.88	180.33	179.76	180.04	959385.0
2014-01-28 18:30:00	SPY	ETF	180.01	180.07	179.88	179.94	461804.0
2014-01-28 19:00:00	SPY	ETF	179.95	180.19	179.94	180.12	77042.0
2014-01-28 19:30:00	SPY	ETF	180.12	180.17	180.05	180.17	53097.0
2014-01-28 04:30:00	QQQ	ETF	85.8	85.8	85.8	85.8	4100.0
2014-01-28 05:00:00	QQQ	ETF	85.71	85.71	85.71	85.71	100.0
2014-01-28 05:30:00	QQQ	ETF	85.76	85.76	85.73	85.74	4300.0
2014-01-28 06:00:00	QQQ	ETF	85.73	85.73	85.64	85.64	4500.0
2014-01-28 06:30:00	QQQ	ETF	85.62	85.71	85.62	85.71	1220.0
2014-01-28 07:00:00	QQQ	ETF	85.63	85.72	85.63	85.65	73200.0
2014-01-28 07:30:00	QQQ	ETF	85.65	85.71	85.57	85.59	81455.0
2014-01-28 08:00:00	QQQ	ETF	85.59	85.65	85.56	85.65	21101.0
2014-01-28 08:30:00	QQQ	ETF	85.65	85.67	85.38	85.64	315701.0
2014-01-28 09:00:00	QQQ	ETF	85.62	85.66	85.42	85.42	260442.0
2014-01-28 09:30:00	QQQ	ETF	85.42	85.74	85.35	85.685	6143427.0
2014-01-28 10:00:00	QQQ	ETF	85.685	85.88	85.64	85.8	4174233.0
2014-01-28 10:30:00	QQQ	ETF	85.8	85.92	85.74	85.82	2176113.0
2014-01-28 11:00:00	QQQ	ETF	85.82	85.94	85.48	85.5	5521003.0
2014-01-28 11:30:00	QQQ	ETF	85.5	85.58	85.31	85.49	3484739.0
2014-01-28 12:00:00	QQQ	ETF	85.49	85.545	85.3849	85.5	1796493.0
2014-01-28 12:30:00	QQQ	ETF	85.5	85.615	85.435	85.55	2607340.0
2014-01-28 13:00:00	QQQ	ETF	85.545	85.69	85.47	85.6	2577318.0

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

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