PREVIEW / etf_30min / 2021-06-28

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-28.parquet
  size:    602 KB
  rows:    23,371

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-28 04:00:00	SPY	ETF	426.8	426.85	426.44	426.44	6404.0
2021-06-28 04:30:00	SPY	ETF	426.45	426.71	426.42	426.71	3892.0
2021-06-28 05:00:00	SPY	ETF	426.75	426.75	426.72	426.72	400.0
2021-06-28 05:30:00	SPY	ETF	426.72	426.83	426.63	426.7	6906.0
2021-06-28 06:00:00	SPY	ETF	426.7	426.75	426.3	426.45	22126.0
2021-06-28 06:30:00	SPY	ETF	426.47	426.68	426.31	426.68	12081.0
2021-06-28 07:00:00	SPY	ETF	426.66	427.08	426.58	426.89	51305.0
2021-06-28 07:30:00	SPY	ETF	426.91	426.95	426.68	426.79	47164.0
2021-06-28 08:00:00	SPY	ETF	426.8899	427.0	426.32	427.0	161604.0
2021-06-28 08:30:00	SPY	ETF	427.03	427.31	426.93	427.23	131964.0
2021-06-28 09:00:00	SPY	ETF	427.24	427.39	427.12	427.16	141858.0
2021-06-28 09:30:00	SPY	ETF	427.17	427.2419	426.02	426.69	4035529.0
2021-06-28 10:00:00	SPY	ETF	426.69	426.82	426.34	426.65	2112528.0
2021-06-28 10:30:00	SPY	ETF	426.65	426.87	426.39	426.5	1559939.0
2021-06-28 11:00:00	SPY	ETF	426.51	426.79	426.19	426.265	1911022.0
2021-06-28 11:30:00	SPY	ETF	426.26	426.57	426.15	426.5325	1116399.0
2021-06-28 12:00:00	SPY	ETF	426.54	426.65	426.31	426.36	1213106.0
2021-06-28 12:30:00	SPY	ETF	426.365	426.43	426.17	426.18	1059032.0
2021-06-28 13:00:00	SPY	ETF	426.18	426.21	425.89	425.94	1891027.0
2021-06-28 13:30:00	SPY	ETF	425.95	426.52	425.89	426.5	1915046.0
2021-06-28 14:00:00	SPY	ETF	426.49	426.76	426.47	426.71	1541763.0
2021-06-28 14:30:00	SPY	ETF	426.715	427.0	426.67	426.92	1896347.0
2021-06-28 15:00:00	SPY	ETF	426.93	427.29	426.755	427.19	3663675.0
2021-06-28 15:30:00	SPY	ETF	427.195	427.65	427.1	427.48	7058362.0
2021-06-28 16:00:00	SPY	ETF	427.49	427.54	427.33	427.51	3682101.0
2021-06-28 16:30:00	SPY	ETF	427.51	427.65	427.47	427.59	231319.0
2021-06-28 17:00:00	SPY	ETF	427.6	427.65	427.56	427.61	38426.0
2021-06-28 17:30:00	SPY	ETF	427.61	427.64	427.47	427.6	584037.0
2021-06-28 18:00:00	SPY	ETF	427.58	427.58	427.21	427.25	103328.0
2021-06-28 18:30:00	SPY	ETF	427.47	427.47	427.22	427.22	10580.0
2021-06-28 19:00:00	SPY	ETF	427.23	427.32	427.2	427.27	24458.0
2021-06-28 19:30:00	SPY	ETF	427.23	427.23	427.13	427.2	14023.0
2021-06-28 04:00:00	QQQ	ETF	349.71	350.38	349.71	350.0	13926.0
2021-06-28 04:30:00	QQQ	ETF	349.93	350.3	349.92	350.3	5889.0
2021-06-28 05:00:00	QQQ	ETF	350.31	350.36	350.28	350.33	2718.0
2021-06-28 05:30:00	QQQ	ETF	350.21	350.4	350.16	350.25	11423.0
2021-06-28 06:00:00	QQQ	ETF	350.3	350.3	349.98	350.02	9631.0
2021-06-28 06:30:00	QQQ	ETF	350.02	350.3	350.0	350.28	11488.0
2021-06-28 07:00:00	QQQ	ETF	350.24	350.6	350.16	350.47	63096.0
2021-06-28 07:30:00	QQQ	ETF	350.43	350.56	350.39	350.5	47614.0
2021-06-28 08:00:00	QQQ	ETF	350.55	350.6	349.96	350.52	77844.0
2021-06-28 08:30:00	QQQ	ETF	350.59	350.74	350.5	350.72	68500.0
2021-06-28 09:00:00	QQQ	ETF	350.7201	350.84	350.65	350.78	136718.0
2021-06-28 09:30:00	QQQ	ETF	350.78	352.37	350.72	352.17	4222076.0
2021-06-28 10:00:00	QQQ	ETF	352.18	352.93	352.1713	352.5	2991476.0
2021-06-28 10:30:00	QQQ	ETF	352.53	353.06	352.35	352.375	2332975.0
2021-06-28 11:00:00	QQQ	ETF	352.39	352.7699	352.26	352.72	1820939.0
2021-06-28 11:30:00	QQQ	ETF	352.74	352.91	352.5018	352.695	1352448.0
2021-06-28 12:00:00	QQQ	ETF	352.695	353.23	352.6	353.06	1723014.0
2021-06-28 12:30:00	QQQ	ETF	353.07	353.17	352.67	352.71	1066078.0

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

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