PREVIEW / etf_30min / 2020-02-20

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-20.parquet
  size:    547 KB
  rows:    19,353

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-02-20 04:00:00	SPY	ETF	337.59	338.27	337.59	337.96	8471.0
2020-02-20 04:30:00	SPY	ETF	338.0	338.3	338.0	338.25	5162.0
2020-02-20 05:00:00	SPY	ETF	338.28	338.28	337.99	338.01	1930.0
2020-02-20 05:30:00	SPY	ETF	338.08	338.08	337.83	337.98	11640.0
2020-02-20 06:00:00	SPY	ETF	337.95	338.11	337.86	338.02	11409.0
2020-02-20 06:30:00	SPY	ETF	338.0	338.11	337.61	337.61	46380.0
2020-02-20 07:00:00	SPY	ETF	337.66	337.95	337.61	337.81	49828.0
2020-02-20 07:30:00	SPY	ETF	337.78	337.86	337.7	337.85	92749.0
2020-02-20 08:00:00	SPY	ETF	337.94	338.8	337.61	337.74	127339.0
2020-02-20 08:30:00	SPY	ETF	337.75	338.03	337.3	337.6299	225878.0
2020-02-20 09:00:00	SPY	ETF	337.61	337.78	337.58	337.76	121447.0
2020-02-20 09:30:00	SPY	ETF	337.7423	338.42	337.55	338.25	4506297.0
2020-02-20 10:00:00	SPY	ETF	338.26	338.64	338.16	338.32	1974588.0
2020-02-20 10:30:00	SPY	ETF	338.32	338.64	338.29	338.385	2237350.0
2020-02-20 11:00:00	SPY	ETF	338.39	338.4	335.93	335.97	6729070.0
2020-02-20 11:30:00	SPY	ETF	335.97	336.18	333.6817	335.48	16792014.0
2020-02-20 12:00:00	SPY	ETF	335.465	335.59	334.58	334.97	7143281.0
2020-02-20 12:30:00	SPY	ETF	334.99	335.77	334.71	335.73	3265627.0
2020-02-20 13:00:00	SPY	ETF	335.71	336.63	335.5	336.21	5146407.0
2020-02-20 13:30:00	SPY	ETF	336.23	336.4099	335.71	335.85	2943586.0
2020-02-20 14:00:00	SPY	ETF	335.855	336.77	335.85	336.41	4110212.0
2020-02-20 14:30:00	SPY	ETF	336.39	337.13	336.39	336.7	2961256.0
2020-02-20 15:00:00	SPY	ETF	336.705	336.93	336.1	336.78	2792364.0
2020-02-20 15:30:00	SPY	ETF	336.8	337.25	336.57	336.98	6757004.0
2020-02-20 16:00:00	SPY	ETF	336.98	337.16	336.6	336.62	3296459.0
2020-02-20 16:30:00	SPY	ETF	336.61	336.95	336.5	336.51	896119.0
2020-02-20 17:00:00	SPY	ETF	336.5	336.65	336.35	336.41	106813.0
2020-02-20 17:30:00	SPY	ETF	336.43	336.48	336.38	336.45	27570.0
2020-02-20 18:00:00	SPY	ETF	336.49	336.65	335.85	335.85	125423.0
2020-02-20 18:30:00	SPY	ETF	336.0	336.06	335.22	335.36	69668.0
2020-02-20 19:00:00	SPY	ETF	335.38	336.15	335.36	335.9	41891.0
2020-02-20 19:30:00	SPY	ETF	335.97	336.28	335.85	336.0	33399.0
2020-02-20 04:00:00	QQQ	ETF	236.78	237.03	236.71	236.73	26883.0
2020-02-20 04:30:00	QQQ	ETF	236.79	237.01	236.79	237.01	7780.0
2020-02-20 05:00:00	QQQ	ETF	236.92	236.95	236.76	236.8	10700.0
2020-02-20 05:30:00	QQQ	ETF	236.78	236.81	236.66	236.81	12233.0
2020-02-20 06:00:00	QQQ	ETF	236.81	236.84	236.7	236.84	4476.0
2020-02-20 06:30:00	QQQ	ETF	236.78	236.86	236.46	236.46	15267.0
2020-02-20 07:00:00	QQQ	ETF	236.48	236.75	236.47	236.56	40053.0
2020-02-20 07:30:00	QQQ	ETF	236.54	236.65	236.54	236.65	32179.0
2020-02-20 08:00:00	QQQ	ETF	236.61	237.25	236.4696	236.5	117715.0
2020-02-20 08:30:00	QQQ	ETF	236.61	236.76	236.13	236.36	236285.0
2020-02-20 09:00:00	QQQ	ETF	236.37	236.5	236.31	236.46	61238.0
2020-02-20 09:30:00	QQQ	ETF	236.46	236.79	236.0	236.675	2290047.0
2020-02-20 10:00:00	QQQ	ETF	236.69	236.95	236.27	236.42	1341420.0
2020-02-20 10:30:00	QQQ	ETF	236.42	236.775	236.34	236.38	1419352.0
2020-02-20 11:00:00	QQQ	ETF	236.38	236.38	233.99	234.02	3730231.0
2020-02-20 11:30:00	QQQ	ETF	234.015	234.18	231.88	233.49	8081464.0
2020-02-20 12:00:00	QQQ	ETF	233.5	233.53	232.71	232.84	3208118.0
2020-02-20 12:30:00	QQQ	ETF	232.85	233.53	232.64	233.5	2636164.0

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

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