PREVIEW / etf_30min / 2021-09-03

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-09-03.parquet
  size:    589 KB
  rows:    22,368

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-09-03 04:00:00	SPY	ETF	453.91	454.05	453.91	453.97	7129.0
2021-09-03 04:30:00	SPY	ETF	454.01	454.02	453.91	453.99	3595.0
2021-09-03 05:00:00	SPY	ETF	453.85	453.93	453.82	453.9	1304.0
2021-09-03 05:30:00	SPY	ETF	453.85	453.85	453.78	453.78	2300.0
2021-09-03 06:00:00	SPY	ETF	453.88	454.08	453.81	454.08	3596.0
2021-09-03 06:30:00	SPY	ETF	454.03	454.08	453.98	454.0	12925.0
2021-09-03 07:00:00	SPY	ETF	453.93	454.0	453.89	453.99	15644.0
2021-09-03 07:30:00	SPY	ETF	453.99	454.01	453.71	453.76	51169.0
2021-09-03 08:00:00	SPY	ETF	453.77	454.02	453.66	453.89	80195.0
2021-09-03 08:30:00	SPY	ETF	453.83	454.53	452.52	453.46	847047.0
2021-09-03 09:00:00	SPY	ETF	453.44	453.7	451.91	451.98	488836.0
2021-09-03 09:30:00	SPY	ETF	451.98	452.81	451.55	452.43	5342236.0
2021-09-03 10:00:00	SPY	ETF	452.44	452.9979	452.15	452.595	3221492.0
2021-09-03 10:30:00	SPY	ETF	452.6	452.8	452.13	452.5431	2523274.0
2021-09-03 11:00:00	SPY	ETF	452.54	453.02	452.39	452.85	1839782.0
2021-09-03 11:30:00	SPY	ETF	452.84	453.05	452.52	452.59	1405846.0
2021-09-03 12:00:00	SPY	ETF	452.59	452.89	452.485	452.82	1280170.0
2021-09-03 12:30:00	SPY	ETF	452.83	452.88	452.5	452.72	1065811.0
2021-09-03 13:00:00	SPY	ETF	452.71	453.3872	452.71	453.19	1901085.0
2021-09-03 13:30:00	SPY	ETF	453.1896	453.47	453.1	453.41	1418587.0
2021-09-03 14:00:00	SPY	ETF	453.405	453.47	453.22	453.33	1177892.0
2021-09-03 14:30:00	SPY	ETF	453.325	453.45	453.21	453.37	1230129.0
2021-09-03 15:00:00	SPY	ETF	453.37	453.63	453.24	453.28	2155011.0
2021-09-03 15:30:00	SPY	ETF	453.28	453.5112	452.85	453.06	6631315.0
2021-09-03 16:00:00	SPY	ETF	453.06	453.08	452.9	453.0	1750976.0
2021-09-03 16:30:00	SPY	ETF	453.0	453.08	452.94	452.99	329088.0
2021-09-03 17:00:00	SPY	ETF	452.99	453.07	452.94	452.98	104768.0
2021-09-03 17:30:00	SPY	ETF	453.0	453.22	453.0	453.08	49843.0
2021-09-03 18:00:00	SPY	ETF	453.17	453.2	452.6	452.7	24581.0
2021-09-03 18:30:00	SPY	ETF	453.08	453.08	452.66	452.7	8981.0
2021-09-03 19:00:00	SPY	ETF	452.7	452.77	452.69	452.76	8968.0
2021-09-03 19:30:00	SPY	ETF	452.77	452.77	452.55	452.75	11048.0
2021-09-03 04:00:00	QQQ	ETF	380.87	381.02	380.83	380.84	68611.0
2021-09-03 04:30:00	QQQ	ETF	380.8	380.8	380.63	380.63	4788.0
2021-09-03 05:00:00	QQQ	ETF	380.67	380.71	380.59	380.67	2027.0
2021-09-03 05:30:00	QQQ	ETF	380.68	380.72	380.65	380.66	15647.0
2021-09-03 06:00:00	QQQ	ETF	380.65	380.83	380.65	380.8	13683.0
2021-09-03 06:30:00	QQQ	ETF	380.8	380.82	380.72	380.72	2328.0
2021-09-03 07:00:00	QQQ	ETF	380.71	380.97	380.71	380.96	11169.0
2021-09-03 07:30:00	QQQ	ETF	380.96	381.02	380.76	380.82	23249.0
2021-09-03 08:00:00	QQQ	ETF	380.86	381.0201	380.42	380.96	49208.0
2021-09-03 08:30:00	QQQ	ETF	380.99	382.19	379.53	380.49	1019888.0
2021-09-03 09:00:00	QQQ	ETF	380.43	380.65	379.14	379.19	425326.0
2021-09-03 09:30:00	QQQ	ETF	379.22	381.36	379.2	381.29	4243492.0
2021-09-03 10:00:00	QQQ	ETF	381.28	381.95	380.77	380.93	2351321.0
2021-09-03 10:30:00	QQQ	ETF	380.9	381.25	380.4	380.93	1096112.0
2021-09-03 11:00:00	QQQ	ETF	380.9	381.495	380.632	381.34	958379.0
2021-09-03 11:30:00	QQQ	ETF	381.35	381.6399	381.04	381.0892	787309.0
2021-09-03 12:00:00	QQQ	ETF	381.07	381.62	380.98	381.54	583878.0
2021-09-03 12:30:00	QQQ	ETF	381.5499	381.57	381.161	381.415	627324.0

> showing 50 of 22,368 rows — these rows as CSV

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