PREVIEW / etf_30min / 2021-10-21

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-21.parquet
  size:    618 KB
  rows:    23,685

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-10-21 04:00:00	SPY	ETF	451.33	451.38	450.94	450.95	28908.0
2021-10-21 04:30:00	SPY	ETF	451.01	451.09	451.01	451.09	1620.0
2021-10-21 05:00:00	SPY	ETF	451.18	451.23	451.09	451.17	5843.0
2021-10-21 05:30:00	SPY	ETF	451.2	451.41	451.14	451.41	4413.0
2021-10-21 06:00:00	SPY	ETF	451.42	451.44	451.08	451.11	7536.0
2021-10-21 06:30:00	SPY	ETF	451.12	451.29	450.97	450.97	22332.0
2021-10-21 07:00:00	SPY	ETF	451.07	451.37	451.06	451.14	32984.0
2021-10-21 07:30:00	SPY	ETF	451.17	451.24	450.9	450.94	65001.0
2021-10-21 08:00:00	SPY	ETF	451.0846	452.749	450.8	451.04	125662.0
2021-10-21 08:30:00	SPY	ETF	451.08	451.75	451.08	451.37	166864.0
2021-10-21 09:00:00	SPY	ETF	451.34	451.9	451.21	451.77	192735.0
2021-10-21 09:30:00	SPY	ETF	451.76	452.2	451.31	452.0073	3603248.0
2021-10-21 10:00:00	SPY	ETF	452.0	452.475	451.77	452.47	2299274.0
2021-10-21 10:30:00	SPY	ETF	452.47	452.86	452.3201	452.33	1898414.0
2021-10-21 11:00:00	SPY	ETF	452.35	452.58	451.4	451.44	2550908.0
2021-10-21 11:30:00	SPY	ETF	451.44	452.02	451.36	451.95	1914197.0
2021-10-21 12:00:00	SPY	ETF	451.955	452.27	451.77	452.21	1604591.0
2021-10-21 12:30:00	SPY	ETF	452.2	452.26	451.9235	452.134	1124166.0
2021-10-21 13:00:00	SPY	ETF	452.12	452.38	452.03	452.31	1017143.0
2021-10-21 13:30:00	SPY	ETF	452.31	452.42	451.7629	451.92	1476498.0
2021-10-21 14:00:00	SPY	ETF	451.93	452.43	451.91	452.3701	1614968.0
2021-10-21 14:30:00	SPY	ETF	452.38	452.49	452.22	452.49	951731.0
2021-10-21 15:00:00	SPY	ETF	452.5	453.275	452.5	453.24	2295422.0
2021-10-21 15:30:00	SPY	ETF	453.24	453.829	452.94	453.61	6480707.0
2021-10-21 16:00:00	SPY	ETF	453.62	453.76	452.7	452.79	2542423.0
2021-10-21 16:30:00	SPY	ETF	452.78	453.59	452.4	452.65	534980.0
2021-10-21 17:00:00	SPY	ETF	452.78	452.97	452.66	452.73	127431.0
2021-10-21 17:30:00	SPY	ETF	452.72	452.8	452.59	452.6	27610.0
2021-10-21 18:00:00	SPY	ETF	452.65	452.71	452.29	452.58	42629.0
2021-10-21 18:30:00	SPY	ETF	453.59	453.59	452.55	452.56	4907.0
2021-10-21 19:00:00	SPY	ETF	452.51	452.74	452.47	452.51	31575.0
2021-10-21 19:30:00	SPY	ETF	452.55	452.64	452.37	452.54	48198.0
2021-10-21 04:00:00	QQQ	ETF	374.09	374.09	373.77	373.85	30847.0
2021-10-21 04:30:00	QQQ	ETF	373.83	374.06	373.83	374.06	2720.0
2021-10-21 05:00:00	QQQ	ETF	374.11	374.3	374.11	374.3	18620.0
2021-10-21 05:30:00	QQQ	ETF	374.27	374.45	374.27	374.41	11170.0
2021-10-21 06:00:00	QQQ	ETF	374.44	374.44	374.22	374.22	4769.0
2021-10-21 06:30:00	QQQ	ETF	374.3	374.36	374.0	374.0	8351.0
2021-10-21 07:00:00	QQQ	ETF	374.06	374.24	373.88	373.88	15117.0
2021-10-21 07:30:00	QQQ	ETF	373.86	373.98	373.36	373.43	44245.0
2021-10-21 08:00:00	QQQ	ETF	374.0901	375.261	373.15	373.64	116863.0
2021-10-21 08:30:00	QQQ	ETF	373.69	374.3	373.69	373.95	132438.0
2021-10-21 09:00:00	QQQ	ETF	373.97	374.28	373.86	374.15	82839.0
2021-10-21 09:30:00	QQQ	ETF	374.14	375.31	373.85	374.96	2496341.0
2021-10-21 10:00:00	QQQ	ETF	374.95	376.1203	374.84	376.12	1861284.0
2021-10-21 10:30:00	QQQ	ETF	376.1201	376.425	375.95	376.12	1353654.0
2021-10-21 11:00:00	QQQ	ETF	376.13	376.56	375.51	375.53	1387653.0
2021-10-21 11:30:00	QQQ	ETF	375.53	375.9	375.34	375.81	973983.0
2021-10-21 12:00:00	QQQ	ETF	375.8177	376.12	375.35	376.065	1073367.0
2021-10-21 12:30:00	QQQ	ETF	376.06	376.4	375.78	376.29	707451.0

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

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