PREVIEW / etf_30min / 2017-03-02

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-02.parquet
  size:    441 KB
  rows:    14,964

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
2017-03-02 04:00:00	SPY	ETF	239.45	239.45	239.28	239.4	5830.0
2017-03-02 04:30:00	SPY	ETF	239.38	239.41	239.23	239.33	5296.0
2017-03-02 05:00:00	SPY	ETF	239.28	239.44	239.28	239.35	9013.0
2017-03-02 05:30:00	SPY	ETF	239.39	239.46	239.33	239.4	920.0
2017-03-02 06:00:00	SPY	ETF	239.37	239.37	239.25	239.25	6628.0
2017-03-02 06:30:00	SPY	ETF	239.26	239.35	239.25	239.35	21859.0
2017-03-02 07:00:00	SPY	ETF	239.38	239.42	239.36	239.42	124839.0
2017-03-02 07:30:00	SPY	ETF	239.4	239.51	239.38	239.49	82238.0
2017-03-02 08:00:00	SPY	ETF	239.48	239.61	239.4	239.61	126480.0
2017-03-02 08:30:00	SPY	ETF	239.61	239.73	239.59	239.64	330131.0
2017-03-02 09:00:00	SPY	ETF	239.61	239.63	239.52	239.56	284801.0
2017-03-02 09:30:00	SPY	ETF	239.56	239.57	239.07	239.38	8086750.0
2017-03-02 10:00:00	SPY	ETF	239.38	239.38	238.99	239.2303	4771960.0
2017-03-02 10:30:00	SPY	ETF	239.23	239.25	239.03	239.05	2839103.0
2017-03-02 11:00:00	SPY	ETF	239.05	239.05	238.73	238.87	4119649.0
2017-03-02 11:30:00	SPY	ETF	238.87	238.97	238.55	238.96	4704132.0
2017-03-02 12:00:00	SPY	ETF	238.96	238.99	238.6301	238.695	2474091.0
2017-03-02 12:30:00	SPY	ETF	238.6901	238.91	238.68	238.85	2257123.0
2017-03-02 13:00:00	SPY	ETF	238.85	238.94	238.71	238.93	2464501.0
2017-03-02 13:30:00	SPY	ETF	238.92	238.93	238.7	238.83	2287965.0
2017-03-02 14:00:00	SPY	ETF	238.84	238.95	238.65	238.945	2936041.0
2017-03-02 14:30:00	SPY	ETF	238.93	239.08	238.89	238.95	3485007.0
2017-03-02 15:00:00	SPY	ETF	238.955	238.955	238.39	238.625	4867442.0
2017-03-02 15:30:00	SPY	ETF	238.63	238.68	238.21	238.33	14645338.0
2017-03-02 16:00:00	SPY	ETF	238.32	238.52	238.11	238.5	5677580.0
2017-03-02 16:30:00	SPY	ETF	238.48	238.7316	238.27	238.39	649715.0
2017-03-02 17:00:00	SPY	ETF	238.37	238.37	238.27	238.32	58282.0
2017-03-02 17:30:00	SPY	ETF	238.32	238.35	238.29	238.29	8413.0
2017-03-02 18:00:00	SPY	ETF	238.27	238.33	238.16	238.23	44312.0
2017-03-02 18:30:00	SPY	ETF	238.23	238.25	238.19	238.23	4498.0
2017-03-02 19:00:00	SPY	ETF	238.26	238.3	238.23	238.3	5981.0
2017-03-02 19:30:00	SPY	ETF	238.31	238.31	238.15	238.16	33037.0
2017-03-02 04:00:00	QQQ	ETF	131.34	131.34	131.3	131.3	1000.0
2017-03-02 06:00:00	QQQ	ETF	131.25	131.25	131.25	131.25	280.0
2017-03-02 06:30:00	QQQ	ETF	131.3	131.3	131.27	131.27	700.0
2017-03-02 07:00:00	QQQ	ETF	131.33	131.33	131.33	131.33	8499.0
2017-03-02 07:30:00	QQQ	ETF	131.34	131.35	131.34	131.35	8600.0
2017-03-02 08:00:00	QQQ	ETF	131.41	131.45	131.38	131.45	6466.0
2017-03-02 08:30:00	QQQ	ETF	131.45	131.53	131.45	131.51	41301.0
2017-03-02 09:00:00	QQQ	ETF	131.5	131.51	131.44	131.44	136149.0
2017-03-02 09:30:00	QQQ	ETF	131.43	131.43	131.16	131.36	1997104.0
2017-03-02 10:00:00	QQQ	ETF	131.35	131.37	131.1	131.19	1048162.0
2017-03-02 10:30:00	QQQ	ETF	131.19	131.2	131.06	131.07	631111.0
2017-03-02 11:00:00	QQQ	ETF	131.07	131.11	130.84	130.97	1116642.0
2017-03-02 11:30:00	QQQ	ETF	130.97	131.06	130.83	131.06	913142.0
2017-03-02 12:00:00	QQQ	ETF	131.06	131.07	130.83	130.88	722130.0
2017-03-02 12:30:00	QQQ	ETF	130.88	130.99	130.86	130.97	351906.0
2017-03-02 13:00:00	QQQ	ETF	130.97	130.99	130.85	130.97	637554.0
2017-03-02 13:30:00	QQQ	ETF	130.96	130.98	130.89	130.95	698511.0
2017-03-02 14:00:00	QQQ	ETF	130.95	131.01	130.88	131.01	1012012.0

> showing 50 of 14,964 rows — these rows as CSV

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