PREVIEW / etf_30min / 2014-01-02

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-02.parquet
  size:    357 KB
  rows:    11,983

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-01-02 04:00:00	SPY	ETF	184.84	184.84	183.88	183.89	15291.0
2014-01-02 04:30:00	SPY	ETF	183.99	184.19	183.99	184.15	7690.0
2014-01-02 05:00:00	SPY	ETF	184.0	184.25	183.92	184.2	16030.0
2014-01-02 05:30:00	SPY	ETF	184.2	184.2	184.01	184.01	70100.0
2014-01-02 06:00:00	SPY	ETF	184.11	184.17	183.75	184.17	281506.0
2014-01-02 06:30:00	SPY	ETF	184.27	184.31	184.11	184.12	84846.0
2014-01-02 07:00:00	SPY	ETF	184.11	184.13	183.99	184.07	213897.0
2014-01-02 07:30:00	SPY	ETF	184.12	184.15	183.82	183.85	149764.0
2014-01-02 08:00:00	SPY	ETF	183.855	184.17	183.82	184.14	270965.0
2014-01-02 08:30:00	SPY	ETF	184.13	184.13	183.87	183.93	413453.0
2014-01-02 09:00:00	SPY	ETF	183.89	184.67	183.85	183.97	1435956.0
2014-01-02 09:30:00	SPY	ETF	183.98	184.07	183.29	183.559	17964851.0
2014-01-02 10:00:00	SPY	ETF	183.55	183.91	183.12	183.445	11092498.0
2014-01-02 10:30:00	SPY	ETF	183.445	183.69	183.31	183.47	17578520.0
2014-01-02 11:00:00	SPY	ETF	183.48	183.61	183.34	183.45	5830418.0
2014-01-02 11:30:00	SPY	ETF	183.45	183.47	182.86	183.02	9289267.0
2014-01-02 12:00:00	SPY	ETF	183.02	183.135	182.86	182.92	5117459.0
2014-01-02 12:30:00	SPY	ETF	182.929	183.02	182.74	183.01	4879688.0
2014-01-02 13:00:00	SPY	ETF	183.01	183.09	182.83	182.8683	4588014.0
2014-01-02 13:30:00	SPY	ETF	182.87	183.05	182.73	182.969	4016166.0
2014-01-02 14:00:00	SPY	ETF	182.965	183.09	182.48	182.6401	7028430.0
2014-01-02 14:30:00	SPY	ETF	182.65	182.935	182.64	182.761	4164494.0
2014-01-02 15:00:00	SPY	ETF	182.76	183.17	182.74	182.99	6688980.0
2014-01-02 15:30:00	SPY	ETF	182.99	183.2	182.83	182.95	11095758.0
2014-01-02 16:00:00	SPY	ETF	182.95	184.5679	182.92	182.95	4564315.0
2014-01-02 16:30:00	SPY	ETF	182.95	182.98	182.92	182.98	1302759.0
2014-01-02 17:00:00	SPY	ETF	182.98	183.0	182.95	182.95	8789.0
2014-01-02 17:30:00	SPY	ETF	182.96	183.0	182.93	183.0	54642.0
2014-01-02 18:00:00	SPY	ETF	183.01	183.06	182.99	182.99	108656.0
2014-01-02 18:30:00	SPY	ETF	183.0	183.07	182.99	183.07	11437.0
2014-01-02 19:00:00	SPY	ETF	183.08	183.09	183.02	183.07	9700.0
2014-01-02 19:30:00	SPY	ETF	183.08	183.1	183.04	183.09	89900.0
2014-01-02 04:00:00	QQQ	ETF	88.0	88.0	87.65	87.65	4699.0
2014-01-02 04:30:00	QQQ	ETF	87.63	87.83	87.63	87.83	600.0
2014-01-02 05:00:00	QQQ	ETF	87.8	87.82	87.8	87.82	1700.0
2014-01-02 05:30:00	QQQ	ETF	87.73	87.76	87.73	87.76	4000.0
2014-01-02 06:00:00	QQQ	ETF	87.63	87.63	87.5	87.61	19400.0
2014-01-02 06:30:00	QQQ	ETF	87.62	87.65	87.62	87.65	2300.0
2014-01-02 07:00:00	QQQ	ETF	87.6	87.63	87.57	87.62	94155.0
2014-01-02 07:30:00	QQQ	ETF	87.61	87.64	87.53	87.53	84899.0
2014-01-02 08:00:00	QQQ	ETF	87.54	87.67	87.52	87.62	105579.0
2014-01-02 08:30:00	QQQ	ETF	87.63	87.63	87.54	87.55	86581.0
2014-01-02 09:00:00	QQQ	ETF	87.96	87.96	87.5	87.55	96982.0
2014-01-02 09:30:00	QQQ	ETF	87.55	87.58	87.15	87.19	8277488.0
2014-01-02 10:00:00	QQQ	ETF	87.18	87.3201	87.08	87.19	2461280.0
2014-01-02 10:30:00	QQQ	ETF	87.19	87.4	87.12	87.31	1949315.0
2014-01-02 11:00:00	QQQ	ETF	87.31	87.45	87.27	87.39	1360748.0
2014-01-02 11:30:00	QQQ	ETF	87.39	87.3999	87.1399	87.19	1983056.0
2014-01-02 12:00:00	QQQ	ETF	87.185	87.26	87.14	87.18	731071.0
2014-01-02 12:30:00	QQQ	ETF	87.1799	87.295	87.13	87.2858	950579.0

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

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