PREVIEW / etf_30min / 2022-08-16

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-08-16.parquet
  size:    659 KB
  rows:    26,092

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-16 04:00:00	SPY	ETF	428.49	428.69	428.15	428.62	11559.0
2022-08-16 04:30:00	SPY	ETF	428.55	428.82	428.5	428.51	5818.0
2022-08-16 05:00:00	SPY	ETF	428.44	428.44	428.04	428.19	9586.0
2022-08-16 05:30:00	SPY	ETF	428.06	428.12	427.82	428.12	10388.0
2022-08-16 06:00:00	SPY	ETF	428.11	428.17	427.76	427.9	21150.0
2022-08-16 06:30:00	SPY	ETF	427.96	428.0	427.72	427.92	11449.0
2022-08-16 07:00:00	SPY	ETF	427.87	428.52	427.72	428.51	145135.0
2022-08-16 07:30:00	SPY	ETF	428.51	428.64	428.37	428.5	68264.0
2022-08-16 08:00:00	SPY	ETF	427.87	428.74	427.76	428.44	90731.0
2022-08-16 08:30:00	SPY	ETF	428.44	428.44	427.4	427.75	218962.0
2022-08-16 09:00:00	SPY	ETF	427.76	427.92	427.55	427.68	158138.0
2022-08-16 09:30:00	SPY	ETF	427.73	428.78	427.62	428.42	3861443.0
2022-08-16 10:00:00	SPY	ETF	428.41	428.4937	427.45	427.765	2634198.0
2022-08-16 10:30:00	SPY	ETF	427.76	428.04	426.88	427.5	2777674.0
2022-08-16 11:00:00	SPY	ETF	427.5	429.22	427.43	429.095	2942791.0
2022-08-16 11:30:00	SPY	ETF	429.09	430.36	429.0	430.18	2833916.0
2022-08-16 12:00:00	SPY	ETF	430.18	430.525	429.89	429.98	1773585.0
2022-08-16 12:30:00	SPY	ETF	429.98	430.26	429.64	429.81	1189929.0
2022-08-16 13:00:00	SPY	ETF	429.815	430.5	429.66	430.315	1321041.0
2022-08-16 13:30:00	SPY	ETF	430.32	431.08	430.24	430.9999	1540132.0
2022-08-16 14:00:00	SPY	ETF	430.99	431.73	430.84	431.23	2431621.0
2022-08-16 14:30:00	SPY	ETF	431.24	431.24	428.14	429.1	4942815.0
2022-08-16 15:00:00	SPY	ETF	429.09	429.62	428.35	429.48	3048373.0
2022-08-16 15:30:00	SPY	ETF	429.48	430.43	429.44	429.66	8843956.0
2022-08-16 16:00:00	SPY	ETF	429.67	429.7	429.19	429.32	2687754.0
2022-08-16 16:30:00	SPY	ETF	429.32	429.99	429.29	429.94	206076.0
2022-08-16 17:00:00	SPY	ETF	429.89	429.94	429.81	429.82	41023.0
2022-08-16 17:30:00	SPY	ETF	429.88	429.97	429.7	429.85	510909.0
2022-08-16 18:00:00	SPY	ETF	429.87	429.87	429.46	429.55	63231.0
2022-08-16 18:30:00	SPY	ETF	429.59	429.69	429.49	429.6	16131.0
2022-08-16 19:00:00	SPY	ETF	429.6	429.62	429.38	429.38	13586.0
2022-08-16 19:30:00	SPY	ETF	429.41	429.8	429.35	429.7	39781.0
2022-08-16 04:00:00	QQQ	ETF	332.38	332.73	332.25	332.73	8663.0
2022-08-16 04:30:00	QQQ	ETF	332.68	333.1	332.65	332.79	9875.0
2022-08-16 05:00:00	QQQ	ETF	332.6	332.6	332.34	332.5	17115.0
2022-08-16 05:30:00	QQQ	ETF	332.4	332.44	332.15	332.28	11880.0
2022-08-16 06:00:00	QQQ	ETF	332.28	332.42	332.03	332.31	20225.0
2022-08-16 06:30:00	QQQ	ETF	332.21	332.48	332.14	332.31	10329.0
2022-08-16 07:00:00	QQQ	ETF	332.39	332.83	332.17	332.81	79043.0
2022-08-16 07:30:00	QQQ	ETF	332.79	332.89	332.57	332.59	59242.0
2022-08-16 08:00:00	QQQ	ETF	332.42	333.309	332.0	332.77	152748.0
2022-08-16 08:30:00	QQQ	ETF	332.8	332.82	331.76	332.17	203560.0
2022-08-16 09:00:00	QQQ	ETF	332.15	332.3	331.9	332.03	132406.0
2022-08-16 09:30:00	QQQ	ETF	332.055	332.47	330.63	331.3376	3956258.0
2022-08-16 10:00:00	QQQ	ETF	331.33	331.37	330.04	330.19	2592016.0
2022-08-16 10:30:00	QQQ	ETF	330.19	330.65	329.16	329.99	2375257.0
2022-08-16 11:00:00	QQQ	ETF	329.97	331.82	329.89	331.71	1609006.0
2022-08-16 11:30:00	QQQ	ETF	331.7	333.0	331.6008	332.825	2247797.0
2022-08-16 12:00:00	QQQ	ETF	332.838	333.06	332.25	332.2588	1826154.0
2022-08-16 12:30:00	QQQ	ETF	332.25	332.523	331.79	332.23	1284478.0

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

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