PREVIEW / etf_30min / 2022-12-15

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-12-15.parquet
  size:    706 KB
  rows:    28,151

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-12-15 04:00:00	SPY	ETF	396.33	396.5	394.99	395.65	103842.0
2022-12-15 04:30:00	SPY	ETF	395.66	395.74	394.88	395.7	46342.0
2022-12-15 05:00:00	SPY	ETF	395.54	395.66	395.03	395.24	12423.0
2022-12-15 05:30:00	SPY	ETF	395.28	395.9	395.27	395.44	23787.0
2022-12-15 06:00:00	SPY	ETF	395.39	396.2	395.34	395.98	84646.0
2022-12-15 06:30:00	SPY	ETF	395.99	396.19	395.55	396.19	88041.0
2022-12-15 07:00:00	SPY	ETF	396.12	396.25	395.67	395.97	186857.0
2022-12-15 07:30:00	SPY	ETF	395.97	396.31	395.6	396.15	121029.0
2022-12-15 08:00:00	SPY	ETF	396.1008	400.07	394.5	394.73	512155.0
2022-12-15 08:30:00	SPY	ETF	394.73	398.4	393.67	394.57	937859.0
2022-12-15 09:00:00	SPY	ETF	394.49	395.05	393.65	394.27	612121.0
2022-12-15 09:30:00	SPY	ETF	394.31	395.25	391.17	391.575	9212271.0
2022-12-15 10:00:00	SPY	ETF	391.6	391.77	390.3	391.16	7983229.0
2022-12-15 10:30:00	SPY	ETF	391.14	391.94	390.25	390.7	5978591.0
2022-12-15 11:00:00	SPY	ETF	390.7	391.14	389.15	389.7801	5422999.0
2022-12-15 11:30:00	SPY	ETF	389.8	390.13	388.73	389.26	4349388.0
2022-12-15 12:00:00	SPY	ETF	389.24	390.12	389.2	389.77	3210583.0
2022-12-15 12:30:00	SPY	ETF	389.74	390.41	388.62	388.87	3854162.0
2022-12-15 13:00:00	SPY	ETF	388.89	388.975	387.885	388.39	3974853.0
2022-12-15 13:30:00	SPY	ETF	388.37	388.89	388.0	388.7501	3330337.0
2022-12-15 14:00:00	SPY	ETF	388.76	388.99	388.12	388.37	3448887.0
2022-12-15 14:30:00	SPY	ETF	388.38	390.265	388.35	390.22	5080375.0
2022-12-15 15:00:00	SPY	ETF	390.21	390.855	389.37	390.63	6004554.0
2022-12-15 15:30:00	SPY	ETF	390.63	390.88	388.94	389.65	13937210.0
2022-12-15 16:00:00	SPY	ETF	389.64	389.93	388.66	388.93	6905901.0
2022-12-15 16:30:00	SPY	ETF	388.95	389.31	388.83	389.18	303996.0
2022-12-15 17:00:00	SPY	ETF	389.0	389.63	388.9	389.14	130069.0
2022-12-15 17:30:00	SPY	ETF	389.07	389.11	388.95	389.0	92608.0
2022-12-15 18:00:00	SPY	ETF	389.05	389.73	389.05	389.58	123832.0
2022-12-15 18:30:00	SPY	ETF	389.56	389.59	389.3	389.51	122855.0
2022-12-15 19:00:00	SPY	ETF	389.55	389.84	389.55	389.65	47844.0
2022-12-15 19:30:00	SPY	ETF	389.69	389.74	389.45	389.55	45588.0
2022-12-15 04:00:00	QQQ	ETF	286.7	286.7	282.47	283.01	151015.0
2022-12-15 04:30:00	QQQ	ETF	283.15	283.22	282.45	283.13	73472.0
2022-12-15 05:00:00	QQQ	ETF	283.08	283.12	282.52	282.68	20572.0
2022-12-15 05:30:00	QQQ	ETF	282.77	283.08	282.55	282.55	27490.0
2022-12-15 06:00:00	QQQ	ETF	282.62	283.23	282.49	283.01	98519.0
2022-12-15 06:30:00	QQQ	ETF	283.1	283.34	282.78	283.34	23120.0
2022-12-15 07:00:00	QQQ	ETF	283.37	283.46	282.96	283.39	147656.0
2022-12-15 07:30:00	QQQ	ETF	283.36	283.59	283.04	283.51	97363.0
2022-12-15 08:00:00	QQQ	ETF	283.43	286.724	282.13	282.42	388930.0
2022-12-15 08:30:00	QQQ	ETF	282.39	283.44	281.33	282.24	506454.0
2022-12-15 09:00:00	QQQ	ETF	282.22	282.64	281.72	282.3	374321.0
2022-12-15 09:30:00	QQQ	ETF	282.33	283.01	279.29	279.68	5756545.0
2022-12-15 10:00:00	QQQ	ETF	279.7	279.76	278.56	279.12	4747063.0
2022-12-15 10:30:00	QQQ	ETF	279.065	279.56	278.05	278.37	3453974.0
2022-12-15 11:00:00	QQQ	ETF	278.35	278.775	276.97	277.82	3479411.0
2022-12-15 11:30:00	QQQ	ETF	277.835	278.13	276.98	277.2101	2616346.0
2022-12-15 12:00:00	QQQ	ETF	277.24	277.9	277.15	277.52	2303887.0
2022-12-15 12:30:00	QQQ	ETF	277.52	277.95	276.45	276.674	2635251.0

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

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