PREVIEW / etf_30min / 2020-12-29

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-29.parquet
  size:    603 KB
  rows:    22,435

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-29 04:00:00	SPY	ETF	373.86	374.03	373.79	373.91	10046.0
2020-12-29 04:30:00	SPY	ETF	373.95	373.96	373.91	373.93	6224.0
2020-12-29 05:00:00	SPY	ETF	373.86	373.86	373.86	373.86	1226.0
2020-12-29 05:30:00	SPY	ETF	373.9	373.95	373.87	373.95	1107.0
2020-12-29 06:00:00	SPY	ETF	373.91	373.91	373.66	373.72	9716.0
2020-12-29 06:30:00	SPY	ETF	373.74	373.75	373.67	373.71	7893.0
2020-12-29 07:00:00	SPY	ETF	373.79	373.9	373.79	373.85	12189.0
2020-12-29 07:30:00	SPY	ETF	373.89	373.89	373.61	373.69	19082.0
2020-12-29 08:00:00	SPY	ETF	373.85	374.07	373.45	373.49	63976.0
2020-12-29 08:30:00	SPY	ETF	373.49	373.64	373.4	373.64	81703.0
2020-12-29 09:00:00	SPY	ETF	373.641	373.86	373.61	373.82	264673.0
2020-12-29 09:30:00	SPY	ETF	373.81	374.0	372.17	372.53	5363212.0
2020-12-29 10:00:00	SPY	ETF	372.52	372.89	371.775	372.31	4663376.0
2020-12-29 10:30:00	SPY	ETF	372.33	372.82	372.22	372.74	2697091.0
2020-12-29 11:00:00	SPY	ETF	372.73	372.74	371.945	372.63	2730288.0
2020-12-29 11:30:00	SPY	ETF	372.65	372.86	372.37	372.59	1849766.0
2020-12-29 12:00:00	SPY	ETF	372.59	372.63	371.76	372.085	3198389.0
2020-12-29 12:30:00	SPY	ETF	372.085	372.085	370.83	371.55	4335614.0
2020-12-29 13:00:00	SPY	ETF	371.55	371.73	371.14	371.66	3644969.0
2020-12-29 13:30:00	SPY	ETF	371.66	371.83	371.37	371.72	1431424.0
2020-12-29 14:00:00	SPY	ETF	371.7189	371.74	370.94	371.01	3011298.0
2020-12-29 14:30:00	SPY	ETF	371.0	371.47	370.83	371.275	2491054.0
2020-12-29 15:00:00	SPY	ETF	371.27	371.97	371.04	371.88	2460763.0
2020-12-29 15:30:00	SPY	ETF	371.89	371.94	371.05	371.48	7228502.0
2020-12-29 16:00:00	SPY	ETF	371.47	371.89	371.2	371.75	6329308.0
2020-12-29 16:30:00	SPY	ETF	371.75	371.85	371.46	371.76	328726.0
2020-12-29 17:00:00	SPY	ETF	371.71	371.71	371.53	371.56	33893.0
2020-12-29 17:30:00	SPY	ETF	371.56	371.7	371.56	371.7	16321.0
2020-12-29 18:00:00	SPY	ETF	371.7	371.96	371.31	371.49	98657.0
2020-12-29 18:30:00	SPY	ETF	371.48	371.75	371.48	371.66	21387.0
2020-12-29 19:00:00	SPY	ETF	371.48	371.5	371.05	371.46	43697.0
2020-12-29 19:30:00	SPY	ETF	371.47	371.55	371.27	371.33	27485.0
2020-12-29 04:00:00	QQQ	ETF	314.03	314.06	313.94	313.97	9406.0
2020-12-29 04:30:00	QQQ	ETF	313.99	314.04	313.93	313.96	6390.0
2020-12-29 05:00:00	QQQ	ETF	313.96	313.98	313.84	313.91	4567.0
2020-12-29 05:30:00	QQQ	ETF	313.88	313.99	313.82	313.94	5004.0
2020-12-29 06:00:00	QQQ	ETF	313.93	313.93	313.68	313.76	5956.0
2020-12-29 06:30:00	QQQ	ETF	313.78	313.82	313.74	313.8	2390.0
2020-12-29 07:00:00	QQQ	ETF	313.82	314.03	313.82	314.03	21457.0
2020-12-29 07:30:00	QQQ	ETF	314.0	314.1	313.91	313.96	22848.0
2020-12-29 08:00:00	QQQ	ETF	313.75	314.29	313.7204	314.0	65805.0
2020-12-29 08:30:00	QQQ	ETF	314.0	314.07	313.93	314.02	25355.0
2020-12-29 09:00:00	QQQ	ETF	314.07	314.1	313.85	314.08	120057.0
2020-12-29 09:30:00	QQQ	ETF	314.08	314.685	312.98	313.26	3476601.0
2020-12-29 10:00:00	QQQ	ETF	313.26	313.48	312.07	313.1	3376474.0
2020-12-29 10:30:00	QQQ	ETF	313.13	313.91	313.0001	313.77	1540310.0
2020-12-29 11:00:00	QQQ	ETF	313.77	313.97	312.89	313.6	1097752.0
2020-12-29 11:30:00	QQQ	ETF	313.61	313.84	313.05	313.32	653625.0
2020-12-29 12:00:00	QQQ	ETF	313.32	313.3295	312.31	312.85	958943.0
2020-12-29 12:30:00	QQQ	ETF	312.83	312.96	312.03	312.9511	1040521.0

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

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