PREVIEW / etf_30min / 2021-07-15

all etf 30-min files

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

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-15 04:00:00	SPY	ETF	435.8	436.37	435.28	436.35	11798.0
2021-07-15 04:30:00	SPY	ETF	436.32	436.4	436.07	436.3	12958.0
2021-07-15 05:00:00	SPY	ETF	436.32	436.32	435.71	435.71	9158.0
2021-07-15 05:30:00	SPY	ETF	435.73	436.0	435.69	436.0	9764.0
2021-07-15 06:00:00	SPY	ETF	435.9	435.93	434.95	435.13	27836.0
2021-07-15 06:30:00	SPY	ETF	434.85	435.41	434.63	434.86	28912.0
2021-07-15 07:00:00	SPY	ETF	434.88	435.05	434.06	434.38	108718.0
2021-07-15 07:30:00	SPY	ETF	434.35	435.18	434.25	434.82	178067.0
2021-07-15 08:00:00	SPY	ETF	434.9906	435.5	434.09	434.79	328245.0
2021-07-15 08:30:00	SPY	ETF	434.8	435.15	434.62	434.67	189466.0
2021-07-15 09:00:00	SPY	ETF	434.6596	434.97	434.59	434.82	136101.0
2021-07-15 09:30:00	SPY	ETF	434.81	435.42	433.98	435.35	5551453.0
2021-07-15 10:00:00	SPY	ETF	435.36	435.53	434.44	434.625	3441597.0
2021-07-15 10:30:00	SPY	ETF	434.63	435.31	434.18	434.78	3791535.0
2021-07-15 11:00:00	SPY	ETF	434.78	435.1	434.2	435.06	2955451.0
2021-07-15 11:30:00	SPY	ETF	435.05	435.36	434.67	434.7369	1827387.0
2021-07-15 12:00:00	SPY	ETF	434.73	434.77	434.01	434.6	2830433.0
2021-07-15 12:30:00	SPY	ETF	434.595	434.96	434.38	434.56	1378456.0
2021-07-15 13:00:00	SPY	ETF	434.5625	434.6	433.69	433.8582	2697235.0
2021-07-15 13:30:00	SPY	ETF	433.85	433.85	432.72	432.79	4267084.0
2021-07-15 14:00:00	SPY	ETF	432.77	434.03	432.74	433.95	3152355.0
2021-07-15 14:30:00	SPY	ETF	433.93	434.2099	433.2	434.2099	2731166.0
2021-07-15 15:00:00	SPY	ETF	434.2	434.43	434.02	434.355	2875856.0
2021-07-15 15:30:00	SPY	ETF	434.35	434.81	434.15	434.73	6321128.0
2021-07-15 16:00:00	SPY	ETF	434.73	434.85	434.19	434.26	2032326.0
2021-07-15 16:30:00	SPY	ETF	434.23	434.75	434.14	434.27	57611.0
2021-07-15 17:00:00	SPY	ETF	434.27	434.42	434.1	434.14	64931.0
2021-07-15 17:30:00	SPY	ETF	434.13	434.19	434.05	434.11	37938.0
2021-07-15 18:00:00	SPY	ETF	434.17	434.26	434.0	434.02	45734.0
2021-07-15 18:30:00	SPY	ETF	434.07	434.17	434.03	434.13	11515.0
2021-07-15 19:00:00	SPY	ETF	434.19	434.251	434.1	434.17	63582.0
2021-07-15 19:30:00	SPY	ETF	434.2	434.2	433.72	433.77	35910.0
2021-07-15 04:00:00	QQQ	ETF	363.71	364.58	363.67	364.58	34967.0
2021-07-15 04:30:00	QQQ	ETF	364.46	364.66	364.31	364.52	15702.0
2021-07-15 05:00:00	QQQ	ETF	364.55	364.6	364.14	364.29	36533.0
2021-07-15 05:30:00	QQQ	ETF	364.26	364.44	364.19	364.32	11015.0
2021-07-15 06:00:00	QQQ	ETF	364.28	364.29	363.35	363.48	46623.0
2021-07-15 06:30:00	QQQ	ETF	363.45	363.88	363.14	363.47	55857.0
2021-07-15 07:00:00	QQQ	ETF	363.34	363.51	362.36	362.55	172811.0
2021-07-15 07:30:00	QQQ	ETF	362.521	363.18	362.37	363.0	68610.0
2021-07-15 08:00:00	QQQ	ETF	363.51	363.82	362.41	363.06	162427.0
2021-07-15 08:30:00	QQQ	ETF	363.0	363.31	362.76	362.89	128836.0
2021-07-15 09:00:00	QQQ	ETF	362.89	363.26	362.84	362.9504	145115.0
2021-07-15 09:30:00	QQQ	ETF	362.98	363.19	360.61	362.98	4335015.0
2021-07-15 10:00:00	QQQ	ETF	362.98	363.05	360.38	360.82	2707718.0
2021-07-15 10:30:00	QQQ	ETF	360.84	361.76	359.61	360.25	3492581.0
2021-07-15 11:00:00	QQQ	ETF	360.2	361.2675	359.57	361.13	2312050.0
2021-07-15 11:30:00	QQQ	ETF	361.1107	361.41	359.93	360.11	1655386.0
2021-07-15 12:00:00	QQQ	ETF	360.11	360.15	359.07	360.135	3692939.0
2021-07-15 12:30:00	QQQ	ETF	360.12	360.66	359.74	360.27	1895216.0

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

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