PREVIEW / etf_30min / 2021-09-29

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-29.parquet
  size:    619 KB
  rows:    23,854

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-09-29 04:00:00	SPY	ETF	436.7	437.06	436.01	436.42	61055.0
2021-09-29 04:30:00	SPY	ETF	436.48	436.81	436.34	436.8	16034.0
2021-09-29 05:00:00	SPY	ETF	436.84	437.07	436.42	436.63	84537.0
2021-09-29 05:30:00	SPY	ETF	436.64	436.94	436.37	436.94	67717.0
2021-09-29 06:00:00	SPY	ETF	436.94	437.14	436.9	436.96	49067.0
2021-09-29 06:30:00	SPY	ETF	436.91	436.92	436.35	436.49	61097.0
2021-09-29 07:00:00	SPY	ETF	436.41	436.6	435.8	436.09	185947.0
2021-09-29 07:30:00	SPY	ETF	436.06	436.35	435.49	436.1	188670.0
2021-09-29 08:00:00	SPY	ETF	436.11	437.1104	435.48	435.72	312009.0
2021-09-29 08:30:00	SPY	ETF	435.72	435.89	435.0	435.51	604824.0
2021-09-29 09:00:00	SPY	ETF	435.5	435.58	434.68	435.15	343145.0
2021-09-29 09:30:00	SPY	ETF	435.19	436.49	434.03	436.23	10294848.0
2021-09-29 10:00:00	SPY	ETF	436.24	436.96	435.79	436.27	4794803.0
2021-09-29 10:30:00	SPY	ETF	436.27	437.04	435.5	436.75	4369844.0
2021-09-29 11:00:00	SPY	ETF	436.73	436.81	435.69	435.79	3349971.0
2021-09-29 11:30:00	SPY	ETF	435.81	436.0	435.01	435.6909	3260929.0
2021-09-29 12:00:00	SPY	ETF	435.7	435.945	434.25	434.54	2982066.0
2021-09-29 12:30:00	SPY	ETF	434.5301	435.4	434.36	435.0	2749633.0
2021-09-29 13:00:00	SPY	ETF	435.01	435.39	434.48	434.64	3126659.0
2021-09-29 13:30:00	SPY	ETF	434.71	434.99	433.85	434.93	5160895.0
2021-09-29 14:00:00	SPY	ETF	434.93	436.625	434.84	436.21	4453573.0
2021-09-29 14:30:00	SPY	ETF	436.22	436.98	436.21	436.61	3072021.0
2021-09-29 15:00:00	SPY	ETF	436.65	436.89	435.97	436.14	2976601.0
2021-09-29 15:30:00	SPY	ETF	436.1399	436.25	433.9501	434.43	11617243.0
2021-09-29 16:00:00	SPY	ETF	434.4399	435.287	434.33	434.77	4835457.0
2021-09-29 16:30:00	SPY	ETF	434.77	435.25	434.45	435.03	177019.0
2021-09-29 17:00:00	SPY	ETF	435.02	435.06	434.8	435.04	115728.0
2021-09-29 17:30:00	SPY	ETF	435.04	435.24	435.01	435.24	10435.0
2021-09-29 18:00:00	SPY	ETF	435.23	435.46	434.93	434.95	59464.0
2021-09-29 18:30:00	SPY	ETF	434.45	435.3	434.45	435.21	19740.0
2021-09-29 19:00:00	SPY	ETF	435.26	435.91	435.23	435.87	48482.0
2021-09-29 19:30:00	SPY	ETF	435.94	435.97	435.52	435.62	82456.0
2021-09-29 04:00:00	QQQ	ETF	362.35	363.63	362.35	363.0	58407.0
2021-09-29 04:30:00	QQQ	ETF	363.01	363.15	362.67	363.11	30124.0
2021-09-29 05:00:00	QQQ	ETF	363.26	363.51	362.82	362.96	31355.0
2021-09-29 05:30:00	QQQ	ETF	363.02	363.31	362.77	363.31	14271.0
2021-09-29 06:00:00	QQQ	ETF	363.4	363.66	363.32	363.43	26854.0
2021-09-29 06:30:00	QQQ	ETF	363.36	363.54	362.94	363.03	39092.0
2021-09-29 07:00:00	QQQ	ETF	363.0	363.2	361.88	362.2	203895.0
2021-09-29 07:30:00	QQQ	ETF	362.18	362.73	361.79	362.46	107964.0
2021-09-29 08:00:00	QQQ	ETF	363.1	363.7	361.6	362.0	325200.0
2021-09-29 08:30:00	QQQ	ETF	362.01	362.1	361.42	361.9	244143.0
2021-09-29 09:00:00	QQQ	ETF	361.89	361.9	360.97	361.17	589310.0
2021-09-29 09:30:00	QQQ	ETF	361.18	363.3	360.47	362.8	8595886.0
2021-09-29 10:00:00	QQQ	ETF	362.8	363.37	362.06	362.2	4296445.0
2021-09-29 10:30:00	QQQ	ETF	362.2	362.95	361.28	362.68	3610144.0
2021-09-29 11:00:00	QQQ	ETF	362.67	362.79	360.84	360.9	2532270.0
2021-09-29 11:30:00	QQQ	ETF	360.91	361.08	359.75	360.705	3789417.0
2021-09-29 12:00:00	QQQ	ETF	360.7	360.93	358.95	359.23	3156816.0
2021-09-29 12:30:00	QQQ	ETF	359.23	360.36	359.08	359.93	2408634.0

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

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