PREVIEW / etf_30min / 2023-08-16

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-08-16.parquet
  size:    714 KB
  rows:    28,341

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
2023-08-16 04:00:00	SPY	ETF	443.71	444.29	443.71	444.29	26751.0
2023-08-16 04:30:00	SPY	ETF	444.24	444.33	443.91	443.94	20813.0
2023-08-16 05:00:00	SPY	ETF	443.98	444.06	443.16	443.4	28992.0
2023-08-16 05:30:00	SPY	ETF	443.43	443.52	442.89	443.12	14863.0
2023-08-16 06:00:00	SPY	ETF	443.15	443.26	442.88	443.21	17385.0
2023-08-16 06:30:00	SPY	ETF	443.21	443.28	442.94	443.06	21394.0
2023-08-16 07:00:00	SPY	ETF	443.05	443.07	442.48	442.92	29111.0
2023-08-16 07:30:00	SPY	ETF	442.85	443.21	442.83	443.19	140445.0
2023-08-16 08:00:00	SPY	ETF	442.95	444.01	442.5	442.58	193954.0
2023-08-16 08:30:00	SPY	ETF	442.61	442.95	442.12	442.15	192103.0
2023-08-16 09:00:00	SPY	ETF	442.16	442.52	442.09	442.45	336309.0
2023-08-16 09:30:00	SPY	ETF	442.46	444.18	442.38	443.5199	5386887.0
2023-08-16 10:00:00	SPY	ETF	443.515	444.1393	442.96	443.4	3312359.0
2023-08-16 10:30:00	SPY	ETF	443.375	444.0	443.055	443.94	2456688.0
2023-08-16 11:00:00	SPY	ETF	443.95	444.16	443.31	443.53	2500371.0
2023-08-16 11:30:00	SPY	ETF	443.505	443.59	442.28	442.53	2774365.0
2023-08-16 12:00:00	SPY	ETF	442.52	442.83	441.71	441.82	3235305.0
2023-08-16 12:30:00	SPY	ETF	441.81	442.41	441.725	441.765	2233780.0
2023-08-16 13:00:00	SPY	ETF	441.77	442.04	440.98	441.32	3384660.0
2023-08-16 13:30:00	SPY	ETF	441.325	442.615	441.09	442.28	3094353.0
2023-08-16 14:00:00	SPY	ETF	442.29	442.86	440.87	442.62	4756978.0
2023-08-16 14:30:00	SPY	ETF	442.61	443.09	441.43	441.82	3463834.0
2023-08-16 15:00:00	SPY	ETF	441.82	441.82	439.79	440.12	5962332.0
2023-08-16 15:30:00	SPY	ETF	440.14	440.65	439.53	439.63	13064500.0
2023-08-16 16:00:00	SPY	ETF	439.63	440.0	439.0	439.52	3017125.0
2023-08-16 16:30:00	SPY	ETF	439.49	439.68	439.44	439.66	218227.0
2023-08-16 17:00:00	SPY	ETF	439.7	439.75	439.61	439.7143	13581.0
2023-08-16 17:30:00	SPY	ETF	439.64	439.64	439.56	439.6	527184.0
2023-08-16 18:00:00	SPY	ETF	439.63	440.0	439.63	440.0	37717.0
2023-08-16 18:30:00	SPY	ETF	439.99	440.02	439.8	439.81	11274.0
2023-08-16 19:00:00	SPY	ETF	439.74	439.78	439.64	439.71	11669.0
2023-08-16 19:30:00	SPY	ETF	439.73	439.8	439.48	439.54	29464.0
2023-08-16 04:00:00	QQQ	ETF	367.35	367.89	366.87	367.89	20812.0
2023-08-16 04:30:00	QQQ	ETF	367.83	367.86	367.5	367.56	12598.0
2023-08-16 05:00:00	QQQ	ETF	367.52	367.64	366.73	366.92	31839.0
2023-08-16 05:30:00	QQQ	ETF	367.03	367.08	366.5	366.79	18692.0
2023-08-16 06:00:00	QQQ	ETF	366.83	367.03	366.64	367.01	32951.0
2023-08-16 06:30:00	QQQ	ETF	366.98	367.06	366.56	366.7	20031.0
2023-08-16 07:00:00	QQQ	ETF	366.62	366.71	365.84	366.33	144119.0
2023-08-16 07:30:00	QQQ	ETF	366.33	366.66	366.25	366.6	106509.0
2023-08-16 08:00:00	QQQ	ETF	365.9219	367.9304	365.88	366.07	248806.0
2023-08-16 08:30:00	QQQ	ETF	366.08	366.36	365.5299	365.6	148329.0
2023-08-16 09:00:00	QQQ	ETF	365.59	365.88	365.54	365.85	192244.0
2023-08-16 09:30:00	QQQ	ETF	365.87	367.03	365.2	366.41	4494707.0
2023-08-16 10:00:00	QQQ	ETF	366.38	367.43	365.65	366.45	2740609.0
2023-08-16 10:30:00	QQQ	ETF	366.42	367.24	366.21	367.01	1778445.0
2023-08-16 11:00:00	QQQ	ETF	367.02	367.34	366.13	366.352	1593631.0
2023-08-16 11:30:00	QQQ	ETF	366.33	366.36	364.77	365.02	2293696.0
2023-08-16 12:00:00	QQQ	ETF	365.02	365.3499	364.12	364.21	3615124.0
2023-08-16 12:30:00	QQQ	ETF	364.2	364.935	364.11	364.32	1691338.0

> showing 50 of 28,341 rows — these rows as CSV

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