PREVIEW / etf_30min / 2021-12-23

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-12-23.parquet
  size:    649 KB
  rows:    25,055

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
2021-12-23 04:00:00	SPY	ETF	468.2	468.71	468.2	468.25	6487.0
2021-12-23 04:30:00	SPY	ETF	468.24	468.4	468.21	468.34	5375.0
2021-12-23 05:00:00	SPY	ETF	468.37	468.61	468.35	468.54	2709.0
2021-12-23 05:30:00	SPY	ETF	468.55	468.89	468.51	468.87	11565.0
2021-12-23 06:00:00	SPY	ETF	468.9	469.07	468.8	468.94	15257.0
2021-12-23 06:30:00	SPY	ETF	469.08	469.08	468.87	469.06	5561.0
2021-12-23 07:00:00	SPY	ETF	469.01	469.32	468.92	468.98	57847.0
2021-12-23 07:30:00	SPY	ETF	468.96	469.24	468.96	469.23	32994.0
2021-12-23 08:00:00	SPY	ETF	469.2501	469.45	468.2	468.87	199558.0
2021-12-23 08:30:00	SPY	ETF	468.92	469.03	468.26	468.77	146986.0
2021-12-23 09:00:00	SPY	ETF	468.82	469.12	468.72	468.75	216142.0
2021-12-23 09:30:00	SPY	ETF	468.75	470.66	468.64	470.17	5747972.0
2021-12-23 10:00:00	SPY	ETF	470.17	470.84	470.0	470.63	2722649.0
2021-12-23 10:30:00	SPY	ETF	470.64	471.1198	470.3	471.09	2123113.0
2021-12-23 11:00:00	SPY	ETF	471.08	471.47	470.79	470.92	2674784.0
2021-12-23 11:30:00	SPY	ETF	470.92	471.32	470.91	471.3	1223036.0
2021-12-23 12:00:00	SPY	ETF	471.31	471.31	470.8865	470.94	1234094.0
2021-12-23 12:30:00	SPY	ETF	470.9372	471.15	470.9	471.075	1151221.0
2021-12-23 13:00:00	SPY	ETF	471.07	471.24	470.72	471.21	1134969.0
2021-12-23 13:30:00	SPY	ETF	471.2123	471.42	471.01	471.2999	887355.0
2021-12-23 14:00:00	SPY	ETF	471.31	471.68	471.18	471.56	1365669.0
2021-12-23 14:30:00	SPY	ETF	471.546	471.82	471.4	471.79	1504187.0
2021-12-23 15:00:00	SPY	ETF	471.79	471.82	471.2775	471.435	2584709.0
2021-12-23 15:30:00	SPY	ETF	471.44	472.19	470.54	470.58	10086742.0
2021-12-23 16:00:00	SPY	ETF	470.59	471.5774	470.49	470.71	4119328.0
2021-12-23 16:30:00	SPY	ETF	470.72	470.84	470.7	470.81	67979.0
2021-12-23 17:00:00	SPY	ETF	470.83	470.83	470.65	470.78	17453.0
2021-12-23 17:30:00	SPY	ETF	470.78	470.78	470.6801	470.72	19549.0
2021-12-23 18:00:00	SPY	ETF	470.75	470.8	470.68	470.8	25406.0
2021-12-23 18:30:00	SPY	ETF	470.6	470.72	470.56	470.63	13721.0
2021-12-23 19:00:00	SPY	ETF	470.59	470.62	470.55	470.62	2848.0
2021-12-23 19:30:00	SPY	ETF	470.5901	470.63	470.51	470.51	9727.0
2021-12-23 04:00:00	QQQ	ETF	394.1	394.28	393.92	394.06	11003.0
2021-12-23 04:30:00	QQQ	ETF	394.07	394.26	394.04	394.22	6267.0
2021-12-23 05:00:00	QQQ	ETF	394.12	394.51	394.12	394.41	3550.0
2021-12-23 05:30:00	QQQ	ETF	394.43	394.73	394.37	394.73	8971.0
2021-12-23 06:00:00	QQQ	ETF	394.67	394.69	394.5	394.68	14641.0
2021-12-23 06:30:00	QQQ	ETF	394.78	394.79	394.62	394.75	4321.0
2021-12-23 07:00:00	QQQ	ETF	394.8	395.01	394.65	394.67	48512.0
2021-12-23 07:30:00	QQQ	ETF	394.76	395.01	394.75	395.0	61024.0
2021-12-23 08:00:00	QQQ	ETF	394.8399	395.17	393.99	394.75	124801.0
2021-12-23 08:30:00	QQQ	ETF	394.53	394.73	394.0	394.55	109989.0
2021-12-23 09:00:00	QQQ	ETF	394.62	394.85	394.31	394.34	76779.0
2021-12-23 09:30:00	QQQ	ETF	394.34	395.72	394.14	395.54	3656040.0
2021-12-23 10:00:00	QQQ	ETF	395.54	396.4499	395.29	396.2499	1989690.0
2021-12-23 10:30:00	QQQ	ETF	396.26	396.96	395.7783	396.93	1390570.0
2021-12-23 11:00:00	QQQ	ETF	396.95	397.43	396.83	396.99	1661700.0
2021-12-23 11:30:00	QQQ	ETF	397.0001	397.61	397.0	397.5712	1088793.0
2021-12-23 12:00:00	QQQ	ETF	397.58	397.65	397.1335	397.1988	944036.0
2021-12-23 12:30:00	QQQ	ETF	397.2155	397.65	397.09	397.5746	899840.0

> showing 50 of 25,055 rows — these rows as CSV

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