PREVIEW / etf_30min / 2014-02-28

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-02-28.parquet
  size:    344 KB
  rows:    11,527

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-02-28 04:00:00	SPY	ETF	185.75	185.75	185.48	185.5	104304.0
2014-02-28 04:30:00	SPY	ETF	185.46	185.67	185.45	185.67	26098.0
2014-02-28 05:00:00	SPY	ETF	185.68	185.69	185.57	185.67	11185.0
2014-02-28 05:30:00	SPY	ETF	185.63	185.77	185.61	185.77	847.0
2014-02-28 06:00:00	SPY	ETF	185.72	185.72	185.6	185.64	2753.0
2014-02-28 06:30:00	SPY	ETF	185.65	185.68	185.56	185.64	32787.0
2014-02-28 07:00:00	SPY	ETF	185.61	185.7	185.5	185.66	122401.0
2014-02-28 07:30:00	SPY	ETF	185.72	185.79	185.64	185.64	107815.0
2014-02-28 08:00:00	SPY	ETF	185.765	185.87	185.62	185.7	194843.0
2014-02-28 08:30:00	SPY	ETF	185.69	185.81	185.56	185.71	808772.0
2014-02-28 09:00:00	SPY	ETF	185.7	185.89	185.66	185.78	1018609.0
2014-02-28 09:30:00	SPY	ETF	185.79	186.46	185.74	186.39	11660558.0
2014-02-28 10:00:00	SPY	ETF	186.39	186.94	186.38	186.84	10716339.0
2014-02-28 10:30:00	SPY	ETF	186.84	186.96	186.65	186.8099	6141721.0
2014-02-28 11:00:00	SPY	ETF	186.8	186.81	186.56	186.71	5855258.0
2014-02-28 11:30:00	SPY	ETF	186.715	187.15	186.7	187.04	8405878.0
2014-02-28 12:00:00	SPY	ETF	187.04	187.06	186.93	187.0401	3582753.0
2014-02-28 12:30:00	SPY	ETF	187.05	187.12	186.969	187.01	3144523.0
2014-02-28 13:00:00	SPY	ETF	187.0	187.13	186.97	187.1	3138922.0
2014-02-28 13:30:00	SPY	ETF	187.09	187.125	186.82	186.86	5297355.0
2014-02-28 14:00:00	SPY	ETF	186.855	186.87	186.65	186.77	5499338.0
2014-02-28 14:30:00	SPY	ETF	186.77	186.77	185.95	186.02	12820244.0
2014-02-28 15:00:00	SPY	ETF	186.03	186.03	185.05	185.75	24661561.0
2014-02-28 15:30:00	SPY	ETF	185.75	186.41	185.74	186.33	28403752.0
2014-02-28 16:00:00	SPY	ETF	186.33	187.0	185.8396	186.54	12483997.0
2014-02-28 16:30:00	SPY	ETF	186.55	186.55	185.6	186.52	497366.0
2014-02-28 17:00:00	SPY	ETF	186.5	186.54	186.4	186.4	302638.0
2014-02-28 17:30:00	SPY	ETF	186.4	186.41	186.25	186.32	745027.0
2014-02-28 18:00:00	SPY	ETF	186.31	186.37	186.29	186.31	96156.0
2014-02-28 18:30:00	SPY	ETF	186.32	186.34	186.29	186.3	20177.0
2014-02-28 19:00:00	SPY	ETF	186.3	186.33	186.26	186.3	37882.0
2014-02-28 19:30:00	SPY	ETF	186.3	186.33	186.28	186.29	28300.0
2014-02-28 04:00:00	QQQ	ETF	90.28	90.28	90.28	90.28	2500.0
2014-02-28 04:30:00	QQQ	ETF	90.28	90.28	90.28	90.28	100.0
2014-02-28 05:00:00	QQQ	ETF	90.3	90.3	90.3	90.3	2500.0
2014-02-28 06:00:00	QQQ	ETF	90.31	90.32	90.3	90.32	1800.0
2014-02-28 06:30:00	QQQ	ETF	90.29	90.34	90.29	90.34	800.0
2014-02-28 07:00:00	QQQ	ETF	90.33	90.33	90.26	90.32	1400.0
2014-02-28 07:30:00	QQQ	ETF	90.35	90.35	90.35	90.35	500.0
2014-02-28 08:00:00	QQQ	ETF	90.35	90.41	90.35	90.4	36898.0
2014-02-28 08:30:00	QQQ	ETF	90.36	90.42	90.34	90.4	29910.0
2014-02-28 09:00:00	QQQ	ETF	90.4	90.47	90.35	90.41	643124.0
2014-02-28 09:30:00	QQQ	ETF	90.41	90.84	90.38	90.71	4195491.0
2014-02-28 10:00:00	QQQ	ETF	90.71	90.96	90.71	90.79	2929383.0
2014-02-28 10:30:00	QQQ	ETF	90.79	90.88	90.74	90.751	2363685.0
2014-02-28 11:00:00	QQQ	ETF	90.76	90.77	90.65	90.695	1698402.0
2014-02-28 11:30:00	QQQ	ETF	90.695	90.95	90.682	90.89	1843570.0
2014-02-28 12:00:00	QQQ	ETF	90.9	90.9	90.82	90.85	1625154.0
2014-02-28 12:30:00	QQQ	ETF	90.85	90.89	90.79	90.82	784738.0
2014-02-28 13:00:00	QQQ	ETF	90.825	90.87	90.78	90.82	955420.0

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

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