PREVIEW / etf_30min / 2021-11-12

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-12.parquet
  size:    610 KB
  rows:    23,624

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-11-12 04:00:00	SPY	ETF	464.6	464.6	464.06	464.07	28962.0
2021-11-12 04:30:00	SPY	ETF	464.03	464.31	464.0	464.31	5254.0
2021-11-12 05:00:00	SPY	ETF	464.35	464.35	464.22	464.23	9100.0
2021-11-12 05:30:00	SPY	ETF	464.31	464.7	464.25	464.58	13197.0
2021-11-12 06:00:00	SPY	ETF	464.55	464.7	464.48	464.64	27722.0
2021-11-12 06:30:00	SPY	ETF	464.66	465.05	464.66	465.02	87635.0
2021-11-12 07:00:00	SPY	ETF	464.93	464.93	464.8	464.81	21689.0
2021-11-12 07:30:00	SPY	ETF	464.84	464.88	464.6	464.61	20815.0
2021-11-12 08:00:00	SPY	ETF	464.61	465.02	464.1	465.02	77834.0
2021-11-12 08:30:00	SPY	ETF	465.02	465.13	464.92	465.05	117314.0
2021-11-12 09:00:00	SPY	ETF	465.05	465.44	465.05	465.13	134180.0
2021-11-12 09:30:00	SPY	ETF	465.12	465.18	464.11	464.31	3232178.0
2021-11-12 10:00:00	SPY	ETF	464.29	464.95	464.195	464.5	2394060.0
2021-11-12 10:30:00	SPY	ETF	464.51	465.37	464.15	465.36	1945899.0
2021-11-12 11:00:00	SPY	ETF	465.36	467.07	465.35	466.83	4134802.0
2021-11-12 11:30:00	SPY	ETF	466.83	467.28	466.61	467.13	2327929.0
2021-11-12 12:00:00	SPY	ETF	467.13	467.37	466.86	467.181	1854404.0
2021-11-12 12:30:00	SPY	ETF	467.18	467.18	466.67	466.805	1400824.0
2021-11-12 13:00:00	SPY	ETF	466.81	466.83	466.38	466.67	1732408.0
2021-11-12 13:30:00	SPY	ETF	466.67	467.0	466.63	466.96	813516.0
2021-11-12 14:00:00	SPY	ETF	466.96	467.0	466.47	466.525	1511880.0
2021-11-12 14:30:00	SPY	ETF	466.53	466.85	466.255	466.6666	1280461.0
2021-11-12 15:00:00	SPY	ETF	466.66	467.2895	466.6	467.27	2289982.0
2021-11-12 15:30:00	SPY	ETF	467.275	467.86	467.01	467.26	9321447.0
2021-11-12 16:00:00	SPY	ETF	467.25	468.03	467.17	468.02	3194255.0
2021-11-12 16:30:00	SPY	ETF	468.0	468.04	467.27	467.62	608054.0
2021-11-12 17:00:00	SPY	ETF	467.61	467.62	467.27	467.51	965782.0
2021-11-12 17:30:00	SPY	ETF	467.5	467.58	467.43	467.48	24344.0
2021-11-12 18:00:00	SPY	ETF	467.59	467.6	467.5301	467.5301	1200.0
2021-11-12 18:30:00	SPY	ETF	467.27	467.69	467.27	467.62	16499.0
2021-11-12 19:00:00	SPY	ETF	467.6	467.6	467.5	467.55	2073.0
2021-11-12 19:30:00	SPY	ETF	467.54	467.6	467.52	467.6	11696.0
2021-11-12 04:00:00	QQQ	ETF	391.97	391.97	391.13	391.13	22353.0
2021-11-12 04:30:00	QQQ	ETF	391.06	391.36	391.0	391.24	14669.0
2021-11-12 05:00:00	QQQ	ETF	391.26	391.36	391.11	391.2	15971.0
2021-11-12 05:30:00	QQQ	ETF	391.23	391.67	391.21	391.49	14239.0
2021-11-12 06:00:00	QQQ	ETF	391.53	391.53	391.3	391.51	9352.0
2021-11-12 06:30:00	QQQ	ETF	391.42	391.81	391.42	391.74	41822.0
2021-11-12 07:00:00	QQQ	ETF	391.75	391.75	391.56	391.65	72872.0
2021-11-12 07:30:00	QQQ	ETF	391.6	391.68	391.37	391.42	61240.0
2021-11-12 08:00:00	QQQ	ETF	391.4	391.7704	391.2	391.73	118460.0
2021-11-12 08:30:00	QQQ	ETF	391.7	391.79	391.54	391.6795	67542.0
2021-11-12 09:00:00	QQQ	ETF	391.66	392.23	391.66	391.78	132327.0
2021-11-12 09:30:00	QQQ	ETF	391.77	391.96	390.13	390.63	3621682.0
2021-11-12 10:00:00	QQQ	ETF	390.6	391.86	390.57	391.58	2094612.0
2021-11-12 10:30:00	QQQ	ETF	391.59	392.79	391.15	392.69	1687757.0
2021-11-12 11:00:00	QQQ	ETF	392.71	394.63	392.59	394.48	3145147.0
2021-11-12 11:30:00	QQQ	ETF	394.48	394.89	394.079	394.68	1973000.0
2021-11-12 12:00:00	QQQ	ETF	394.69	394.9	394.42	394.645	1192522.0
2021-11-12 12:30:00	QQQ	ETF	394.66	394.8	394.17	394.2906	1047522.0

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

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