PREVIEW / etf_30min / 2021-10-20

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-10-20.parquet
  size:    622 KB
  rows:    24,078

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-20 04:00:00	SPY	ETF	449.11	450.55	449.11	450.48	22998.0
2021-10-20 04:30:00	SPY	ETF	450.43	450.72	450.43	450.61	7922.0
2021-10-20 05:00:00	SPY	ETF	450.59	450.78	450.4	450.78	9102.0
2021-10-20 05:30:00	SPY	ETF	450.78	450.81	450.5	450.71	6071.0
2021-10-20 06:00:00	SPY	ETF	450.7	450.77	450.58	450.6	3980.0
2021-10-20 06:30:00	SPY	ETF	450.56	450.77	450.48	450.67	34984.0
2021-10-20 07:00:00	SPY	ETF	450.72	450.8	450.46	450.55	51722.0
2021-10-20 07:30:00	SPY	ETF	450.6	450.64	450.2	450.29	47336.0
2021-10-20 08:00:00	SPY	ETF	450.5699	451.0	450.11	450.7	91305.0
2021-10-20 08:30:00	SPY	ETF	450.72	450.79	450.6	450.67	77914.0
2021-10-20 09:00:00	SPY	ETF	450.68	451.15	450.48	451.13	152615.0
2021-10-20 09:30:00	SPY	ETF	451.13	452.01	451.01	451.59	4768622.0
2021-10-20 10:00:00	SPY	ETF	451.59	452.51	451.33	452.49	3207178.0
2021-10-20 10:30:00	SPY	ETF	452.48	452.732	452.05	452.0786	2880468.0
2021-10-20 11:00:00	SPY	ETF	452.07	452.359	451.83	452.02	2235120.0
2021-10-20 11:30:00	SPY	ETF	452.03	452.54	451.8	452.51	1384635.0
2021-10-20 12:00:00	SPY	ETF	452.505	452.57	452.2	452.3199	926634.0
2021-10-20 12:30:00	SPY	ETF	452.32	452.56	452.3098	452.5	1061072.0
2021-10-20 13:00:00	SPY	ETF	452.5	452.53	451.02	451.7999	3206866.0
2021-10-20 13:30:00	SPY	ETF	451.8	451.9	451.5	451.8	1405190.0
2021-10-20 14:00:00	SPY	ETF	451.805	452.35	451.72	452.145	2155061.0
2021-10-20 14:30:00	SPY	ETF	452.14	452.36	452.04	452.23	1583050.0
2021-10-20 15:00:00	SPY	ETF	452.23	452.51	451.975	451.99	2124182.0
2021-10-20 15:30:00	SPY	ETF	451.99	452.4	451.635	452.4	6915898.0
2021-10-20 16:00:00	SPY	ETF	452.4	452.58	451.85	451.95	2775582.0
2021-10-20 16:30:00	SPY	ETF	451.98	452.05	451.94	452.0	121288.0
2021-10-20 17:00:00	SPY	ETF	452.03	452.41	451.95	452.03	216948.0
2021-10-20 17:30:00	SPY	ETF	452.02	452.02	451.95	451.97	6107.0
2021-10-20 18:00:00	SPY	ETF	451.97	452.15	451.81	451.94	118844.0
2021-10-20 18:30:00	SPY	ETF	452.41	452.41	451.9	451.91	17067.0
2021-10-20 19:00:00	SPY	ETF	451.98	452.06	451.8	451.85	18605.0
2021-10-20 19:30:00	SPY	ETF	451.87	451.9	451.51	451.59	38378.0
2021-10-20 04:00:00	QQQ	ETF	375.0	375.04	374.84	375.01	46531.0
2021-10-20 04:30:00	QQQ	ETF	374.97	375.33	374.97	375.16	6410.0
2021-10-20 05:00:00	QQQ	ETF	375.14	375.42	375.1	375.41	13423.0
2021-10-20 05:30:00	QQQ	ETF	375.47	375.57	375.26	375.44	15168.0
2021-10-20 06:00:00	QQQ	ETF	375.48	375.58	375.4	375.46	5678.0
2021-10-20 06:30:00	QQQ	ETF	375.53	375.69	375.36	375.66	11648.0
2021-10-20 07:00:00	QQQ	ETF	375.61	375.73	375.46	375.51	38980.0
2021-10-20 07:30:00	QQQ	ETF	375.53	375.54	375.12	375.2	45191.0
2021-10-20 08:00:00	QQQ	ETF	375.4696	375.86	374.72	375.85	113150.0
2021-10-20 08:30:00	QQQ	ETF	375.84	375.95	375.66	375.8	132980.0
2021-10-20 09:00:00	QQQ	ETF	375.8	375.95	375.62	375.95	216879.0
2021-10-20 09:30:00	QQQ	ETF	375.94	376.39	375.38	375.6	3741253.0
2021-10-20 10:00:00	QQQ	ETF	375.59	376.3599	374.96	376.34	2444483.0
2021-10-20 10:30:00	QQQ	ETF	376.36	376.565	375.52	375.53	1929617.0
2021-10-20 11:00:00	QQQ	ETF	375.545	375.78	375.035	375.42	1804178.0
2021-10-20 11:30:00	QQQ	ETF	375.41	375.97	375.17	375.915	983055.0
2021-10-20 12:00:00	QQQ	ETF	375.91	375.94	375.16	375.1912	783474.0
2021-10-20 12:30:00	QQQ	ETF	375.2	375.4762	374.92	375.23	934232.0

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

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