PREVIEW / etf_30min / 2019-08-09

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-09.parquet
  size:    497 KB
  rows:    17,501

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-08-09 04:00:00	SPY	ETF	292.38	292.38	292.01	292.2	5617.0
2019-08-09 04:30:00	SPY	ETF	292.3	292.3	292.05	292.29	1970.0
2019-08-09 05:00:00	SPY	ETF	292.43	292.68	292.43	292.68	3659.0
2019-08-09 05:30:00	SPY	ETF	292.35	292.35	292.0	292.06	33677.0
2019-08-09 06:00:00	SPY	ETF	292.09	292.24	291.86	291.86	8819.0
2019-08-09 06:30:00	SPY	ETF	291.81	292.13	291.78	292.08	70158.0
2019-08-09 07:00:00	SPY	ETF	292.11	292.11	291.55	291.6	114391.0
2019-08-09 07:30:00	SPY	ETF	291.67	292.11	291.52	291.85	132826.0
2019-08-09 08:00:00	SPY	ETF	291.83	292.68	291.61	292.23	194216.0
2019-08-09 08:30:00	SPY	ETF	292.18	293.62	291.9	292.28	246592.0
2019-08-09 09:00:00	SPY	ETF	292.21	292.62	292.21	292.56	324782.0
2019-08-09 09:30:00	SPY	ETF	292.58	293.24	291.765	292.0	8602873.0
2019-08-09 10:00:00	SPY	ETF	292.0	292.3765	291.02	291.02	8120779.0
2019-08-09 10:30:00	SPY	ETF	291.01	291.55	290.48	291.34	6073470.0
2019-08-09 11:00:00	SPY	ETF	291.35	291.49	289.86	289.87	4595081.0
2019-08-09 11:30:00	SPY	ETF	289.87	290.59	289.65	289.9268	5053352.0
2019-08-09 12:00:00	SPY	ETF	289.93	290.4	289.7	289.987	2917376.0
2019-08-09 12:30:00	SPY	ETF	289.99	292.04	289.88	291.09	7660028.0
2019-08-09 13:00:00	SPY	ETF	291.08	292.11	291.01	291.96	4796389.0
2019-08-09 13:30:00	SPY	ETF	291.95	292.5	291.95	291.98	5142023.0
2019-08-09 14:00:00	SPY	ETF	291.97	292.31	291.77	292.15	3272783.0
2019-08-09 14:30:00	SPY	ETF	292.16	292.38	291.71	291.94	3423608.0
2019-08-09 15:00:00	SPY	ETF	291.935	292.89	291.825	292.47	4562197.0
2019-08-09 15:30:00	SPY	ETF	292.47	292.97	291.42	291.59	14840994.0
2019-08-09 16:00:00	SPY	ETF	291.57	293.4935	291.44	291.68	8438003.0
2019-08-09 16:30:00	SPY	ETF	291.67	292.12	291.62	292.05	1571302.0
2019-08-09 17:00:00	SPY	ETF	292.03	292.03	291.62	292.0	2150103.0
2019-08-09 17:30:00	SPY	ETF	292.0	292.0	291.93	292.0	11843.0
2019-08-09 18:00:00	SPY	ETF	291.95	292.02	291.95	291.95	34829.0
2019-08-09 18:30:00	SPY	ETF	291.95	291.95	291.93	291.95	4345.0
2019-08-09 19:00:00	SPY	ETF	291.95	291.95	291.85	291.93	11588.0
2019-08-09 19:30:00	SPY	ETF	291.93	291.94	291.85	291.93	13610.0
2019-08-09 04:00:00	QQQ	ETF	187.28	187.28	186.93	187.1	17155.0
2019-08-09 04:30:00	QQQ	ETF	187.14	187.23	186.95	187.14	7500.0
2019-08-09 05:00:00	QQQ	ETF	187.14	187.35	187.12	187.18	14181.0
2019-08-09 05:30:00	QQQ	ETF	187.13	187.13	186.9	186.91	9800.0
2019-08-09 06:00:00	QQQ	ETF	186.95	187.04	186.8	186.8	9650.0
2019-08-09 06:30:00	QQQ	ETF	186.75	186.9	186.75	186.86	2958.0
2019-08-09 07:00:00	QQQ	ETF	186.87	186.91	186.5	186.65	115085.0
2019-08-09 07:30:00	QQQ	ETF	186.65	186.93	186.57	186.74	74873.0
2019-08-09 08:00:00	QQQ	ETF	186.69	188.26	186.52	187.0299	235872.0
2019-08-09 08:30:00	QQQ	ETF	187.01	187.17	186.82	187.1	56048.0
2019-08-09 09:00:00	QQQ	ETF	187.1	187.36	187.1	187.31	108140.0
2019-08-09 09:30:00	QQQ	ETF	187.32	188.0	186.62	186.93	3445762.0
2019-08-09 10:00:00	QQQ	ETF	186.94	187.25	186.12	186.2	3092288.0
2019-08-09 10:30:00	QQQ	ETF	186.2	186.6303	185.69	186.49	2360236.0
2019-08-09 11:00:00	QQQ	ETF	186.48	186.58	185.22	185.23	1705287.0
2019-08-09 11:30:00	QQQ	ETF	185.23	185.73	185.03	185.23	2025327.0
2019-08-09 12:00:00	QQQ	ETF	185.21	185.62	185.12	185.39	1135986.0
2019-08-09 12:30:00	QQQ	ETF	185.36	186.73	185.3	186.23	2550213.0

> showing 50 of 17,501 rows — these rows as CSV

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