PREVIEW / etf_30min / 2021-08-23

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-23.parquet
  size:    636 KB
  rows:    23,813

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-08-23 04:00:00	SPY	ETF	444.02	444.61	444.02	444.42	16570.0
2021-08-23 04:30:00	SPY	ETF	444.55	444.69	444.49	444.69	7545.0
2021-08-23 05:00:00	SPY	ETF	444.54	444.67	444.54	444.61	5450.0
2021-08-23 05:30:00	SPY	ETF	444.56	444.86	444.55	444.83	5970.0
2021-08-23 06:00:00	SPY	ETF	444.89	444.89	444.73	444.84	3500.0
2021-08-23 06:30:00	SPY	ETF	444.86	444.92	444.74	444.9	7275.0
2021-08-23 07:00:00	SPY	ETF	444.88	445.0	444.7	444.85	35178.0
2021-08-23 07:30:00	SPY	ETF	444.85	445.13	444.85	444.9	104715.0
2021-08-23 08:00:00	SPY	ETF	444.95	445.06	443.582	444.94	101034.0
2021-08-23 08:30:00	SPY	ETF	444.9404	444.99	444.83	444.91	73920.0
2021-08-23 09:00:00	SPY	ETF	444.931	445.17	444.75	445.17	269758.0
2021-08-23 09:30:00	SPY	ETF	445.16	446.38	445.14	446.335	5965851.0
2021-08-23 10:00:00	SPY	ETF	446.35	447.2	446.17	446.87	4023447.0
2021-08-23 10:30:00	SPY	ETF	446.87	447.319	446.71	447.25	2395584.0
2021-08-23 11:00:00	SPY	ETF	447.245	447.74	447.235	447.48	2229473.0
2021-08-23 11:30:00	SPY	ETF	447.485	447.86	447.485	447.74	1674268.0
2021-08-23 12:00:00	SPY	ETF	447.75	447.94	447.74	447.84	1163749.0
2021-08-23 12:30:00	SPY	ETF	447.85	448.165	447.67	448.15	2877957.0
2021-08-23 13:00:00	SPY	ETF	448.16	448.23	447.58	447.695	1978646.0
2021-08-23 13:30:00	SPY	ETF	447.71	447.87	447.43	447.72	1829631.0
2021-08-23 14:00:00	SPY	ETF	447.72	447.99	447.64	447.75	2049451.0
2021-08-23 14:30:00	SPY	ETF	447.75	448.11	447.71	448.04	1441517.0
2021-08-23 15:00:00	SPY	ETF	448.03	448.07	447.63	447.835	2353923.0
2021-08-23 15:30:00	SPY	ETF	447.84	448.04	447.13	447.25	7965262.0
2021-08-23 16:00:00	SPY	ETF	447.25	447.71	447.15	447.64	1878536.0
2021-08-23 16:30:00	SPY	ETF	447.65	447.79	447.63	447.77	72746.0
2021-08-23 17:00:00	SPY	ETF	447.7	447.74	447.67	447.74	18735.0
2021-08-23 17:30:00	SPY	ETF	447.73	447.8	447.7	447.75	12874.0
2021-08-23 18:00:00	SPY	ETF	447.74	447.98	447.67	447.95	44886.0
2021-08-23 18:30:00	SPY	ETF	447.26	447.99	447.26	447.88	8354.0
2021-08-23 19:00:00	SPY	ETF	447.87	447.95	447.86	447.93	5466.0
2021-08-23 19:30:00	SPY	ETF	447.92	448.02	447.89	448.0	25252.0
2021-08-23 04:00:00	QQQ	ETF	368.2	369.03	368.2	368.99	53050.0
2021-08-23 04:30:00	QQQ	ETF	368.9	369.12	368.9	369.05	60711.0
2021-08-23 05:00:00	QQQ	ETF	369.09	369.11	368.81	368.86	23421.0
2021-08-23 05:30:00	QQQ	ETF	368.79	368.93	368.72	368.88	16352.0
2021-08-23 06:00:00	QQQ	ETF	368.84	368.86	368.72	368.85	27041.0
2021-08-23 06:30:00	QQQ	ETF	368.83	368.9	368.75	368.88	7418.0
2021-08-23 07:00:00	QQQ	ETF	368.87	369.02	368.79	369.01	121675.0
2021-08-23 07:30:00	QQQ	ETF	369.02	369.11	368.9	368.94	133987.0
2021-08-23 08:00:00	QQQ	ETF	368.91	369.49	368.005	368.94	90376.0
2021-08-23 08:30:00	QQQ	ETF	368.96	368.97	368.58	368.76	127884.0
2021-08-23 09:00:00	QQQ	ETF	368.76	368.96	368.69	368.79	166306.0
2021-08-23 09:30:00	QQQ	ETF	368.8	370.81	368.78	370.68	3905306.0
2021-08-23 10:00:00	QQQ	ETF	370.69	371.91	370.435	371.6	2458894.0
2021-08-23 10:30:00	QQQ	ETF	371.62	372.36	371.51	372.325	2246882.0
2021-08-23 11:00:00	QQQ	ETF	372.32	372.48	372.07	372.33	1392333.0
2021-08-23 11:30:00	QQQ	ETF	372.36	373.35	372.35	373.2812	1910935.0
2021-08-23 12:00:00	QQQ	ETF	373.28	373.39	372.9901	373.3113	1281640.0
2021-08-23 12:30:00	QQQ	ETF	373.31	373.61	373.1799	373.58	1322793.0

> showing 50 of 23,813 rows — these rows as CSV

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