PREVIEW / etf_30min / 2021-02-01

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-02-01.parquet
  size:    643 KB
  rows:    24,515

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-02-01 04:00:00	SPY	ETF	373.19	374.06	373.11	373.7	66104.0
2021-02-01 04:30:00	SPY	ETF	373.63	373.84	372.9	373.46	172675.0
2021-02-01 05:00:00	SPY	ETF	373.49	373.69	373.41	373.61	110116.0
2021-02-01 05:30:00	SPY	ETF	373.54	373.86	372.95	373.13	19675.0
2021-02-01 06:00:00	SPY	ETF	373.03	374.71	372.98	374.49	178758.0
2021-02-01 06:30:00	SPY	ETF	374.55	374.59	373.76	373.78	46857.0
2021-02-01 07:00:00	SPY	ETF	373.58	374.29	373.54	374.0	218304.0
2021-02-01 07:30:00	SPY	ETF	374.0	374.5	373.54	373.59	160062.0
2021-02-01 08:00:00	SPY	ETF	373.6999	374.4996	371.49	373.25	299496.0
2021-02-01 08:30:00	SPY	ETF	373.28	373.79	373.22	373.42	168561.0
2021-02-01 09:00:00	SPY	ETF	373.42	373.8	373.09	373.72	415727.0
2021-02-01 09:30:00	SPY	ETF	373.72	374.39	371.42	372.61	7515328.0
2021-02-01 10:00:00	SPY	ETF	372.615	373.49	371.7	372.95	4382942.0
2021-02-01 10:30:00	SPY	ETF	372.96	373.99	372.455	372.84	3341269.0
2021-02-01 11:00:00	SPY	ETF	372.84	374.77	372.26	374.6099	3729317.0
2021-02-01 11:30:00	SPY	ETF	374.605	375.8	374.52	375.13	3750359.0
2021-02-01 12:00:00	SPY	ETF	375.1289	376.19	375.125	376.1381	2564434.0
2021-02-01 12:30:00	SPY	ETF	376.14	376.49	375.665	376.46	1857892.0
2021-02-01 13:00:00	SPY	ETF	376.455	376.59	376.1101	376.38	1672792.0
2021-02-01 13:30:00	SPY	ETF	376.38	376.71	375.81	376.43	1555434.0
2021-02-01 14:00:00	SPY	ETF	376.4499	377.0	376.06	376.9419	2145789.0
2021-02-01 14:30:00	SPY	ETF	376.96	377.34	376.715	376.89	2069838.0
2021-02-01 15:00:00	SPY	ETF	376.9	377.29	376.31	376.601	3383605.0
2021-02-01 15:30:00	SPY	ETF	376.61	377.12	376.07	376.18	9673117.0
2021-02-01 16:00:00	SPY	ETF	376.18	376.3147	370.376	375.54	5713737.0
2021-02-01 16:30:00	SPY	ETF	375.53	376.23	375.4	376.06	441001.0
2021-02-01 17:00:00	SPY	ETF	376.06	376.08	375.9	376.03	67192.0
2021-02-01 17:30:00	SPY	ETF	376.0	376.17	375.95	376.12	40217.0
2021-02-01 18:00:00	SPY	ETF	376.15	376.89	376.1	376.7	195100.0
2021-02-01 18:30:00	SPY	ETF	376.23	376.96	376.23	376.63	34448.0
2021-02-01 19:00:00	SPY	ETF	376.57	376.57	375.71	375.92	103883.0
2021-02-01 19:30:00	SPY	ETF	375.85	376.39	375.71	376.39	54656.0
2021-02-01 04:00:00	QQQ	ETF	317.62	318.33	317.26	318.11	209122.0
2021-02-01 04:30:00	QQQ	ETF	318.09	318.17	317.49	317.94	64076.0
2021-02-01 05:00:00	QQQ	ETF	317.98	318.23	317.77	317.9	89598.0
2021-02-01 05:30:00	QQQ	ETF	317.93	318.22	317.48	317.57	22914.0
2021-02-01 06:00:00	QQQ	ETF	317.66	318.75	317.56	318.69	30007.0
2021-02-01 06:30:00	QQQ	ETF	318.75	318.77	317.83	317.88	91034.0
2021-02-01 07:00:00	QQQ	ETF	317.88	318.33	317.63	318.24	128116.0
2021-02-01 07:30:00	QQQ	ETF	318.22	318.62	317.98	317.98	98083.0
2021-02-01 08:00:00	QQQ	ETF	318.1704	318.7796	315.33	317.89	117583.0
2021-02-01 08:30:00	QQQ	ETF	317.94	318.28	317.89	318.0	141271.0
2021-02-01 09:00:00	QQQ	ETF	318.02	318.25	317.65	318.16	305576.0
2021-02-01 09:30:00	QQQ	ETF	318.14	319.39	316.02	317.415	4224654.0
2021-02-01 10:00:00	QQQ	ETF	317.34	319.1518	316.6	318.86	2155649.0
2021-02-01 10:30:00	QQQ	ETF	318.87	320.07	318.14	318.61	2594203.0
2021-02-01 11:00:00	QQQ	ETF	318.63	320.66	317.9	320.63	1960247.0
2021-02-01 11:30:00	QQQ	ETF	320.635	321.65	320.46	321.12	1648481.0
2021-02-01 12:00:00	QQQ	ETF	321.13	322.78	321.13	322.72	1555462.0
2021-02-01 12:30:00	QQQ	ETF	322.75	323.08	322.19	323.05	1418912.0

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

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