PREVIEW / etf_30min / 2022-08-15

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-15.parquet
  size:    667 KB
  rows:    26,203

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
2022-08-15 04:00:00	SPY	ETF	425.0	425.59	424.96	425.28	34817.0
2022-08-15 04:30:00	SPY	ETF	425.34	425.55	425.13	425.13	6933.0
2022-08-15 05:00:00	SPY	ETF	425.1	425.21	424.71	424.8	33842.0
2022-08-15 05:30:00	SPY	ETF	424.84	425.06	424.6	425.03	13550.0
2022-08-15 06:00:00	SPY	ETF	425.07	425.19	424.64	424.67	29190.0
2022-08-15 06:30:00	SPY	ETF	424.63	425.24	424.58	425.19	55578.0
2022-08-15 07:00:00	SPY	ETF	425.13	425.3	425.04	425.12	95595.0
2022-08-15 07:30:00	SPY	ETF	425.13	425.15	424.4	424.62	105446.0
2022-08-15 08:00:00	SPY	ETF	425.19	426.38	424.33	425.01	156612.0
2022-08-15 08:30:00	SPY	ETF	425.05	425.12	423.7	423.92	796689.0
2022-08-15 09:00:00	SPY	ETF	423.91	424.77	423.87	424.76	233463.0
2022-08-15 09:30:00	SPY	ETF	424.765	427.34	424.71	426.93	4978716.0
2022-08-15 10:00:00	SPY	ETF	426.945	426.96	425.56	426.05	3031497.0
2022-08-15 10:30:00	SPY	ETF	426.055	426.649	425.68	425.76	2393156.0
2022-08-15 11:00:00	SPY	ETF	425.78	426.39	425.44	426.3499	2125071.0
2022-08-15 11:30:00	SPY	ETF	426.35	428.25	426.31	427.99	3080775.0
2022-08-15 12:00:00	SPY	ETF	428.02	428.44	427.72	428.35	1888517.0
2022-08-15 12:30:00	SPY	ETF	428.385	428.95	428.33	428.8	1972584.0
2022-08-15 13:00:00	SPY	ETF	428.8	429.03	428.25	428.61	1744521.0
2022-08-15 13:30:00	SPY	ETF	428.65	428.71	428.1	428.55	1352222.0
2022-08-15 14:00:00	SPY	ETF	428.54	428.68	428.1	428.59	1523405.0
2022-08-15 14:30:00	SPY	ETF	428.59	429.029	428.46	428.95	1753840.0
2022-08-15 15:00:00	SPY	ETF	428.95	429.27	428.61	429.2	2918183.0
2022-08-15 15:30:00	SPY	ETF	429.21	429.41	428.6	428.86	7213236.0
2022-08-15 16:00:00	SPY	ETF	428.86	429.021	428.34	428.5	2369207.0
2022-08-15 16:30:00	SPY	ETF	428.52	428.6254	428.36	428.46	123641.0
2022-08-15 17:00:00	SPY	ETF	428.4	428.58	428.4	428.5	8802.0
2022-08-15 17:30:00	SPY	ETF	428.48	428.49	428.4	428.45	7793.0
2022-08-15 18:00:00	SPY	ETF	428.4	428.41	428.26	428.3	53769.0
2022-08-15 18:30:00	SPY	ETF	428.35	428.43	428.24	428.31	24162.0
2022-08-15 19:00:00	SPY	ETF	428.31	428.36	428.23	428.3	10514.0
2022-08-15 19:30:00	SPY	ETF	428.28	428.63	428.28	428.49	53370.0
2022-08-15 04:00:00	QQQ	ETF	329.75	329.75	328.83	329.06	12592.0
2022-08-15 04:30:00	QQQ	ETF	329.14	329.32	328.94	328.98	18508.0
2022-08-15 05:00:00	QQQ	ETF	329.07	329.1	328.75	328.89	16721.0
2022-08-15 05:30:00	QQQ	ETF	328.78	329.1	328.55	329.06	38610.0
2022-08-15 06:00:00	QQQ	ETF	329.14	329.3	328.99	329.07	47779.0
2022-08-15 06:30:00	QQQ	ETF	329.0	329.75	329.0	329.74	52360.0
2022-08-15 07:00:00	QQQ	ETF	329.79	329.82	329.51	329.66	67542.0
2022-08-15 07:30:00	QQQ	ETF	329.63	329.63	328.94	329.18	49179.0
2022-08-15 08:00:00	QQQ	ETF	329.76	330.637	328.86	329.58	164957.0
2022-08-15 08:30:00	QQQ	ETF	329.58	329.77	328.64	328.7	188780.0
2022-08-15 09:00:00	QQQ	ETF	328.73	329.43	328.71	329.4	87939.0
2022-08-15 09:30:00	QQQ	ETF	329.42	331.83	329.4	331.4166	4704792.0
2022-08-15 10:00:00	QQQ	ETF	331.46	331.46	329.52	330.1901	2861947.0
2022-08-15 10:30:00	QQQ	ETF	330.19	330.9	329.76	329.961	1847100.0
2022-08-15 11:00:00	QQQ	ETF	329.97	330.84	329.57	330.77	1612567.0
2022-08-15 11:30:00	QQQ	ETF	330.8	332.485	330.72	332.33	2126148.0
2022-08-15 12:00:00	QQQ	ETF	332.35	332.41	331.88	332.3063	1367933.0
2022-08-15 12:30:00	QQQ	ETF	332.3199	332.6998	332.08	332.58	1262440.0

> showing 50 of 26,203 rows — these rows as CSV

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