PREVIEW / etf_30min / 2020-08-18

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-18.parquet
  size:    552 KB
  rows:    20,392

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
2020-08-18 04:00:00	SPY	ETF	338.0	338.05	337.7	338.05	4445.0
2020-08-18 04:30:00	SPY	ETF	338.09	338.22	337.97	338.1	3589.0
2020-08-18 05:00:00	SPY	ETF	338.12	338.58	338.12	338.45	2581.0
2020-08-18 05:30:00	SPY	ETF	338.44	338.58	338.41	338.55	15310.0
2020-08-18 06:00:00	SPY	ETF	338.53	338.7	338.5	338.59	10161.0
2020-08-18 06:30:00	SPY	ETF	338.66	338.93	338.58	338.85	47538.0
2020-08-18 07:00:00	SPY	ETF	338.81	338.94	338.52	338.59	58123.0
2020-08-18 07:30:00	SPY	ETF	338.61	338.63	338.34	338.39	64363.0
2020-08-18 08:00:00	SPY	ETF	338.39	338.9496	337.86	338.58	268554.0
2020-08-18 08:30:00	SPY	ETF	338.58	338.67	338.45	338.59	117547.0
2020-08-18 09:00:00	SPY	ETF	338.56	338.66	338.16	338.33	133347.0
2020-08-18 09:30:00	SPY	ETF	338.34	339.07	338.18	338.4	4311212.0
2020-08-18 10:00:00	SPY	ETF	338.39	338.45	336.77	336.8	3543906.0
2020-08-18 10:30:00	SPY	ETF	336.8	337.78	336.61	337.77	3025417.0
2020-08-18 11:00:00	SPY	ETF	337.77	338.311	337.67	338.2385	3092660.0
2020-08-18 11:30:00	SPY	ETF	338.24	338.46	338.24	338.38	1255155.0
2020-08-18 12:00:00	SPY	ETF	338.38	338.55	338.24	338.49	1367928.0
2020-08-18 12:30:00	SPY	ETF	338.49	338.8	338.485	338.72	1638932.0
2020-08-18 13:00:00	SPY	ETF	338.71	338.89	338.49	338.668	1224020.0
2020-08-18 13:30:00	SPY	ETF	338.66	338.94	338.65	338.73	1053241.0
2020-08-18 14:00:00	SPY	ETF	338.74	338.875	338.525	338.78	2040575.0
2020-08-18 14:30:00	SPY	ETF	338.79	338.99	338.7	338.865	1650968.0
2020-08-18 15:00:00	SPY	ETF	338.88	339.1	338.61	338.775	2761705.0
2020-08-18 15:30:00	SPY	ETF	338.77	338.93	338.28	338.62	6169167.0
2020-08-18 16:00:00	SPY	ETF	338.6	338.77	338.3683	338.66	3305898.0
2020-08-18 16:30:00	SPY	ETF	338.65	338.85	338.51	338.83	251398.0
2020-08-18 17:00:00	SPY	ETF	338.84	338.84	338.64	338.75	84338.0
2020-08-18 17:30:00	SPY	ETF	338.73	338.84	338.71	338.78	17823.0
2020-08-18 18:00:00	SPY	ETF	338.85	338.95	338.68	338.78	42617.0
2020-08-18 18:30:00	SPY	ETF	338.8	338.91	338.75	338.88	22548.0
2020-08-18 19:00:00	SPY	ETF	338.89	338.99	338.85	338.95	29280.0
2020-08-18 19:30:00	SPY	ETF	338.94	338.97	338.84	338.92	24964.0
2020-08-18 04:00:00	QQQ	ETF	275.26	275.55	275.26	275.42	22395.0
2020-08-18 04:30:00	QQQ	ETF	275.46	275.55	275.35	275.55	10710.0
2020-08-18 05:00:00	QQQ	ETF	275.46	275.95	275.46	275.85	13551.0
2020-08-18 05:30:00	QQQ	ETF	276.0	276.29	276.0	276.26	7920.0
2020-08-18 06:00:00	QQQ	ETF	276.18	276.31	276.17	276.2	8524.0
2020-08-18 06:30:00	QQQ	ETF	276.26	276.44	276.19	276.38	9537.0
2020-08-18 07:00:00	QQQ	ETF	276.34	276.55	276.11	276.2	103761.0
2020-08-18 07:30:00	QQQ	ETF	276.2	276.29	276.06	276.1	61215.0
2020-08-18 08:00:00	QQQ	ETF	275.54	276.66	275.21	276.66	144315.0
2020-08-18 08:30:00	QQQ	ETF	276.62	276.78	276.46	276.5096	55637.0
2020-08-18 09:00:00	QQQ	ETF	276.478	276.64	276.23	276.4	154182.0
2020-08-18 09:30:00	QQQ	ETF	276.41	277.64	276.23	276.68	3268759.0
2020-08-18 10:00:00	QQQ	ETF	276.685	276.83	275.12	275.17	2151647.0
2020-08-18 10:30:00	QQQ	ETF	275.17	276.71	274.91	276.65	1917808.0
2020-08-18 11:00:00	QQQ	ETF	276.66	277.08	276.41	276.85	795927.0
2020-08-18 11:30:00	QQQ	ETF	276.86	277.13	276.7	277.02	599984.0
2020-08-18 12:00:00	QQQ	ETF	277.02	277.4001	276.95	277.3101	703441.0
2020-08-18 12:30:00	QQQ	ETF	277.33	277.73	277.2899	277.39	775251.0

> showing 50 of 20,392 rows — these rows as CSV

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