PREVIEW / etf_30min / 2014-10-02

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-02.parquet
  size:    377 KB
  rows:    12,445

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-02 04:00:00	SPY	ETF	194.6	194.6	194.33	194.33	423.0
2014-10-02 04:30:00	SPY	ETF	194.33	194.33	194.13	194.2	2189.0
2014-10-02 05:00:00	SPY	ETF	194.29	194.4	194.27	194.4	1929.0
2014-10-02 05:30:00	SPY	ETF	194.3	194.48	194.28	194.48	10288.0
2014-10-02 06:00:00	SPY	ETF	194.45	194.5	194.34	194.5	19044.0
2014-10-02 06:30:00	SPY	ETF	194.45	194.7	194.45	194.58	80337.0
2014-10-02 07:00:00	SPY	ETF	194.58	194.93	194.58	194.93	273749.0
2014-10-02 07:30:00	SPY	ETF	194.9	194.95	194.74	194.76	392614.0
2014-10-02 08:00:00	SPY	ETF	194.74	194.9	194.63	194.81	278237.0
2014-10-02 08:30:00	SPY	ETF	194.8	195.07	194.26	194.48	1688244.0
2014-10-02 09:00:00	SPY	ETF	194.46	194.55	193.91	194.17	2046100.0
2014-10-02 09:30:00	SPY	ETF	194.18	194.77	194.16	194.46	15626892.0
2014-10-02 10:00:00	SPY	ETF	194.47	194.55	194.04	194.26	13088215.0
2014-10-02 10:30:00	SPY	ETF	194.26	194.265	193.33	193.35	13019969.0
2014-10-02 11:00:00	SPY	ETF	193.35	193.65	193.215	193.31	11364742.0
2014-10-02 11:30:00	SPY	ETF	193.31	193.36	192.35	192.94	16640703.0
2014-10-02 12:00:00	SPY	ETF	192.95	193.28	192.87	193.2	8051403.0
2014-10-02 12:30:00	SPY	ETF	193.19	193.77	192.9	193.735	9342853.0
2014-10-02 13:00:00	SPY	ETF	193.74	194.37	193.6	194.29	10846977.0
2014-10-02 13:30:00	SPY	ETF	194.29	194.4	193.98	194.1	8394811.0
2014-10-02 14:00:00	SPY	ETF	194.1	194.75	194.09	194.69	8919489.0
2014-10-02 14:30:00	SPY	ETF	194.69	195.055	194.38	194.82	8544205.0
2014-10-02 15:00:00	SPY	ETF	194.815	194.85	194.36	194.485	7845138.0
2014-10-02 15:30:00	SPY	ETF	194.48	194.64	194.22	194.39	13211518.0
2014-10-02 16:00:00	SPY	ETF	194.37	194.56	193.63	194.36	4136927.0
2014-10-02 16:30:00	SPY	ETF	194.36	194.58	194.34	194.38	1715833.0
2014-10-02 17:00:00	SPY	ETF	194.38	194.45	194.35	194.45	88620.0
2014-10-02 17:30:00	SPY	ETF	194.4	194.42	194.36	194.38	6220.0
2014-10-02 18:00:00	SPY	ETF	194.39	194.4	194.29	194.29	19779.0
2014-10-02 18:30:00	SPY	ETF	194.28	194.35	194.2	194.26	40921.0
2014-10-02 19:00:00	SPY	ETF	194.24	194.33	194.11	194.31	24421.0
2014-10-02 19:30:00	SPY	ETF	194.3	194.49	194.3	194.49	31924.0
2014-10-02 04:00:00	QQQ	ETF	97.49	97.49	97.12	97.12	820.0
2014-10-02 04:30:00	QQQ	ETF	97.03	97.03	97.01	97.03	8150.0
2014-10-02 05:00:00	QQQ	ETF	97.13	97.16	97.13	97.16	200.0
2014-10-02 05:30:00	QQQ	ETF	97.1	97.21	97.1	97.21	1100.0
2014-10-02 06:00:00	QQQ	ETF	97.18	97.24	97.17	97.24	5000.0
2014-10-02 06:30:00	QQQ	ETF	97.26	97.32	97.26	97.31	2900.0
2014-10-02 07:00:00	QQQ	ETF	97.31	97.46	97.31	97.45	52400.0
2014-10-02 07:30:00	QQQ	ETF	97.44	97.48	97.4	97.41	62300.0
2014-10-02 08:00:00	QQQ	ETF	97.39	97.48	97.0	97.48	194090.0
2014-10-02 08:30:00	QQQ	ETF	97.47	97.61	97.23	97.33	235238.0
2014-10-02 09:00:00	QQQ	ETF	97.32	97.35	97.06	97.19	560091.0
2014-10-02 09:30:00	QQQ	ETF	97.19	97.429	97.05	97.22	5152709.0
2014-10-02 10:00:00	QQQ	ETF	97.21	97.29	97.01	97.05	3809382.0
2014-10-02 10:30:00	QQQ	ETF	97.05	97.05	96.49	96.5	4983896.0
2014-10-02 11:00:00	QQQ	ETF	96.51	96.72	96.445	96.58	4575166.0
2014-10-02 11:30:00	QQQ	ETF	96.58	96.6161	95.97	96.35	5043196.0
2014-10-02 12:00:00	QQQ	ETF	96.341	96.57	96.33	96.49	1874564.0
2014-10-02 12:30:00	QQQ	ETF	96.5	96.9699	96.355	96.96	3116796.0

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

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