PREVIEW / etf_30min / 2018-10-02

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-02.parquet
  size:    490 KB
  rows:    16,766

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
2018-10-02 04:00:00	SPY	ETF	291.33	291.33	291.12	291.12	6950.0
2018-10-02 04:30:00	SPY	ETF	291.01	291.05	290.69	290.8	9150.0
2018-10-02 05:00:00	SPY	ETF	290.6	290.82	290.54	290.82	4532.0
2018-10-02 05:30:00	SPY	ETF	290.72	290.75	290.64	290.75	2720.0
2018-10-02 06:00:00	SPY	ETF	290.86	290.99	290.81	290.89	8684.0
2018-10-02 06:30:00	SPY	ETF	290.84	291.15	290.84	291.15	15900.0
2018-10-02 07:00:00	SPY	ETF	291.17	291.25	290.94	291.01	25988.0
2018-10-02 07:30:00	SPY	ETF	291.09	291.27	291.05	291.22	92801.0
2018-10-02 08:00:00	SPY	ETF	291.73	291.73	291.02	291.45	107787.0
2018-10-02 08:30:00	SPY	ETF	291.44	291.44	291.28	291.4	133689.0
2018-10-02 09:00:00	SPY	ETF	291.41	291.58	291.35	291.55	157706.0
2018-10-02 09:30:00	SPY	ETF	291.56	291.84	291.38	291.7	4332480.0
2018-10-02 10:00:00	SPY	ETF	291.7	291.71	291.26	291.527	3051710.0
2018-10-02 10:30:00	SPY	ETF	291.525	291.92	291.16	291.665	2859357.0
2018-10-02 11:00:00	SPY	ETF	291.67	291.93	291.62	291.73	2096115.0
2018-10-02 11:30:00	SPY	ETF	291.73	292.26	291.71	292.21	2156635.0
2018-10-02 12:00:00	SPY	ETF	292.215	292.355	292.02	292.1199	2313072.0
2018-10-02 12:30:00	SPY	ETF	292.12	292.35	291.86	291.98	2278726.0
2018-10-02 13:00:00	SPY	ETF	291.97	292.2	291.96	292.1	1956096.0
2018-10-02 13:30:00	SPY	ETF	292.1	292.31	292.09	292.16	1216863.0
2018-10-02 14:00:00	SPY	ETF	292.16	292.33	292.085	292.26	1427685.0
2018-10-02 14:30:00	SPY	ETF	292.26	292.29	291.77	291.84	3007239.0
2018-10-02 15:00:00	SPY	ETF	291.84	291.84	291.14	291.38	4883797.0
2018-10-02 15:30:00	SPY	ETF	291.38	291.76	291.36	291.57	8903028.0
2018-10-02 16:00:00	SPY	ETF	291.58	291.66	291.5439	291.6	3228067.0
2018-10-02 16:30:00	SPY	ETF	291.6	291.74	291.56	291.74	120743.0
2018-10-02 17:00:00	SPY	ETF	291.72	291.74	291.69	291.69	14685.0
2018-10-02 17:30:00	SPY	ETF	291.7	291.82	291.7	291.71	27292.0
2018-10-02 18:00:00	SPY	ETF	291.7	291.72	291.63	291.71	33026.0
2018-10-02 18:30:00	SPY	ETF	291.73	291.73	291.63	291.63	18375.0
2018-10-02 19:00:00	SPY	ETF	291.65	291.69	291.64	291.68	1950.0
2018-10-02 19:30:00	SPY	ETF	291.69	291.69	291.55	291.62	35276.0
2018-10-02 04:00:00	QQQ	ETF	185.99	185.99	185.78	185.78	1576.0
2018-10-02 04:30:00	QQQ	ETF	185.58	185.6	185.24	185.35	15563.0
2018-10-02 05:00:00	QQQ	ETF	185.27	185.28	185.21	185.28	3601.0
2018-10-02 05:30:00	QQQ	ETF	185.24	185.34	185.23	185.34	2456.0
2018-10-02 06:00:00	QQQ	ETF	185.4	185.54	185.4	185.5	7800.0
2018-10-02 06:30:00	QQQ	ETF	185.49	185.65	185.49	185.64	7444.0
2018-10-02 07:00:00	QQQ	ETF	185.64	185.77	185.41	185.49	81816.0
2018-10-02 07:30:00	QQQ	ETF	185.49	185.69	185.41	185.65	33782.0
2018-10-02 08:00:00	QQQ	ETF	185.68	185.92	185.47	185.88	46745.0
2018-10-02 08:30:00	QQQ	ETF	185.88	185.88	185.74	185.77	71726.0
2018-10-02 09:00:00	QQQ	ETF	185.77	185.98	185.76	185.94	121326.0
2018-10-02 09:30:00	QQQ	ETF	185.95	186.45	185.32	186.38	4059481.0
2018-10-02 10:00:00	QQQ	ETF	186.38	186.46	185.94	186.45	1908659.0
2018-10-02 10:30:00	QQQ	ETF	186.46	186.79	186.19	186.57	1971736.0
2018-10-02 11:00:00	QQQ	ETF	186.56	186.85	186.42	186.75	1092639.0
2018-10-02 11:30:00	QQQ	ETF	186.75	187.075	186.6801	187.03	1534716.0
2018-10-02 12:00:00	QQQ	ETF	187.03	187.175	186.77	186.84	1039574.0
2018-10-02 12:30:00	QQQ	ETF	186.84	186.98	186.32	186.4555	1258274.0

> showing 50 of 16,766 rows — these rows as CSV

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