PREVIEW / etf_30min / 2021-08-30

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-08-30.parquet
  size:    610 KB
  rows:    23,187

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-08-30 04:00:00	SPY	ETF	450.48	450.61	450.41	450.57	4404.0
2021-08-30 04:30:00	SPY	ETF	450.53	450.53	450.46	450.46	800.0
2021-08-30 05:00:00	SPY	ETF	450.53	450.6	450.53	450.53	1369.0
2021-08-30 05:30:00	SPY	ETF	450.47	450.5	450.44	450.5	935.0
2021-08-30 06:00:00	SPY	ETF	450.54	450.67	450.52	450.63	5306.0
2021-08-30 06:30:00	SPY	ETF	450.67	450.75	450.53	450.53	67445.0
2021-08-30 07:00:00	SPY	ETF	450.57	450.64	450.51	450.55	23667.0
2021-08-30 07:30:00	SPY	ETF	450.56	450.6	450.52	450.59	14192.0
2021-08-30 08:00:00	SPY	ETF	450.53	450.87	450.51	450.6	72310.0
2021-08-30 08:30:00	SPY	ETF	450.58	450.81	450.53	450.81	56681.0
2021-08-30 09:00:00	SPY	ETF	450.8	451.05	450.79	450.99	139553.0
2021-08-30 09:30:00	SPY	ETF	450.99	451.48	450.71	451.44	3850766.0
2021-08-30 10:00:00	SPY	ETF	451.45	452.18	451.2599	452.165	2907477.0
2021-08-30 10:30:00	SPY	ETF	452.17	452.815	452.08	452.795	3020635.0
2021-08-30 11:00:00	SPY	ETF	452.79	453.07	452.6	452.63	2478192.0
2021-08-30 11:30:00	SPY	ETF	452.63	453.0	452.62	452.907	1976466.0
2021-08-30 12:00:00	SPY	ETF	452.9	452.96	452.36	452.46	1698020.0
2021-08-30 12:30:00	SPY	ETF	452.47	452.72	452.39	452.72	986977.0
2021-08-30 13:00:00	SPY	ETF	452.72	452.8	452.603	452.705	1025131.0
2021-08-30 13:30:00	SPY	ETF	452.71	452.95	452.62	452.94	1195071.0
2021-08-30 14:00:00	SPY	ETF	452.94	453.07	452.755	452.86	1595915.0
2021-08-30 14:30:00	SPY	ETF	452.86	452.914	452.625	452.895	1720383.0
2021-08-30 15:00:00	SPY	ETF	452.89	452.99	452.695	452.72	2210982.0
2021-08-30 15:30:00	SPY	ETF	452.72	452.75	452.09	452.22	7650676.0
2021-08-30 16:00:00	SPY	ETF	452.21	452.46	452.06	452.46	3009067.0
2021-08-30 16:30:00	SPY	ETF	452.46	452.69	452.42	452.63	253720.0
2021-08-30 17:00:00	SPY	ETF	452.68	452.68	452.53	452.55	32061.0
2021-08-30 17:30:00	SPY	ETF	452.56	452.63	452.23	452.61	469402.0
2021-08-30 18:00:00	SPY	ETF	452.61	452.73	452.51	452.7	38035.0
2021-08-30 18:30:00	SPY	ETF	452.23	452.7	452.23	452.64	5301.0
2021-08-30 19:00:00	SPY	ETF	452.64	452.64	452.46	452.48	9936.0
2021-08-30 19:30:00	SPY	ETF	452.46	452.52	452.29	452.35	73179.0
2021-08-30 04:00:00	QQQ	ETF	376.3	376.7	376.3	376.7	28242.0
2021-08-30 04:30:00	QQQ	ETF	376.7	376.7	376.52	376.63	8176.0
2021-08-30 05:00:00	QQQ	ETF	376.64	376.72	376.63	376.66	5732.0
2021-08-30 05:30:00	QQQ	ETF	376.6	376.62	376.56	376.59	5028.0
2021-08-30 06:00:00	QQQ	ETF	376.63	376.77	376.59	376.75	13186.0
2021-08-30 06:30:00	QQQ	ETF	376.81	376.81	376.61	376.63	14302.0
2021-08-30 07:00:00	QQQ	ETF	376.64	376.64	376.53	376.55	15373.0
2021-08-30 07:30:00	QQQ	ETF	376.55	376.58	376.48	376.58	11031.0
2021-08-30 08:00:00	QQQ	ETF	376.5599	376.6704	376.322	376.51	45791.0
2021-08-30 08:30:00	QQQ	ETF	376.5	376.72	376.4	376.68	29885.0
2021-08-30 09:00:00	QQQ	ETF	376.6899	376.86	376.58	376.79	50098.0
2021-08-30 09:30:00	QQQ	ETF	376.84	378.64	376.83	378.61	3170967.0
2021-08-30 10:00:00	QQQ	ETF	378.65	379.68	378.39	379.575	2459483.0
2021-08-30 10:30:00	QQQ	ETF	379.605	380.035	379.575	379.95	2078487.0
2021-08-30 11:00:00	QQQ	ETF	379.95	380.015	379.36	379.57	1611924.0
2021-08-30 11:30:00	QQQ	ETF	379.56	380.28	379.54	380.15	1240445.0
2021-08-30 12:00:00	QQQ	ETF	380.14	380.21	379.53	379.6814	1415986.0
2021-08-30 12:30:00	QQQ	ETF	379.7	380.01	379.5701	380.0	835076.0

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

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