PREVIEW / etf_30min / 2019-09-03

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-09-03.parquet
  size:    511 KB
  rows:    17,979

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-09-03 04:00:00	SPY	ETF	290.04	291.18	289.91	290.91	19652.0
2019-09-03 04:30:00	SPY	ETF	290.71	290.85	290.3	290.85	16131.0
2019-09-03 05:00:00	SPY	ETF	290.79	291.04	290.26	290.26	40383.0
2019-09-03 05:30:00	SPY	ETF	290.36	290.49	289.65	289.77	39849.0
2019-09-03 06:00:00	SPY	ETF	289.79	290.34	289.79	290.21	40636.0
2019-09-03 06:30:00	SPY	ETF	290.21	290.65	290.21	290.62	38877.0
2019-09-03 07:00:00	SPY	ETF	290.68	290.73	290.41	290.55	66514.0
2019-09-03 07:30:00	SPY	ETF	290.48	290.87	290.35	290.53	180162.0
2019-09-03 08:00:00	SPY	ETF	290.467	291.18	289.68	290.83	775937.0
2019-09-03 08:30:00	SPY	ETF	290.81	292.45	290.71	290.9	438574.0
2019-09-03 09:00:00	SPY	ETF	290.91	292.45	290.5	290.57	575867.0
2019-09-03 09:30:00	SPY	ETF	290.57	291.58	290.28	291.35	7211813.0
2019-09-03 10:00:00	SPY	ETF	291.16	291.365	289.27	290.25	11793481.0
2019-09-03 10:30:00	SPY	ETF	290.25	290.95	289.74	290.85	5054468.0
2019-09-03 11:00:00	SPY	ETF	290.85	290.85	289.79	290.43	4854278.0
2019-09-03 11:30:00	SPY	ETF	290.42	291.07	290.1	290.63	2689184.0
2019-09-03 12:00:00	SPY	ETF	290.625	290.81	290.33	290.5	1738389.0
2019-09-03 12:30:00	SPY	ETF	290.49	290.785	290.19	290.28	2435711.0
2019-09-03 13:00:00	SPY	ETF	290.28	290.55	290.0	290.2	2158920.0
2019-09-03 13:30:00	SPY	ETF	290.2	290.24	289.59	289.78	3121669.0
2019-09-03 14:00:00	SPY	ETF	289.77	290.12	289.72	290.0	1693032.0
2019-09-03 14:30:00	SPY	ETF	290.0	290.28	289.85	290.19	2502576.0
2019-09-03 15:00:00	SPY	ETF	290.1934	290.64	289.99	290.475	3516820.0
2019-09-03 15:30:00	SPY	ETF	290.48	291.06	290.36	290.77	6911181.0
2019-09-03 16:00:00	SPY	ETF	290.76	290.95	290.6	290.74	8590897.0
2019-09-03 16:30:00	SPY	ETF	290.74	290.77	290.55	290.63	1272029.0
2019-09-03 17:00:00	SPY	ETF	290.64	290.74	290.45	290.51	65004.0
2019-09-03 17:30:00	SPY	ETF	290.51	290.57	290.47	290.47	94554.0
2019-09-03 18:00:00	SPY	ETF	290.49	290.74	290.49	290.63	33952.0
2019-09-03 18:30:00	SPY	ETF	290.63	290.85	290.63	290.78	59447.0
2019-09-03 19:00:00	SPY	ETF	290.8	290.9	290.8	290.8	23186.0
2019-09-03 19:30:00	SPY	ETF	290.8	290.82	290.37	290.46	30267.0
2019-09-03 04:00:00	QQQ	ETF	185.54	186.5	185.41	186.19	39284.0
2019-09-03 04:30:00	QQQ	ETF	186.11	186.11	185.69	185.99	20779.0
2019-09-03 05:00:00	QQQ	ETF	186.02	186.22	185.7	185.71	25560.0
2019-09-03 05:30:00	QQQ	ETF	185.8	185.87	185.15	185.27	16326.0
2019-09-03 06:00:00	QQQ	ETF	185.22	185.78	185.22	185.7	17298.0
2019-09-03 06:30:00	QQQ	ETF	185.67	186.12	185.67	186.0	12985.0
2019-09-03 07:00:00	QQQ	ETF	186.15	186.19	185.91	186.08	42690.0
2019-09-03 07:30:00	QQQ	ETF	186.08	186.29	185.88	185.99	151381.0
2019-09-03 08:00:00	QQQ	ETF	185.96	186.4	185.47	186.26	66507.0
2019-09-03 08:30:00	QQQ	ETF	186.31	186.78	186.15	186.49	177706.0
2019-09-03 09:00:00	QQQ	ETF	186.47	186.77	186.13	186.24	134893.0
2019-09-03 09:30:00	QQQ	ETF	186.26	187.18	186.0	186.975	3191773.0
2019-09-03 10:00:00	QQQ	ETF	186.96	186.96	185.26	185.99	5193713.0
2019-09-03 10:30:00	QQQ	ETF	185.98	186.49	185.56	186.46	2079917.0
2019-09-03 11:00:00	QQQ	ETF	186.46	186.465	185.555	185.99	1478900.0
2019-09-03 11:30:00	QQQ	ETF	185.99	186.4599	185.75	186.13	985523.0
2019-09-03 12:00:00	QQQ	ETF	186.13	186.3	185.8739	185.958	753368.0
2019-09-03 12:30:00	QQQ	ETF	185.95	186.1457	185.67	185.77	961728.0

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

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