PREVIEW / etf_30min / 2020-05-22

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-22.parquet
  size:    524 KB
  rows:    19,522

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-05-22 04:00:00	SPY	ETF	291.45	291.84	291.2	291.52	51790.0
2020-05-22 04:30:00	SPY	ETF	291.6	292.58	291.6	292.52	28319.0
2020-05-22 05:00:00	SPY	ETF	292.62	293.04	292.5	292.79	18778.0
2020-05-22 05:30:00	SPY	ETF	292.87	292.87	292.28	292.33	70305.0
2020-05-22 06:00:00	SPY	ETF	292.38	293.25	292.37	293.02	105544.0
2020-05-22 06:30:00	SPY	ETF	292.98	293.21	292.84	293.04	67200.0
2020-05-22 07:00:00	SPY	ETF	293.03	293.71	293.01	293.25	276970.0
2020-05-22 07:30:00	SPY	ETF	293.23	294.64	293.15	294.45	376792.0
2020-05-22 08:00:00	SPY	ETF	294.5	294.92	291.0	294.39	501084.0
2020-05-22 08:30:00	SPY	ETF	294.36	294.62	294.16	294.41	137633.0
2020-05-22 09:00:00	SPY	ETF	294.39	294.92	294.3099	294.55	229226.0
2020-05-22 09:30:00	SPY	ETF	294.57	294.85	293.37	294.28	6781708.0
2020-05-22 10:00:00	SPY	ETF	294.28	294.37	293.22	294.36	5854023.0
2020-05-22 10:30:00	SPY	ETF	294.36	294.53	293.35	293.46	3928951.0
2020-05-22 11:00:00	SPY	ETF	293.43	294.65	293.28	293.72	3781171.0
2020-05-22 11:30:00	SPY	ETF	293.72	294.19	293.52	293.975	2171341.0
2020-05-22 12:00:00	SPY	ETF	293.975	294.22	293.667	294.01	2033416.0
2020-05-22 12:30:00	SPY	ETF	294.03	294.73	294.02	294.43	2385863.0
2020-05-22 13:00:00	SPY	ETF	294.42	294.83	294.3	294.68	2886143.0
2020-05-22 13:30:00	SPY	ETF	294.655	294.8248	294.36	294.75	2156984.0
2020-05-22 14:00:00	SPY	ETF	294.76	295.36	294.715	295.14	2692468.0
2020-05-22 14:30:00	SPY	ETF	295.14	295.45	294.77	295.04	2799048.0
2020-05-22 15:00:00	SPY	ETF	295.03	295.2799	294.25	294.56	4573698.0
2020-05-22 15:30:00	SPY	ETF	294.58	295.63	294.44	295.42	11298997.0
2020-05-22 16:00:00	SPY	ETF	295.41	295.76	295.32	295.65	6135634.0
2020-05-22 16:30:00	SPY	ETF	295.65	296.1	295.44	295.99	596875.0
2020-05-22 17:00:00	SPY	ETF	295.95	296.07	295.46	296.07	629326.0
2020-05-22 17:30:00	SPY	ETF	295.98	296.02	295.44	295.83	59266.0
2020-05-22 18:00:00	SPY	ETF	295.85	296.1	295.81	296.02	57846.0
2020-05-22 18:30:00	SPY	ETF	296.0	296.02	295.85	295.91	17738.0
2020-05-22 19:00:00	SPY	ETF	295.9	295.97	295.76	295.8	40517.0
2020-05-22 19:30:00	SPY	ETF	295.87	295.87	295.35	295.6	151830.0
2020-05-22 04:00:00	QQQ	ETF	226.34	226.38	225.98	226.2	30191.0
2020-05-22 04:30:00	QQQ	ETF	226.45	226.96	226.45	226.96	7730.0
2020-05-22 05:00:00	QQQ	ETF	226.97	227.27	226.85	227.03	11401.0
2020-05-22 05:30:00	QQQ	ETF	226.99	226.99	226.73	226.8	9090.0
2020-05-22 06:00:00	QQQ	ETF	226.74	227.31	226.74	227.15	24930.0
2020-05-22 06:30:00	QQQ	ETF	227.32	227.43	227.07	227.18	12296.0
2020-05-22 07:00:00	QQQ	ETF	227.21	227.81	227.21	227.53	93217.0
2020-05-22 07:30:00	QQQ	ETF	227.51	228.43	227.48	228.32	141087.0
2020-05-22 08:00:00	QQQ	ETF	227.5899	228.59	226.05	228.24	240773.0
2020-05-22 08:30:00	QQQ	ETF	228.19	228.43	227.99	228.24	122548.0
2020-05-22 09:00:00	QQQ	ETF	228.21	228.71	228.2	228.42	62455.0
2020-05-22 09:30:00	QQQ	ETF	228.44	229.42	227.5	229.29	4255750.0
2020-05-22 10:00:00	QQQ	ETF	229.32	229.355	228.0	228.85	2421208.0
2020-05-22 10:30:00	QQQ	ETF	228.87	229.0	228.13	228.1923	1539753.0
2020-05-22 11:00:00	QQQ	ETF	228.16	228.52	227.915	228.21	1463567.0
2020-05-22 11:30:00	QQQ	ETF	228.21	228.6999	228.07	228.54	1277581.0
2020-05-22 12:00:00	QQQ	ETF	228.57	228.75	228.33	228.67	1000492.0
2020-05-22 12:30:00	QQQ	ETF	228.698	229.295	228.69	228.98	1417862.0

> showing 50 of 19,522 rows — these rows as CSV

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