PREVIEW / etf_30min / 2022-08-17

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-17.parquet
  size:    661 KB
  rows:    26,439

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-17 04:00:00	SPY	ETF	428.76	428.85	428.42	428.44	19863.0
2022-08-17 04:30:00	SPY	ETF	428.35	428.38	428.06	428.08	9941.0
2022-08-17 05:00:00	SPY	ETF	428.07	428.35	428.05	428.22	11514.0
2022-08-17 05:30:00	SPY	ETF	428.09	428.12	427.39	427.58	25972.0
2022-08-17 06:00:00	SPY	ETF	427.44	427.51	426.88	427.1	35082.0
2022-08-17 06:30:00	SPY	ETF	427.05	427.15	426.57	426.92	82685.0
2022-08-17 07:00:00	SPY	ETF	426.97	427.1	426.16	426.36	107489.0
2022-08-17 07:30:00	SPY	ETF	426.35	426.43	426.03	426.35	169756.0
2022-08-17 08:00:00	SPY	ETF	427.1416	429.8654	426.03	426.32	827869.0
2022-08-17 08:30:00	SPY	ETF	426.19	426.63	425.61	426.01	496250.0
2022-08-17 09:00:00	SPY	ETF	425.99	426.34	425.71	425.9	411905.0
2022-08-17 09:30:00	SPY	ETF	425.95	427.41	425.9	426.975	5746810.0
2022-08-17 10:00:00	SPY	ETF	426.975	427.53	425.92	426.5999	3284714.0
2022-08-17 10:30:00	SPY	ETF	426.6	426.83	425.38	425.51	3102947.0
2022-08-17 11:00:00	SPY	ETF	425.52	426.29	425.31	426.17	2387612.0
2022-08-17 11:30:00	SPY	ETF	426.17	426.53	424.54	424.8911	3030855.0
2022-08-17 12:00:00	SPY	ETF	424.9	426.23	424.87	426.21	2403059.0
2022-08-17 12:30:00	SPY	ETF	426.21	426.85	426.02	426.5099	1820933.0
2022-08-17 13:00:00	SPY	ETF	426.51	426.97	426.04	426.9	1280223.0
2022-08-17 13:30:00	SPY	ETF	426.89	427.14	426.54	426.7	1476664.0
2022-08-17 14:00:00	SPY	ETF	426.69	429.16	426.34	428.6299	6230087.0
2022-08-17 14:30:00	SPY	ETF	428.64	429.5	427.74	427.7699	3436333.0
2022-08-17 15:00:00	SPY	ETF	427.7666	428.5437	426.36	427.165	3303622.0
2022-08-17 15:30:00	SPY	ETF	427.17	427.29	426.161	426.67	5061714.0
2022-08-17 16:00:00	SPY	ETF	426.66	427.16	426.59	427.02	2077890.0
2022-08-17 16:30:00	SPY	ETF	427.03	427.12	426.98	427.06	70435.0
2022-08-17 17:00:00	SPY	ETF	427.1	427.1	426.95	427.0	31935.0
2022-08-17 17:30:00	SPY	ETF	427.0	427.03	426.82	426.85	21427.0
2022-08-17 18:00:00	SPY	ETF	426.87	426.9	426.4	426.6	56711.0
2022-08-17 18:30:00	SPY	ETF	426.63	426.65	426.13	426.22	11715.0
2022-08-17 19:00:00	SPY	ETF	426.22	426.23	425.83	425.84	23362.0
2022-08-17 19:30:00	SPY	ETF	425.86	426.08	425.71	425.93	25061.0
2022-08-17 04:00:00	QQQ	ETF	331.28	331.28	330.81	330.92	24446.0
2022-08-17 04:30:00	QQQ	ETF	330.82	330.91	330.5	330.75	13445.0
2022-08-17 05:00:00	QQQ	ETF	330.64	331.0	330.64	330.92	8030.0
2022-08-17 05:30:00	QQQ	ETF	331.01	331.01	330.07	330.1	33663.0
2022-08-17 06:00:00	QQQ	ETF	330.24	330.24	329.72	329.89	25174.0
2022-08-17 06:30:00	QQQ	ETF	329.89	330.08	329.53	329.92	61057.0
2022-08-17 07:00:00	QQQ	ETF	329.93	330.09	329.14	329.27	211402.0
2022-08-17 07:30:00	QQQ	ETF	329.2	329.38	329.0	329.28	144032.0
2022-08-17 08:00:00	QQQ	ETF	329.84	332.529	329.05	329.4	231840.0
2022-08-17 08:30:00	QQQ	ETF	329.21	329.93	328.78	329.18	276611.0
2022-08-17 09:00:00	QQQ	ETF	329.15	329.46	328.8	328.99	218902.0
2022-08-17 09:30:00	QQQ	ETF	329.07	330.22	328.25	329.46	4274089.0
2022-08-17 10:00:00	QQQ	ETF	329.46	330.03	327.8	328.35	2468440.0
2022-08-17 10:30:00	QQQ	ETF	328.36	328.41	326.775	326.94	2782892.0
2022-08-17 11:00:00	QQQ	ETF	326.92	327.96	326.82	327.71	2083758.0
2022-08-17 11:30:00	QQQ	ETF	327.715	328.14	326.36	326.79	2048032.0
2022-08-17 12:00:00	QQQ	ETF	326.8	327.8624	326.79	327.7867	1377918.0
2022-08-17 12:30:00	QQQ	ETF	327.79	328.48	327.68	328.0899	1447167.0

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

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