PREVIEW / etf_30min / 2022-07-06

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-06.parquet
  size:    655 KB
  rows:    26,195

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-06 04:00:00	SPY	ETF	382.25	382.5	381.48	381.53	29508.0
2022-07-06 04:30:00	SPY	ETF	381.2	381.2	380.51	380.72	29823.0
2022-07-06 05:00:00	SPY	ETF	380.75	381.43	380.21	381.43	15687.0
2022-07-06 05:30:00	SPY	ETF	381.45	381.78	380.98	381.77	12009.0
2022-07-06 06:00:00	SPY	ETF	381.73	382.1	381.58	382.09	36394.0
2022-07-06 06:30:00	SPY	ETF	382.1	382.22	381.14	381.42	17388.0
2022-07-06 07:00:00	SPY	ETF	381.28	381.33	380.92	380.93	64396.0
2022-07-06 07:30:00	SPY	ETF	380.97	381.14	380.14	380.47	104817.0
2022-07-06 08:00:00	SPY	ETF	380.99	382.99	379.96	380.66	269003.0
2022-07-06 08:30:00	SPY	ETF	380.72	382.2	380.7	381.6	232990.0
2022-07-06 09:00:00	SPY	ETF	381.6	382.34	381.49	382.11	290467.0
2022-07-06 09:30:00	SPY	ETF	382.11	383.66	380.81	382.12	5931330.0
2022-07-06 10:00:00	SPY	ETF	382.13	383.48	380.62	382.16	4926228.0
2022-07-06 10:30:00	SPY	ETF	382.17	382.52	380.86	381.59	2762239.0
2022-07-06 11:00:00	SPY	ETF	381.58	381.7	380.18	380.57	2882128.0
2022-07-06 11:30:00	SPY	ETF	380.57	380.855	379.6	380.7064	2905162.0
2022-07-06 12:00:00	SPY	ETF	380.72	380.93	379.92	380.65	1568377.0
2022-07-06 12:30:00	SPY	ETF	380.64	381.07	380.35	380.9526	1493650.0
2022-07-06 13:00:00	SPY	ETF	380.93	381.99	380.92	381.378	1776430.0
2022-07-06 13:30:00	SPY	ETF	381.375	382.1	381.23	381.88	1746194.0
2022-07-06 14:00:00	SPY	ETF	381.88	383.25	380.69	383.12	6162459.0
2022-07-06 14:30:00	SPY	ETF	383.15	385.08	382.78	384.55	5784327.0
2022-07-06 15:00:00	SPY	ETF	384.56	385.42	383.51	385.265	4490199.0
2022-07-06 15:30:00	SPY	ETF	385.27	385.87	382.5	383.31	8447255.0
2022-07-06 16:00:00	SPY	ETF	383.31	383.77	383.19	383.64	2178604.0
2022-07-06 16:30:00	SPY	ETF	383.62	383.71	383.49	383.71	139283.0
2022-07-06 17:00:00	SPY	ETF	383.7	383.78	383.65	383.7	24131.0
2022-07-06 17:30:00	SPY	ETF	383.68	383.77	383.6601	383.75	23294.0
2022-07-06 18:00:00	SPY	ETF	383.74	383.85	383.5	383.65	24973.0
2022-07-06 18:30:00	SPY	ETF	383.65	383.65	383.35	383.38	19925.0
2022-07-06 19:00:00	SPY	ETF	383.52	383.59	383.26	383.28	9744.0
2022-07-06 19:30:00	SPY	ETF	383.37	383.8	383.37	383.58	50585.0
2022-07-06 04:00:00	QQQ	ETF	287.55	287.63	286.67	286.68	58824.0
2022-07-06 04:30:00	QQQ	ETF	286.51	286.51	285.8	286.08	59873.0
2022-07-06 05:00:00	QQQ	ETF	286.1	286.6	285.65	286.56	33752.0
2022-07-06 05:30:00	QQQ	ETF	286.64	286.93	286.21	286.87	31696.0
2022-07-06 06:00:00	QQQ	ETF	286.91	287.14	286.64	287.14	23210.0
2022-07-06 06:30:00	QQQ	ETF	287.05	287.2	286.22	286.37	25186.0
2022-07-06 07:00:00	QQQ	ETF	286.44	286.47	285.98	286.05	109511.0
2022-07-06 07:30:00	QQQ	ETF	286.05	286.24	285.31	285.57	138176.0
2022-07-06 08:00:00	QQQ	ETF	286.38	288.38	285.02	285.8	266279.0
2022-07-06 08:30:00	QQQ	ETF	285.99	287.28	285.92	286.94	540672.0
2022-07-06 09:00:00	QQQ	ETF	286.92	287.69	286.8	287.35	583679.0
2022-07-06 09:30:00	QQQ	ETF	287.35	288.7355	285.63	288.02	8128944.0
2022-07-06 10:00:00	QQQ	ETF	287.95	288.57	285.9	287.18	5512053.0
2022-07-06 10:30:00	QQQ	ETF	287.2	288.16	286.63	287.84	2680622.0
2022-07-06 11:00:00	QQQ	ETF	287.78	288.1185	286.38	286.55	2182148.0
2022-07-06 11:30:00	QQQ	ETF	286.56	286.77	285.59	286.605	1995855.0
2022-07-06 12:00:00	QQQ	ETF	286.605	287.15	286.18	286.96	1349190.0
2022-07-06 12:30:00	QQQ	ETF	286.96	287.34	286.6	287.25	1379314.0

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

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