PREVIEW / etf_30min / 2022-07-15

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-15.parquet
  size:    643 KB
  rows:    25,634

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-07-15 04:00:00	SPY	ETF	378.14	378.16	377.59	378.16	10307.0
2022-07-15 04:30:00	SPY	ETF	378.21	379.38	378.14	378.89	20450.0
2022-07-15 05:00:00	SPY	ETF	378.87	379.41	378.67	378.86	7961.0
2022-07-15 05:30:00	SPY	ETF	378.98	378.98	378.5	378.66	9512.0
2022-07-15 06:00:00	SPY	ETF	378.38	378.97	378.35	378.9	14072.0
2022-07-15 06:30:00	SPY	ETF	378.89	379.06	378.62	378.85	24295.0
2022-07-15 07:00:00	SPY	ETF	378.87	379.5	378.85	379.32	67448.0
2022-07-15 07:30:00	SPY	ETF	379.37	379.49	378.7	378.7	52532.0
2022-07-15 08:00:00	SPY	ETF	378.89	379.5	377.0	378.5	145783.0
2022-07-15 08:30:00	SPY	ETF	378.25	381.82	377.32	381.31	938356.0
2022-07-15 09:00:00	SPY	ETF	381.26	382.75	381.26	382.53	642828.0
2022-07-15 09:30:00	SPY	ETF	382.55	383.34	380.54	381.41	6971950.0
2022-07-15 10:00:00	SPY	ETF	381.64	384.31	381.43	384.19	6421694.0
2022-07-15 10:30:00	SPY	ETF	384.2	384.33	382.88	383.71	3489426.0
2022-07-15 11:00:00	SPY	ETF	383.6969	384.85	383.58	384.425	3474962.0
2022-07-15 11:30:00	SPY	ETF	384.42	384.85	383.97	384.0	2108771.0
2022-07-15 12:00:00	SPY	ETF	384.01	384.31	383.39	383.84	2044166.0
2022-07-15 12:30:00	SPY	ETF	383.85	383.99	383.22	383.77	1719388.0
2022-07-15 13:00:00	SPY	ETF	383.78	384.62	383.76	384.62	1563301.0
2022-07-15 13:30:00	SPY	ETF	384.61	384.78	383.92	384.19	2227059.0
2022-07-15 14:00:00	SPY	ETF	384.19	384.43	383.7137	384.27	2271596.0
2022-07-15 14:30:00	SPY	ETF	384.28	384.78	384.11	384.35	1746046.0
2022-07-15 15:00:00	SPY	ETF	384.3501	384.605	384.0201	384.15	2270134.0
2022-07-15 15:30:00	SPY	ETF	384.16	385.25	383.6	385.1	8864093.0
2022-07-15 16:00:00	SPY	ETF	385.1	385.25	384.81	385.19	3975699.0
2022-07-15 16:30:00	SPY	ETF	385.19	385.36	385.08	385.25	199237.0
2022-07-15 17:00:00	SPY	ETF	385.25	385.37	384.96	385.09	366959.0
2022-07-15 17:30:00	SPY	ETF	385.02	385.2	384.99	385.2	105483.0
2022-07-15 18:00:00	SPY	ETF	385.19	385.27	385.02	385.1	8922.0
2022-07-15 18:30:00	SPY	ETF	385.05	385.15	385.03	385.05	4157.0
2022-07-15 19:00:00	SPY	ETF	385.09	385.25	385.06	385.25	5960.0
2022-07-15 19:30:00	SPY	ETF	385.25	385.29	385.13	385.2	13965.0
2022-07-15 04:00:00	QQQ	ETF	286.82	287.08	286.44	287.08	42090.0
2022-07-15 04:30:00	QQQ	ETF	287.13	288.0	286.96	287.59	58449.0
2022-07-15 05:00:00	QQQ	ETF	287.59	287.91	287.25	287.48	40694.0
2022-07-15 05:30:00	QQQ	ETF	287.48	287.68	287.11	287.11	27957.0
2022-07-15 06:00:00	QQQ	ETF	287.08	287.41	286.95	287.41	17848.0
2022-07-15 06:30:00	QQQ	ETF	287.47	287.47	287.14	287.38	11726.0
2022-07-15 07:00:00	QQQ	ETF	287.37	287.77	287.3	287.67	53102.0
2022-07-15 07:30:00	QQQ	ETF	287.59	287.74	286.86	286.87	103822.0
2022-07-15 08:00:00	QQQ	ETF	286.93	288.39	286.25	286.57	348497.0
2022-07-15 08:30:00	QQQ	ETF	286.45	289.34	285.2645	288.96	975167.0
2022-07-15 09:00:00	QQQ	ETF	289.0	289.92	288.82	289.73	1021250.0
2022-07-15 09:30:00	QQQ	ETF	289.75	291.23	288.08	289.25	6775988.0
2022-07-15 10:00:00	QQQ	ETF	289.28	291.33	289.01	290.85	5471032.0
2022-07-15 10:30:00	QQQ	ETF	290.91	290.99	289.44	290.31	2316421.0
2022-07-15 11:00:00	QQQ	ETF	290.31	291.62	290.16	290.98	2725771.0
2022-07-15 11:30:00	QQQ	ETF	290.98	291.39	290.56	290.5901	1647276.0
2022-07-15 12:00:00	QQQ	ETF	290.6	290.87	289.93	290.52	1964554.0
2022-07-15 12:30:00	QQQ	ETF	290.53	290.71	289.95	290.53	1680637.0

> showing 50 of 25,634 rows — these rows as CSV

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