PREVIEW / etf_30min / 2020-12-16

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-16.parquet
  size:    600 KB
  rows:    22,162

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-12-16 04:00:00	SPY	ETF	370.26	370.42	370.14	370.33	46921.0
2020-12-16 04:30:00	SPY	ETF	370.36	370.38	370.25	370.32	11583.0
2020-12-16 05:00:00	SPY	ETF	370.29	370.66	370.25	370.66	12449.0
2020-12-16 05:30:00	SPY	ETF	370.51	370.75	370.51	370.65	12103.0
2020-12-16 06:00:00	SPY	ETF	370.68	370.73	370.58	370.63	13545.0
2020-12-16 06:30:00	SPY	ETF	370.56	370.59	370.53	370.55	3687.0
2020-12-16 07:00:00	SPY	ETF	370.6	370.61	370.36	370.44	82314.0
2020-12-16 07:30:00	SPY	ETF	370.41	370.57	370.31	370.36	34753.0
2020-12-16 08:00:00	SPY	ETF	370.4	370.83	368.95	370.1	548509.0
2020-12-16 08:30:00	SPY	ETF	370.07	370.2	369.74	370.04	386358.0
2020-12-16 09:00:00	SPY	ETF	370.02	370.05	369.66	369.85	272061.0
2020-12-16 09:30:00	SPY	ETF	369.82	369.89	368.8676	369.54	7884842.0
2020-12-16 10:00:00	SPY	ETF	369.55	370.07	369.31	370.0	5577976.0
2020-12-16 10:30:00	SPY	ETF	369.99	370.22	369.66	369.77	1942513.0
2020-12-16 11:00:00	SPY	ETF	369.775	370.2	369.64	370.175	2389735.0
2020-12-16 11:30:00	SPY	ETF	370.18	370.3716	370.07	370.22	1926325.0
2020-12-16 12:00:00	SPY	ETF	370.225	370.2801	369.79	369.9162	2079436.0
2020-12-16 12:30:00	SPY	ETF	369.91	370.02	369.3831	370.018	2531746.0
2020-12-16 13:00:00	SPY	ETF	370.01	370.01	369.58	369.72	859002.0
2020-12-16 13:30:00	SPY	ETF	369.73	369.93	369.71	369.8324	1416808.0
2020-12-16 14:00:00	SPY	ETF	369.84	370.19	369.06	369.35	3884623.0
2020-12-16 14:30:00	SPY	ETF	369.3522	370.78	369.3302	370.7222	3888280.0
2020-12-16 15:00:00	SPY	ETF	370.73	370.96	370.19	370.77	3601612.0
2020-12-16 15:30:00	SPY	ETF	370.7632	371.16	369.93	370.14	9578702.0
2020-12-16 16:00:00	SPY	ETF	370.14	370.34	369.99	370.06	6849510.0
2020-12-16 16:30:00	SPY	ETF	370.08	370.17	369.9	370.13	942770.0
2020-12-16 17:00:00	SPY	ETF	370.15	370.17	370.01	370.05	31111.0
2020-12-16 17:30:00	SPY	ETF	370.03	370.25	369.92	370.17	68396.0
2020-12-16 18:00:00	SPY	ETF	370.17	370.41	370.13	370.35	97913.0
2020-12-16 18:30:00	SPY	ETF	370.3	370.4	370.25	370.33	8115.0
2020-12-16 19:00:00	SPY	ETF	370.33	370.33	370.0	370.1	35207.0
2020-12-16 19:30:00	SPY	ETF	370.17	370.38	370.17	370.33	17836.0
2020-12-16 04:00:00	QQQ	ETF	308.26	308.4	308.2	308.25	19056.0
2020-12-16 04:30:00	QQQ	ETF	308.31	308.32	308.18	308.22	6996.0
2020-12-16 05:00:00	QQQ	ETF	308.17	308.35	308.13	308.34	2700.0
2020-12-16 05:30:00	QQQ	ETF	308.24	308.26	308.09	308.21	8947.0
2020-12-16 06:00:00	QQQ	ETF	308.2	308.22	307.86	307.95	17118.0
2020-12-16 06:30:00	QQQ	ETF	307.98	307.98	307.81	307.96	11150.0
2020-12-16 07:00:00	QQQ	ETF	307.95	307.95	307.64	307.81	33962.0
2020-12-16 07:30:00	QQQ	ETF	307.83	307.93	307.71	307.75	30315.0
2020-12-16 08:00:00	QQQ	ETF	307.7101	308.35	307.29	307.65	152993.0
2020-12-16 08:30:00	QQQ	ETF	307.55	308.02	307.3002	307.91	167435.0
2020-12-16 09:00:00	QQQ	ETF	307.91	307.91	307.58	307.74	105161.0
2020-12-16 09:30:00	QQQ	ETF	307.72	307.895	306.621	307.305	2158834.0
2020-12-16 10:00:00	QQQ	ETF	307.32	307.89	306.67	307.6	1886794.0
2020-12-16 10:30:00	QQQ	ETF	307.6	308.14	307.56	307.87	1267513.0
2020-12-16 11:00:00	QQQ	ETF	307.88	308.3	307.64	308.14	1049678.0
2020-12-16 11:30:00	QQQ	ETF	308.12	308.71	308.07	308.62	1108717.0
2020-12-16 12:00:00	QQQ	ETF	308.65	308.78	308.34	308.4414	738543.0
2020-12-16 12:30:00	QQQ	ETF	308.44	308.51	308.0	308.45	571345.0

> showing 50 of 22,162 rows — these rows as CSV

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