PREVIEW / etf_30min / 2021-11-15

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-15.parquet
  size:    631 KB
  rows:    24,683

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-11-15 04:00:00	SPY	ETF	468.05	468.31	468.0	468.08	7993.0
2021-11-15 04:30:00	SPY	ETF	468.08	468.11	467.94	468.11	4034.0
2021-11-15 05:00:00	SPY	ETF	468.12	468.34	468.12	468.26	10233.0
2021-11-15 05:30:00	SPY	ETF	468.3	468.49	468.25	468.44	2387.0
2021-11-15 06:00:00	SPY	ETF	468.47	468.5	468.32	468.34	5636.0
2021-11-15 06:30:00	SPY	ETF	468.38	468.55	468.38	468.46	26235.0
2021-11-15 07:00:00	SPY	ETF	468.45	468.45	468.24	468.26	68174.0
2021-11-15 07:30:00	SPY	ETF	468.28	468.46	468.25	468.44	25286.0
2021-11-15 08:00:00	SPY	ETF	468.4499	469.22	467.31	469.1	102031.0
2021-11-15 08:30:00	SPY	ETF	469.16	469.2099	468.87	468.89	98803.0
2021-11-15 09:00:00	SPY	ETF	468.91	469.04	468.62	468.65	128139.0
2021-11-15 09:30:00	SPY	ETF	468.64	468.81	467.63	468.55	4158452.0
2021-11-15 10:00:00	SPY	ETF	468.56	468.58	467.54	467.74	2572050.0
2021-11-15 10:30:00	SPY	ETF	467.73	468.04	467.49	467.76	1987798.0
2021-11-15 11:00:00	SPY	ETF	467.76	468.07	467.67	467.67	1726891.0
2021-11-15 11:30:00	SPY	ETF	467.67	468.0	466.24	466.8993	3787148.0
2021-11-15 12:00:00	SPY	ETF	466.88	467.04	466.23	466.59	1687527.0
2021-11-15 12:30:00	SPY	ETF	466.59	467.26	466.57	467.193	1447186.0
2021-11-15 13:00:00	SPY	ETF	467.2	467.55	467.0	467.24	1838778.0
2021-11-15 13:30:00	SPY	ETF	467.25	467.31	466.9413	467.06	893330.0
2021-11-15 14:00:00	SPY	ETF	467.09	467.1	466.58	466.78	1548298.0
2021-11-15 14:30:00	SPY	ETF	466.79	467.45	466.67	467.265	1478723.0
2021-11-15 15:00:00	SPY	ETF	467.275	467.4895	467.01	467.405	2015198.0
2021-11-15 15:30:00	SPY	ETF	467.4	467.52	466.58	467.4	6112758.0
2021-11-15 16:00:00	SPY	ETF	467.39	467.69	467.2418	467.58	2392908.0
2021-11-15 16:30:00	SPY	ETF	467.57	467.61	467.43	467.6	39242.0
2021-11-15 17:00:00	SPY	ETF	467.61	467.63	467.52	467.52	60854.0
2021-11-15 17:30:00	SPY	ETF	467.53	467.54	467.43	467.5	86094.0
2021-11-15 18:00:00	SPY	ETF	467.52	467.59	467.36	467.36	91762.0
2021-11-15 18:30:00	SPY	ETF	467.43	467.49	467.37	467.46	15548.0
2021-11-15 19:00:00	SPY	ETF	467.46	467.7	467.24	467.29	36902.0
2021-11-15 19:30:00	SPY	ETF	467.27	467.63	467.18	467.57	29271.0
2021-11-15 04:00:00	QQQ	ETF	395.44	396.0	395.36	395.43	86550.0
2021-11-15 04:30:00	QQQ	ETF	395.43	395.46	395.17	395.46	36959.0
2021-11-15 05:00:00	QQQ	ETF	395.48	395.74	395.46	395.67	85008.0
2021-11-15 05:30:00	QQQ	ETF	395.62	395.8	395.52	395.61	56161.0
2021-11-15 06:00:00	QQQ	ETF	395.62	395.69	395.47	395.47	13161.0
2021-11-15 06:30:00	QQQ	ETF	395.48	395.82	395.48	395.72	81950.0
2021-11-15 07:00:00	QQQ	ETF	395.74	395.78	395.46	395.6	99333.0
2021-11-15 07:30:00	QQQ	ETF	395.59	395.81	395.56	395.75	51564.0
2021-11-15 08:00:00	QQQ	ETF	395.53	396.77	394.996	396.54	266603.0
2021-11-15 08:30:00	QQQ	ETF	396.59	396.74	396.32	396.36	126772.0
2021-11-15 09:00:00	QQQ	ETF	396.38	396.46	395.86	395.89	178488.0
2021-11-15 09:30:00	QQQ	ETF	395.91	396.24	394.653	395.6419	4347806.0
2021-11-15 10:00:00	QQQ	ETF	395.66	395.69	393.94	394.125	3086342.0
2021-11-15 10:30:00	QQQ	ETF	394.11	394.535	393.6423	394.2282	1766041.0
2021-11-15 11:00:00	QQQ	ETF	394.235	394.54	393.99	394.06	1180834.0
2021-11-15 11:30:00	QQQ	ETF	394.04	394.78	392.369	393.17	2854434.0
2021-11-15 12:00:00	QQQ	ETF	393.1502	393.56	392.095	392.6099	1806946.0
2021-11-15 12:30:00	QQQ	ETF	392.62	393.715	392.58	393.39	944411.0

> showing 50 of 24,683 rows — these rows as CSV

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