PREVIEW / etf_30min / 2017-06-02

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-06-02.parquet
  size:    435 KB
  rows:    15,035

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-06-02 04:00:00	SPY	ETF	243.56	243.71	243.56	243.71	32760.0
2017-06-02 04:30:00	SPY	ETF	243.75	243.75	243.69	243.73	8800.0
2017-06-02 05:00:00	SPY	ETF	243.73	243.75	243.73	243.73	503.0
2017-06-02 05:30:00	SPY	ETF	243.7	243.8	243.7	243.8	1835.0
2017-06-02 06:00:00	SPY	ETF	243.85	243.93	243.79	243.88	15376.0
2017-06-02 06:30:00	SPY	ETF	243.87	244.08	243.85	244.07	6920.0
2017-06-02 07:00:00	SPY	ETF	244.07	244.07	243.89	243.9	108917.0
2017-06-02 07:30:00	SPY	ETF	243.9	243.9	243.84	243.88	40253.0
2017-06-02 08:00:00	SPY	ETF	243.87	243.98	243.77	243.79	274760.0
2017-06-02 08:30:00	SPY	ETF	243.76	243.82	243.23	243.53	1143361.0
2017-06-02 09:00:00	SPY	ETF	243.535	243.64	243.37	243.43	627198.0
2017-06-02 09:30:00	SPY	ETF	243.42	243.69	243.08	243.25	8451259.0
2017-06-02 10:00:00	SPY	ETF	243.25	243.48	243.2	243.47	3922709.0
2017-06-02 10:30:00	SPY	ETF	243.46	243.76	243.41	243.67	4129173.0
2017-06-02 11:00:00	SPY	ETF	243.675	243.77	243.6	243.7	2374466.0
2017-06-02 11:30:00	SPY	ETF	243.69	244.06	243.69	244.03	2703267.0
2017-06-02 12:00:00	SPY	ETF	244.03	244.09	243.87	244.08	2653669.0
2017-06-02 12:30:00	SPY	ETF	244.08	244.085	243.93	244.0	1946632.0
2017-06-02 13:00:00	SPY	ETF	244.005	244.07	243.92	244.06	1891840.0
2017-06-02 13:30:00	SPY	ETF	244.07	244.29	244.05	244.21	3057951.0
2017-06-02 14:00:00	SPY	ETF	244.205	244.255	243.96	243.97	2461642.0
2017-06-02 14:30:00	SPY	ETF	243.97	244.16	243.97	244.1	2095009.0
2017-06-02 15:00:00	SPY	ETF	244.115	244.24	244.09	244.155	3272771.0
2017-06-02 15:30:00	SPY	ETF	244.15	244.35	243.93	244.13	16598902.0
2017-06-02 16:00:00	SPY	ETF	244.13	244.2215	243.87	244.15	27591533.0
2017-06-02 16:30:00	SPY	ETF	244.15	244.18	244.07	244.17	1968662.0
2017-06-02 17:00:00	SPY	ETF	244.15	244.2	244.13	244.2	80383.0
2017-06-02 17:30:00	SPY	ETF	244.21	244.27	244.21	244.22	92650.0
2017-06-02 18:00:00	SPY	ETF	244.21	244.21	244.17	244.2	2849.0
2017-06-02 18:30:00	SPY	ETF	244.2	244.2	244.19	244.19	3398.0
2017-06-02 19:00:00	SPY	ETF	244.19	244.2	244.15	244.15	14102.0
2017-06-02 19:30:00	SPY	ETF	244.19	244.26	244.1	244.25	54698.0
2017-06-02 04:00:00	QQQ	ETF	142.33	142.36	142.3	142.36	2800.0
2017-06-02 04:30:00	QQQ	ETF	142.36	142.36	142.36	142.36	1000.0
2017-06-02 05:30:00	QQQ	ETF	142.4	142.42	142.4	142.42	900.0
2017-06-02 06:00:00	QQQ	ETF	142.42	142.48	142.42	142.48	900.0
2017-06-02 06:30:00	QQQ	ETF	142.45	142.5	142.45	142.49	5800.0
2017-06-02 07:00:00	QQQ	ETF	142.51	142.52	142.44	142.44	31800.0
2017-06-02 07:30:00	QQQ	ETF	142.46	142.5	142.43	142.45	60900.0
2017-06-02 08:00:00	QQQ	ETF	142.48	142.5	142.42	142.44	39011.0
2017-06-02 08:30:00	QQQ	ETF	142.43	142.43	142.16	142.33	154555.0
2017-06-02 09:00:00	QQQ	ETF	142.35	142.41	142.31	142.35	207418.0
2017-06-02 09:30:00	QQQ	ETF	142.34	142.48	142.11	142.2693	2998627.0
2017-06-02 10:00:00	QQQ	ETF	142.26	142.61	142.22	142.57	1336337.0
2017-06-02 10:30:00	QQQ	ETF	142.56	142.71	142.49	142.6354	1819574.0
2017-06-02 11:00:00	QQQ	ETF	142.6499	142.78	142.62	142.77	1195838.0
2017-06-02 11:30:00	QQQ	ETF	142.77	143.03	142.76	142.99	1577972.0
2017-06-02 12:00:00	QQQ	ETF	142.98	143.05	142.93	143.03	1087923.0
2017-06-02 12:30:00	QQQ	ETF	143.03	143.07	142.96	143.055	1271223.0
2017-06-02 13:00:00	QQQ	ETF	143.05	143.19	143.02	143.18	2380581.0

> showing 50 of 15,035 rows — these rows as CSV

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