PREVIEW / etf_30min / 2021-07-26

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-26.parquet
  size:    609 KB
  rows:    23,438

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-07-26 04:00:00	SPY	ETF	438.65	438.65	437.08	437.3	10459.0
2021-07-26 04:30:00	SPY	ETF	437.42	438.15	437.42	437.99	15083.0
2021-07-26 05:00:00	SPY	ETF	438.27	438.53	438.21	438.49	6736.0
2021-07-26 05:30:00	SPY	ETF	438.62	438.93	438.56	438.79	6482.0
2021-07-26 06:00:00	SPY	ETF	438.9	439.13	438.9	438.91	19100.0
2021-07-26 06:30:00	SPY	ETF	438.9	438.99	438.55	438.55	8553.0
2021-07-26 07:00:00	SPY	ETF	438.55	438.87	438.55	438.74	69103.0
2021-07-26 07:30:00	SPY	ETF	438.76	439.34	438.76	439.11	149334.0
2021-07-26 08:00:00	SPY	ETF	438.6801	439.27	438.0	439.15	102146.0
2021-07-26 08:30:00	SPY	ETF	439.11	439.11	438.59	438.71	102745.0
2021-07-26 09:00:00	SPY	ETF	438.7	439.41	438.6	439.31	207285.0
2021-07-26 09:30:00	SPY	ETF	439.31	440.24	439.27	439.98	4411310.0
2021-07-26 10:00:00	SPY	ETF	439.97	440.07	439.38	439.425	2749061.0
2021-07-26 10:30:00	SPY	ETF	439.42	439.94	439.26	439.65	2260090.0
2021-07-26 11:00:00	SPY	ETF	439.65	440.475	439.405	440.425	2217569.0
2021-07-26 11:30:00	SPY	ETF	440.43	440.75	440.35	440.705	1544368.0
2021-07-26 12:00:00	SPY	ETF	440.71	440.83	440.33	440.37	1487245.0
2021-07-26 12:30:00	SPY	ETF	440.36	440.3901	439.94	440.18	1340988.0
2021-07-26 13:00:00	SPY	ETF	440.1899	440.695	440.18	440.45	1326579.0
2021-07-26 13:30:00	SPY	ETF	440.445	440.495	440.18	440.33	792099.0
2021-07-26 14:00:00	SPY	ETF	440.33	440.54	440.18	440.465	1656911.0
2021-07-26 14:30:00	SPY	ETF	440.47	440.68	440.425	440.6143	1480466.0
2021-07-26 15:00:00	SPY	ETF	440.61	440.845	440.5601	440.82	2377776.0
2021-07-26 15:30:00	SPY	ETF	440.8201	441.03	440.45	440.99	5246757.0
2021-07-26 16:00:00	SPY	ETF	440.98	441.14	440.94	441.06	1540123.0
2021-07-26 16:30:00	SPY	ETF	441.09	441.16	440.99	441.04	157000.0
2021-07-26 17:00:00	SPY	ETF	441.01	441.03	440.96	441.0	13789.0
2021-07-26 17:30:00	SPY	ETF	440.99	441.15	440.96	441.15	13710.0
2021-07-26 18:00:00	SPY	ETF	441.11	441.12	440.87	440.88	41317.0
2021-07-26 18:30:00	SPY	ETF	441.02	441.02	440.85	440.9	8078.0
2021-07-26 19:00:00	SPY	ETF	440.9	440.99	440.88	440.96	8343.0
2021-07-26 19:30:00	SPY	ETF	440.91	440.91	440.69	440.73	31184.0
2021-07-26 04:00:00	QQQ	ETF	368.0	368.0	366.6	366.74	23836.0
2021-07-26 04:30:00	QQQ	ETF	366.7	367.25	366.69	367.18	14009.0
2021-07-26 05:00:00	QQQ	ETF	367.15	367.74	367.15	367.74	17184.0
2021-07-26 05:30:00	QQQ	ETF	367.68	367.83	367.58	367.64	14534.0
2021-07-26 06:00:00	QQQ	ETF	367.76	367.82	367.64	367.64	6323.0
2021-07-26 06:30:00	QQQ	ETF	367.59	367.6	367.2	367.2	23651.0
2021-07-26 07:00:00	QQQ	ETF	367.17	367.65	367.16	367.6	71788.0
2021-07-26 07:30:00	QQQ	ETF	367.57	367.98	367.57	367.65	74022.0
2021-07-26 08:00:00	QQQ	ETF	367.64	368.476	367.26	367.34	112513.0
2021-07-26 08:30:00	QQQ	ETF	367.36	367.36	367.05	367.201	59552.0
2021-07-26 09:00:00	QQQ	ETF	367.19	367.66	367.14	367.5	118392.0
2021-07-26 09:30:00	QQQ	ETF	367.49	368.1	366.601	368.05	4370639.0
2021-07-26 10:00:00	QQQ	ETF	368.05	368.4801	367.7108	367.89	2184319.0
2021-07-26 10:30:00	QQQ	ETF	367.88	368.5812	367.63	367.86	1731695.0
2021-07-26 11:00:00	QQQ	ETF	367.85	368.24	367.66	368.2	1370987.0
2021-07-26 11:30:00	QQQ	ETF	368.22	368.76	368.11	368.7115	1064021.0
2021-07-26 12:00:00	QQQ	ETF	368.73	368.89	368.27	368.27	1107191.0
2021-07-26 12:30:00	QQQ	ETF	368.265	368.3	367.67	367.99	1199023.0

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

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