PREVIEW / etf_30min / 2014-12-22

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-12-22.parquet
  size:    375 KB
  rows:    12,785

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-12-22 04:00:00	SPY	ETF	207.12	207.23	207.08	207.08	34079.0
2014-12-22 04:30:00	SPY	ETF	207.08	207.1	207.08	207.1	1350.0
2014-12-22 05:00:00	SPY	ETF	207.0	207.0	207.0	207.0	100.0
2014-12-22 05:30:00	SPY	ETF	207.02	207.02	207.02	207.02	200.0
2014-12-22 06:00:00	SPY	ETF	207.05	207.13	207.05	207.09	3650.0
2014-12-22 06:30:00	SPY	ETF	206.99	207.08	206.94	207.08	11560.0
2014-12-22 07:00:00	SPY	ETF	206.9	206.98	206.8	206.95	15273.0
2014-12-22 07:30:00	SPY	ETF	206.95	206.99	206.8	206.93	59941.0
2014-12-22 08:00:00	SPY	ETF	206.93	207.11	206.45	206.97	263288.0
2014-12-22 08:30:00	SPY	ETF	206.96	206.98	206.12	206.95	494425.0
2014-12-22 09:00:00	SPY	ETF	206.94	206.97	206.62	206.73	1046711.0
2014-12-22 09:30:00	SPY	ETF	206.75	207.04	206.51	206.73	11601726.0
2014-12-22 10:00:00	SPY	ETF	206.75	207.02	206.51	206.9	10782967.0
2014-12-22 10:30:00	SPY	ETF	206.9	206.96	206.67	206.78	8988475.0
2014-12-22 11:00:00	SPY	ETF	206.76	206.825	206.46	206.8	7198438.0
2014-12-22 11:30:00	SPY	ETF	206.79	206.86	206.5	206.6353	7529682.0
2014-12-22 12:00:00	SPY	ETF	206.63	206.75	206.53	206.64	3710201.0
2014-12-22 12:30:00	SPY	ETF	206.64	206.9	206.56	206.825	4387773.0
2014-12-22 13:00:00	SPY	ETF	206.83	207.0	206.8	206.91	5948957.0
2014-12-22 13:30:00	SPY	ETF	206.92	207.01	206.85	207.0	4724166.0
2014-12-22 14:00:00	SPY	ETF	207.01	207.17	206.92	207.07	9275919.0
2014-12-22 14:30:00	SPY	ETF	207.07	207.12	206.87	206.995	6718880.0
2014-12-22 15:00:00	SPY	ETF	207.0	207.34	207.0	207.305	10693287.0
2014-12-22 15:30:00	SPY	ETF	207.3	207.47	207.13	207.45	18899991.0
2014-12-22 16:00:00	SPY	ETF	207.45	207.56	206.4838	207.29	9598643.0
2014-12-22 16:30:00	SPY	ETF	207.29	207.36	207.22	207.23	2157528.0
2014-12-22 17:00:00	SPY	ETF	207.23	207.47	207.22	207.28	11968644.0
2014-12-22 17:30:00	SPY	ETF	207.29	207.33	207.28	207.33	298870.0
2014-12-22 18:00:00	SPY	ETF	207.34	207.36	207.22	207.29	49757.0
2014-12-22 18:30:00	SPY	ETF	207.29	207.36	207.29	207.33	7381.0
2014-12-22 19:00:00	SPY	ETF	207.33	207.33	207.26	207.28	10970.0
2014-12-22 19:30:00	SPY	ETF	207.31	207.38	207.27	207.38	70802.0
2014-12-22 04:00:00	QQQ	ETF	104.44	104.51	104.44	104.51	12450.0
2014-12-22 04:30:00	QQQ	ETF	104.45	104.45	104.45	104.45	400.0
2014-12-22 06:00:00	QQQ	ETF	104.56	104.56	104.56	104.56	400.0
2014-12-22 06:30:00	QQQ	ETF	104.55	104.57	104.55	104.57	400.0
2014-12-22 07:00:00	QQQ	ETF	104.49	104.49	104.42	104.42	13150.0
2014-12-22 07:30:00	QQQ	ETF	104.4	104.41	104.4	104.4	3300.0
2014-12-22 08:00:00	QQQ	ETF	104.34	104.77	103.84	104.25	145232.0
2014-12-22 08:30:00	QQQ	ETF	104.25	104.3	104.21	104.24	17846.0
2014-12-22 09:00:00	QQQ	ETF	104.3	104.3	104.06	104.15	429112.0
2014-12-22 09:30:00	QQQ	ETF	104.15	104.55	104.0999	104.38	4178500.0
2014-12-22 10:00:00	QQQ	ETF	104.38	104.59	104.33	104.52	4213392.0
2014-12-22 10:30:00	QQQ	ETF	104.53	104.55	104.35	104.41	1402244.0
2014-12-22 11:00:00	QQQ	ETF	104.4	104.45	104.19	104.43	1737680.0
2014-12-22 11:30:00	QQQ	ETF	104.43	104.47	104.23	104.308	683994.0
2014-12-22 12:00:00	QQQ	ETF	104.3	104.47	104.25	104.4	1640708.0
2014-12-22 12:30:00	QQQ	ETF	104.395	104.55	104.37	104.54	1271506.0
2014-12-22 13:00:00	QQQ	ETF	104.54	104.56	104.41	104.54	1943012.0
2014-12-22 13:30:00	QQQ	ETF	104.54	104.61	104.52	104.57	1280715.0

> showing 50 of 12,785 rows — these rows as CSV

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