PREVIEW / etf_30min / 2021-06-24

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-24.parquet
  size:    610 KB
  rows:    23,019

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-06-24 04:00:00	SPY	ETF	423.84	424.48	423.84	424.41	30532.0
2021-06-24 04:30:00	SPY	ETF	424.44	424.6	424.44	424.56	13100.0
2021-06-24 05:00:00	SPY	ETF	424.58	424.87	424.58	424.66	7181.0
2021-06-24 05:30:00	SPY	ETF	424.67	424.8	424.58	424.67	12767.0
2021-06-24 06:00:00	SPY	ETF	424.61	424.83	424.61	424.79	12768.0
2021-06-24 06:30:00	SPY	ETF	424.73	424.74	424.61	424.61	8403.0
2021-06-24 07:00:00	SPY	ETF	424.62	424.79	424.54	424.59	91719.0
2021-06-24 07:30:00	SPY	ETF	424.59	424.7	424.5	424.66	32415.0
2021-06-24 08:00:00	SPY	ETF	424.63	424.83	423.75	424.78	113394.0
2021-06-24 08:30:00	SPY	ETF	424.77	424.8	424.28	424.52	133104.0
2021-06-24 09:00:00	SPY	ETF	424.55	424.98	424.48	424.89	105637.0
2021-06-24 09:30:00	SPY	ETF	424.89	425.29	424.72	424.92	4165885.0
2021-06-24 10:00:00	SPY	ETF	424.93	425.47	424.73	425.47	2741422.0
2021-06-24 10:30:00	SPY	ETF	425.475	425.53	424.97	425.0	2143792.0
2021-06-24 11:00:00	SPY	ETF	425.01	425.19	424.8	424.97	1227163.0
2021-06-24 11:30:00	SPY	ETF	424.975	425.08	424.62	424.775	1608747.0
2021-06-24 12:00:00	SPY	ETF	424.7819	425.16	424.76	424.97	1672937.0
2021-06-24 12:30:00	SPY	ETF	424.9691	425.335	424.87	425.19	1612082.0
2021-06-24 13:00:00	SPY	ETF	425.2	425.53	424.92	425.055	2067198.0
2021-06-24 13:30:00	SPY	ETF	425.05	425.169	424.77	425.13	1336294.0
2021-06-24 14:00:00	SPY	ETF	425.13	425.46	425.11	425.41	1385121.0
2021-06-24 14:30:00	SPY	ETF	425.42	425.55	425.28	425.395	1700383.0
2021-06-24 15:00:00	SPY	ETF	425.39	425.42	424.97	425.0299	2085309.0
2021-06-24 15:30:00	SPY	ETF	425.02	425.36	424.85	425.0899	7431925.0
2021-06-24 16:00:00	SPY	ETF	425.08	425.38	425.01	425.35	2034401.0
2021-06-24 16:30:00	SPY	ETF	425.34	425.75	425.24	425.63	199426.0
2021-06-24 17:00:00	SPY	ETF	425.66	425.72	425.55	425.66	41652.0
2021-06-24 17:30:00	SPY	ETF	425.66	425.7	425.07	425.68	732408.0
2021-06-24 18:00:00	SPY	ETF	425.68	425.68	425.44	425.62	36774.0
2021-06-24 18:30:00	SPY	ETF	425.1	425.61	425.1	425.57	12191.0
2021-06-24 19:00:00	SPY	ETF	425.61	425.62	425.38	425.45	11509.0
2021-06-24 19:30:00	SPY	ETF	425.45	425.63	425.4	425.4	25444.0
2021-06-24 04:00:00	QQQ	ETF	348.3	349.7	348.3	349.53	38494.0
2021-06-24 04:30:00	QQQ	ETF	349.54	349.72	349.54	349.7	9055.0
2021-06-24 05:00:00	QQQ	ETF	349.68	349.96	349.68	349.8	30393.0
2021-06-24 05:30:00	QQQ	ETF	349.81	349.91	349.65	349.78	19953.0
2021-06-24 06:00:00	QQQ	ETF	349.65	349.78	349.6	349.75	4699.0
2021-06-24 06:30:00	QQQ	ETF	349.7	349.7	349.5	349.52	7631.0
2021-06-24 07:00:00	QQQ	ETF	349.54	349.73	349.47	349.6	51593.0
2021-06-24 07:30:00	QQQ	ETF	349.65	349.7	349.529	349.69	44860.0
2021-06-24 08:00:00	QQQ	ETF	349.5796	349.95	348.0	349.88	164911.0
2021-06-24 08:30:00	QQQ	ETF	349.83	349.9	349.47	349.63	109302.0
2021-06-24 09:00:00	QQQ	ETF	349.65	349.88	349.59	349.76	73668.0
2021-06-24 09:30:00	QQQ	ETF	349.74	350.65	349.62	350.42	3340242.0
2021-06-24 10:00:00	QQQ	ETF	350.42	351.04	350.28	351.03	2496847.0
2021-06-24 10:30:00	QQQ	ETF	351.04	351.2386	350.66	350.67	1759174.0
2021-06-24 11:00:00	QQQ	ETF	350.67	350.97	350.525	350.84	1246212.0
2021-06-24 11:30:00	QQQ	ETF	350.85	350.93	350.44	350.84	1123585.0
2021-06-24 12:00:00	QQQ	ETF	350.85	351.46	350.7901	351.07	1215375.0
2021-06-24 12:30:00	QQQ	ETF	351.0799	351.125	350.01	350.205	1827864.0

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

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