PREVIEW / etf_30min / 2014-10-06

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-06.parquet
  size:    354 KB
  rows:    11,921

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-10-06 04:00:00	SPY	ETF	197.08	197.45	197.08	197.38	14128.0
2014-10-06 04:30:00	SPY	ETF	197.4	197.42	197.31	197.31	2580.0
2014-10-06 05:00:00	SPY	ETF	197.2	197.27	197.18	197.19	15687.0
2014-10-06 05:30:00	SPY	ETF	197.19	197.21	196.96	197.02	7622.0
2014-10-06 06:00:00	SPY	ETF	197.06	197.11	197.03	197.08	21635.0
2014-10-06 06:30:00	SPY	ETF	197.07	197.23	197.05	197.17	61398.0
2014-10-06 07:00:00	SPY	ETF	197.18	197.32	197.15	197.31	235013.0
2014-10-06 07:30:00	SPY	ETF	197.31	197.33	197.06	197.07	85837.0
2014-10-06 08:00:00	SPY	ETF	197.15	197.36	197.08	197.34	235644.0
2014-10-06 08:30:00	SPY	ETF	197.35	197.46	197.26	197.29	415058.0
2014-10-06 09:00:00	SPY	ETF	197.3	197.48	197.25	197.35	801164.0
2014-10-06 09:30:00	SPY	ETF	197.34	197.6	197.23	197.3	11567686.0
2014-10-06 10:00:00	SPY	ETF	197.3	197.48	196.84	196.92	8760141.0
2014-10-06 10:30:00	SPY	ETF	196.92	197.4	196.45	196.59	8265198.0
2014-10-06 11:00:00	SPY	ETF	196.59	196.88	196.41	196.501	6355278.0
2014-10-06 11:30:00	SPY	ETF	196.52	196.8	195.76	196.01	10011334.0
2014-10-06 12:00:00	SPY	ETF	196.01	196.35	195.98	196.09	6910361.0
2014-10-06 12:30:00	SPY	ETF	196.09	196.13	195.582	195.76	6329029.0
2014-10-06 13:00:00	SPY	ETF	195.76	196.47	195.6	196.42	8420831.0
2014-10-06 13:30:00	SPY	ETF	196.42	196.49	196.15	196.36	4796440.0
2014-10-06 14:00:00	SPY	ETF	196.364	196.73	196.06	196.62	5669614.0
2014-10-06 14:30:00	SPY	ETF	196.62	196.71	196.43	196.45	4111603.0
2014-10-06 15:00:00	SPY	ETF	196.45	196.64	196.115	196.51	6270190.0
2014-10-06 15:30:00	SPY	ETF	196.5	196.59	196.22	196.26	9030698.0
2014-10-06 16:00:00	SPY	ETF	196.26	197.1	196.03	196.11	2615262.0
2014-10-06 16:30:00	SPY	ETF	196.11	196.3	195.82	195.98	2888986.0
2014-10-06 17:00:00	SPY	ETF	195.95	195.95	195.9	195.91	17628.0
2014-10-06 17:30:00	SPY	ETF	195.9	195.95	195.9	195.9	13651.0
2014-10-06 18:00:00	SPY	ETF	195.92	195.95	195.9	195.95	21906.0
2014-10-06 18:30:00	SPY	ETF	195.98	195.98	195.92	195.95	2952.0
2014-10-06 19:00:00	SPY	ETF	195.93	195.95	195.9	195.9	9104.0
2014-10-06 19:30:00	SPY	ETF	195.92	195.98	195.9	195.95	12074.0
2014-10-06 04:00:00	QQQ	ETF	98.53	98.59	98.53	98.59	28200.0
2014-10-06 04:30:00	QQQ	ETF	98.51	98.55	98.51	98.51	2800.0
2014-10-06 05:30:00	QQQ	ETF	98.4	98.4	98.35	98.35	1821.0
2014-10-06 06:00:00	QQQ	ETF	98.43	98.44	98.4	98.4	1300.0
2014-10-06 06:30:00	QQQ	ETF	98.4	98.49	98.4	98.44	5000.0
2014-10-06 07:00:00	QQQ	ETF	98.48	98.53	98.46	98.53	45900.0
2014-10-06 07:30:00	QQQ	ETF	98.5	98.5	98.38	98.41	17000.0
2014-10-06 08:00:00	QQQ	ETF	98.42	98.5	98.37	98.5	86252.0
2014-10-06 08:30:00	QQQ	ETF	98.52	98.55	98.41	98.42	131432.0
2014-10-06 09:00:00	QQQ	ETF	98.44	98.56	98.41	98.47	162808.0
2014-10-06 09:30:00	QQQ	ETF	98.47	98.72	98.421	98.55	4981283.0
2014-10-06 10:00:00	QQQ	ETF	98.56	98.6701	98.26	98.3568	2685572.0
2014-10-06 10:30:00	QQQ	ETF	98.36	98.58	98.01	98.14	2879166.0
2014-10-06 11:00:00	QQQ	ETF	98.14	98.2699	98.0	98.05	1865393.0
2014-10-06 11:30:00	QQQ	ETF	98.06	98.205	97.67	97.86	2480050.0
2014-10-06 12:00:00	QQQ	ETF	97.85	98.07	97.84	97.93	1374368.0
2014-10-06 12:30:00	QQQ	ETF	97.93	97.94	97.6587	97.777	1790649.0
2014-10-06 13:00:00	QQQ	ETF	97.77	98.0999	97.68	98.08	2087488.0

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

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