PREVIEW / etf_30min / 2014-07-18

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-07-18.parquet
  size:    345 KB
  rows:    11,886

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-07-18 04:00:00	SPY	ETF	195.96	196.02	195.96	195.96	559.0
2014-07-18 04:30:00	SPY	ETF	196.02	196.02	195.98	195.98	600.0
2014-07-18 05:00:00	SPY	ETF	195.97	195.98	195.9	195.98	4100.0
2014-07-18 05:30:00	SPY	ETF	195.9	195.97	195.67	195.67	2250.0
2014-07-18 06:00:00	SPY	ETF	195.83	196.0	195.82	195.96	31023.0
2014-07-18 06:30:00	SPY	ETF	195.94	196.25	195.94	196.2	71518.0
2014-07-18 07:00:00	SPY	ETF	196.18	196.36	196.11	196.3	246173.0
2014-07-18 07:30:00	SPY	ETF	196.28	196.29	196.0	196.06	225485.0
2014-07-18 08:00:00	SPY	ETF	196.11	196.3	196.04	196.13	219603.0
2014-07-18 08:30:00	SPY	ETF	196.13	196.24	196.08	196.1	555629.0
2014-07-18 09:00:00	SPY	ETF	196.11	196.42	196.11	196.35	1797825.0
2014-07-18 09:30:00	SPY	ETF	196.35	196.62	196.24	196.4699	24688443.0
2014-07-18 10:00:00	SPY	ETF	196.47	196.62	196.28	196.53	8174289.0
2014-07-18 10:30:00	SPY	ETF	196.53	196.98	196.44	196.925	6818407.0
2014-07-18 11:00:00	SPY	ETF	196.93	197.05	196.86	196.93	7179106.0
2014-07-18 11:30:00	SPY	ETF	196.93	197.32	196.9	197.16	9701125.0
2014-07-18 12:00:00	SPY	ETF	197.16	197.44	197.15	197.42	5263506.0
2014-07-18 12:30:00	SPY	ETF	197.42	197.45	197.33	197.37	4787786.0
2014-07-18 13:00:00	SPY	ETF	197.37	197.3899	197.09	197.12	4949370.0
2014-07-18 13:30:00	SPY	ETF	197.11	197.39	197.04	197.36	2568211.0
2014-07-18 14:00:00	SPY	ETF	197.36	197.69	197.2383	197.655	5967528.0
2014-07-18 14:30:00	SPY	ETF	197.655	197.73	197.56	197.6	7639994.0
2014-07-18 15:00:00	SPY	ETF	197.6	197.91	197.55	197.7	9216758.0
2014-07-18 15:30:00	SPY	ETF	197.7	197.77	197.56	197.72	12488455.0
2014-07-18 16:00:00	SPY	ETF	197.72	197.77	195.7158	197.64	5140322.0
2014-07-18 16:30:00	SPY	ETF	197.65	197.7153	197.63	197.65	4616837.0
2014-07-18 17:00:00	SPY	ETF	197.65	197.65	197.59	197.63	73063.0
2014-07-18 17:30:00	SPY	ETF	197.63	197.75	197.56	197.73	42931.0
2014-07-18 18:00:00	SPY	ETF	197.7	197.77	197.7	197.76	27626.0
2014-07-18 18:30:00	SPY	ETF	197.75	197.78	197.72	197.72	13750.0
2014-07-18 19:00:00	SPY	ETF	197.74	197.75	197.71	197.72	1085.0
2014-07-18 19:30:00	SPY	ETF	197.74	197.75	197.71	197.74	9220.0
2014-07-18 04:00:00	QQQ	ETF	94.76	94.76	94.76	94.76	300.0
2014-07-18 06:30:00	QQQ	ETF	94.8	94.9	94.72	94.9	1300.0
2014-07-18 07:00:00	QQQ	ETF	94.9	95.0	94.9	95.0	1000.0
2014-07-18 07:30:00	QQQ	ETF	95.0	95.0	94.9	94.9	85150.0
2014-07-18 08:00:00	QQQ	ETF	94.93	95.0	94.93	94.99	38531.0
2014-07-18 08:30:00	QQQ	ETF	95.0	95.07	95.0	95.02	88594.0
2014-07-18 09:00:00	QQQ	ETF	95.02	95.18	95.02	95.14	678336.0
2014-07-18 09:30:00	QQQ	ETF	95.14	95.3999	95.0	95.205	6049915.0
2014-07-18 10:00:00	QQQ	ETF	95.21	95.31	95.04	95.21	2506281.0
2014-07-18 10:30:00	QQQ	ETF	95.21	95.5	95.14	95.48	2682761.0
2014-07-18 11:00:00	QQQ	ETF	95.48	95.6	95.48	95.52	2589891.0
2014-07-18 11:30:00	QQQ	ETF	95.52	95.72	95.49	95.63	2321058.0
2014-07-18 12:00:00	QQQ	ETF	95.64	95.81	95.62	95.781	1282734.0
2014-07-18 12:30:00	QQQ	ETF	95.79	95.8101	95.71	95.7601	1228069.0
2014-07-18 13:00:00	QQQ	ETF	95.77	95.78	95.62	95.675	936122.0
2014-07-18 13:30:00	QQQ	ETF	95.67	95.87	95.65	95.84	1165660.0
2014-07-18 14:00:00	QQQ	ETF	95.84	96.071	95.78	96.05	1893189.0
2014-07-18 14:30:00	QQQ	ETF	96.06	96.1	95.97	95.9911	1928245.0

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

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