PREVIEW / etf_30min / 2019-10-02

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-02.parquet
  size:    535 KB
  rows:    18,550

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
2019-10-02 04:00:00	SPY	ETF	292.12	292.12	291.74	291.99	27120.0
2019-10-02 04:30:00	SPY	ETF	291.84	291.91	291.39	291.62	22641.0
2019-10-02 05:00:00	SPY	ETF	291.6	291.78	291.13	291.17	40888.0
2019-10-02 05:30:00	SPY	ETF	291.21	291.22	290.9	291.22	67320.0
2019-10-02 06:00:00	SPY	ETF	291.26	291.36	290.97	291.16	26816.0
2019-10-02 06:30:00	SPY	ETF	291.23	291.35	291.05	291.08	76900.0
2019-10-02 07:00:00	SPY	ETF	291.08	291.54	291.08	291.53	128357.0
2019-10-02 07:30:00	SPY	ETF	291.54	291.8	291.47	291.71	124969.0
2019-10-02 08:00:00	SPY	ETF	291.73	293.9	291.12	291.89	332110.0
2019-10-02 08:30:00	SPY	ETF	291.88	291.93	291.2	291.22	246744.0
2019-10-02 09:00:00	SPY	ETF	291.2002	291.57	291.1	291.48	490510.0
2019-10-02 09:30:00	SPY	ETF	291.5	291.51	289.32	289.7891	12406618.0
2019-10-02 10:00:00	SPY	ETF	289.785	290.04	289.1	289.3	8818311.0
2019-10-02 10:30:00	SPY	ETF	289.29	289.295	287.98	288.39	12820762.0
2019-10-02 11:00:00	SPY	ETF	288.4	288.88	288.09	288.21	6871241.0
2019-10-02 11:30:00	SPY	ETF	288.22	288.35	287.46	288.22	7673165.0
2019-10-02 12:00:00	SPY	ETF	288.21	288.2539	287.39	287.65	7444886.0
2019-10-02 12:30:00	SPY	ETF	287.63	287.71	286.64	286.97	6903293.0
2019-10-02 13:00:00	SPY	ETF	286.97	287.79	286.7506	287.63	5402903.0
2019-10-02 13:30:00	SPY	ETF	287.63	287.72	287.03	287.32	4089741.0
2019-10-02 14:00:00	SPY	ETF	287.31	288.13	287.05	287.882	5801431.0
2019-10-02 14:30:00	SPY	ETF	287.885	288.56	287.68	288.48	7234482.0
2019-10-02 15:00:00	SPY	ETF	288.48	288.95	287.98	288.42	7714135.0
2019-10-02 15:30:00	SPY	ETF	288.42	288.77	287.61	288.04	16469082.0
2019-10-02 16:00:00	SPY	ETF	288.04	288.18	287.16	287.28	9616601.0
2019-10-02 16:30:00	SPY	ETF	287.27	288.06	287.2	287.64	461362.0
2019-10-02 17:00:00	SPY	ETF	287.65	288.06	287.64	287.75	1154110.0
2019-10-02 17:30:00	SPY	ETF	287.76	287.83	287.75	287.79	67454.0
2019-10-02 18:00:00	SPY	ETF	287.79	287.8	287.54	287.55	79346.0
2019-10-02 18:30:00	SPY	ETF	287.54	287.95	287.51	287.92	91532.0
2019-10-02 19:00:00	SPY	ETF	287.94	288.3	287.86	288.23	89797.0
2019-10-02 19:30:00	SPY	ETF	288.2	288.26	287.81	287.88	52241.0
2019-10-02 04:00:00	QQQ	ETF	186.3	186.42	186.13	186.4	58900.0
2019-10-02 04:30:00	QQQ	ETF	186.39	186.39	185.9	186.02	56996.0
2019-10-02 05:00:00	QQQ	ETF	185.97	186.21	185.74	185.78	32161.0
2019-10-02 05:30:00	QQQ	ETF	185.75	185.8	185.54	185.79	24760.0
2019-10-02 06:00:00	QQQ	ETF	185.81	185.85	185.62	185.71	21400.0
2019-10-02 06:30:00	QQQ	ETF	185.77	185.87	185.71	185.72	8100.0
2019-10-02 07:00:00	QQQ	ETF	185.71	186.06	185.71	186.02	37387.0
2019-10-02 07:30:00	QQQ	ETF	186.06	186.19	185.98	186.16	63793.0
2019-10-02 08:00:00	QQQ	ETF	186.03	187.42	185.71	186.24	126149.0
2019-10-02 08:30:00	QQQ	ETF	186.24	186.28	185.7	185.74	131825.0
2019-10-02 09:00:00	QQQ	ETF	185.75	186.09	185.65	186.04	274426.0
2019-10-02 09:30:00	QQQ	ETF	186.03	186.03	184.57	184.925	5219435.0
2019-10-02 10:00:00	QQQ	ETF	184.93	185.2493	184.34	184.76	3160277.0
2019-10-02 10:30:00	QQQ	ETF	184.76	184.76	183.79	184.15	5102811.0
2019-10-02 11:00:00	QQQ	ETF	184.14	184.47	183.8	183.925	2372610.0
2019-10-02 11:30:00	QQQ	ETF	183.935	184.06	183.5	183.925	3122889.0
2019-10-02 12:00:00	QQQ	ETF	183.92	183.95	183.42	183.625	1485151.0
2019-10-02 12:30:00	QQQ	ETF	183.63	183.69	183.02	183.239	2256158.0

> showing 50 of 18,550 rows — these rows as CSV

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