PREVIEW / etf_30min / 2021-07-07

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-07-07.parquet
  size:    605 KB
  rows:    23,400

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-07 04:00:00	SPY	ETF	433.27	433.69	432.9	433.4	12600.0
2021-07-07 04:30:00	SPY	ETF	433.29	433.3	433.1	433.22	3475.0
2021-07-07 05:00:00	SPY	ETF	433.2	433.66	433.2	433.59	4400.0
2021-07-07 05:30:00	SPY	ETF	433.53	433.64	433.49	433.52	6227.0
2021-07-07 06:00:00	SPY	ETF	433.44	433.44	433.28	433.37	18700.0
2021-07-07 06:30:00	SPY	ETF	433.4	433.7	433.4	433.7	8295.0
2021-07-07 07:00:00	SPY	ETF	433.64	433.74	433.45	433.5	425900.0
2021-07-07 07:30:00	SPY	ETF	433.48	433.73	433.46	433.66	58727.0
2021-07-07 08:00:00	SPY	ETF	433.6996	433.96	432.66	433.56	249103.0
2021-07-07 08:30:00	SPY	ETF	433.57	433.58	433.09	433.23	176801.0
2021-07-07 09:00:00	SPY	ETF	433.22	433.69	433.2	433.68	192660.0
2021-07-07 09:30:00	SPY	ETF	433.66	434.19	433.39	433.72	5352356.0
2021-07-07 10:00:00	SPY	ETF	433.74	433.8396	432.53	432.63	4228337.0
2021-07-07 10:30:00	SPY	ETF	432.6	432.82	431.51	432.65	5644827.0
2021-07-07 11:00:00	SPY	ETF	432.64	433.48	432.285	433.45	3479035.0
2021-07-07 11:30:00	SPY	ETF	433.46	434.16	433.22	433.785	3155422.0
2021-07-07 12:00:00	SPY	ETF	433.78	434.45	433.78	433.92	2165143.0
2021-07-07 12:30:00	SPY	ETF	433.92	434.28	433.77	434.05	1687910.0
2021-07-07 13:00:00	SPY	ETF	434.05	434.07	433.6119	433.76	1404598.0
2021-07-07 13:30:00	SPY	ETF	433.76	434.2275	433.6399	433.88	1623056.0
2021-07-07 14:00:00	SPY	ETF	433.8896	434.75	433.86	434.25	3677861.0
2021-07-07 14:30:00	SPY	ETF	434.2496	434.57	433.74	434.48	2906586.0
2021-07-07 15:00:00	SPY	ETF	434.48	434.73	434.25	434.5	2316619.0
2021-07-07 15:30:00	SPY	ETF	434.5	434.76	434.095	434.43	8173907.0
2021-07-07 16:00:00	SPY	ETF	434.42	434.53	434.21	434.45	2896850.0
2021-07-07 16:30:00	SPY	ETF	434.45	434.67	434.43	434.65	114561.0
2021-07-07 17:00:00	SPY	ETF	434.59	434.62	434.55	434.57	26554.0
2021-07-07 17:30:00	SPY	ETF	434.57	434.63	434.56	434.62	15169.0
2021-07-07 18:00:00	SPY	ETF	434.62	434.68	434.54	434.54	64044.0
2021-07-07 18:30:00	SPY	ETF	434.46	434.6	434.46	434.6	23439.0
2021-07-07 19:00:00	SPY	ETF	434.61	434.61	434.54	434.56	21961.0
2021-07-07 19:30:00	SPY	ETF	434.56	434.56	434.44	434.48	18634.0
2021-07-07 04:00:00	QQQ	ETF	361.67	362.17	361.56	361.79	46830.0
2021-07-07 04:30:00	QQQ	ETF	361.85	361.9	361.33	361.48	63581.0
2021-07-07 05:00:00	QQQ	ETF	361.52	361.92	361.49	361.74	16379.0
2021-07-07 05:30:00	QQQ	ETF	361.77	361.86	361.67	361.68	2050.0
2021-07-07 06:00:00	QQQ	ETF	361.56	361.66	361.5	361.63	7457.0
2021-07-07 06:30:00	QQQ	ETF	361.63	362.1	361.55	361.86	34562.0
2021-07-07 07:00:00	QQQ	ETF	361.87	362.36	361.82	362.22	91402.0
2021-07-07 07:30:00	QQQ	ETF	362.21	362.24	362.02	362.15	33038.0
2021-07-07 08:00:00	QQQ	ETF	361.89	362.46	360.25	362.18	189641.0
2021-07-07 08:30:00	QQQ	ETF	362.26	362.26	361.98	362.22	61806.0
2021-07-07 09:00:00	QQQ	ETF	362.25	362.55	362.18	362.44	113352.0
2021-07-07 09:30:00	QQQ	ETF	362.45	362.76	361.16	361.61	5513202.0
2021-07-07 10:00:00	QQQ	ETF	361.605	361.8618	360.4	360.47	3346680.0
2021-07-07 10:30:00	QQQ	ETF	360.48	360.8782	358.94	360.1598	4198179.0
2021-07-07 11:00:00	QQQ	ETF	360.15	360.35	359.2599	359.93	2175778.0
2021-07-07 11:30:00	QQQ	ETF	359.93	361.435	359.37	361.06	1941093.0
2021-07-07 12:00:00	QQQ	ETF	361.06	361.4	360.59	360.62	1212551.0
2021-07-07 12:30:00	QQQ	ETF	360.62	361.0	360.36	360.74	951827.0

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

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