PREVIEW / etf_30min / 2023-02-15

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-15.parquet
  size:    698 KB
  rows:    27,625

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-02-15 04:00:00	SPY	ETF	410.64	411.45	410.0	411.28	12805.0
2023-02-15 04:30:00	SPY	ETF	411.32	411.58	411.32	411.35	4243.0
2023-02-15 05:00:00	SPY	ETF	411.3	411.31	411.0	411.0	4818.0
2023-02-15 05:30:00	SPY	ETF	410.97	411.47	410.97	411.41	5203.0
2023-02-15 06:00:00	SPY	ETF	411.44	411.5	411.11	411.34	43953.0
2023-02-15 06:30:00	SPY	ETF	411.3	411.42	410.99	411.22	69886.0
2023-02-15 07:00:00	SPY	ETF	411.28	412.25	411.28	411.88	65984.0
2023-02-15 07:30:00	SPY	ETF	411.88	411.97	411.26	411.5	145410.0
2023-02-15 08:00:00	SPY	ETF	411.31	412.26	410.31	410.97	211560.0
2023-02-15 08:30:00	SPY	ETF	410.98	411.7	409.8	411.04	468174.0
2023-02-15 09:00:00	SPY	ETF	411.01	411.11	409.91	410.33	317800.0
2023-02-15 09:30:00	SPY	ETF	410.36	411.63	409.74	410.3	5752994.0
2023-02-15 10:00:00	SPY	ETF	410.32	411.41	409.47	410.87	4178323.0
2023-02-15 10:30:00	SPY	ETF	410.85	411.67	410.47	410.67	2713029.0
2023-02-15 11:00:00	SPY	ETF	410.66	412.16	410.58	412.09	2744495.0
2023-02-15 11:30:00	SPY	ETF	412.11	412.76	411.45	412.17	3145457.0
2023-02-15 12:00:00	SPY	ETF	412.16	412.3099	410.9	410.9999	2386413.0
2023-02-15 12:30:00	SPY	ETF	411.02	411.86	410.8136	411.52	2135897.0
2023-02-15 13:00:00	SPY	ETF	411.52	412.4099	411.18	412.34	1696106.0
2023-02-15 13:30:00	SPY	ETF	412.34	412.99	412.1	412.98	2416267.0
2023-02-15 14:00:00	SPY	ETF	412.98	413.53	412.82	413.1901	3631971.0
2023-02-15 14:30:00	SPY	ETF	413.21	413.52	412.3	412.43	2533354.0
2023-02-15 15:00:00	SPY	ETF	412.43	413.0599	412.43	412.81	2386644.0
2023-02-15 15:30:00	SPY	ETF	412.805	414.0	412.7294	413.99	6205892.0
2023-02-15 16:00:00	SPY	ETF	413.99	414.27	412.1489	414.05	3205272.0
2023-02-15 16:30:00	SPY	ETF	414.05	414.21	414.01	414.1	140365.0
2023-02-15 17:00:00	SPY	ETF	414.1	414.13	413.85	413.98	112656.0
2023-02-15 17:30:00	SPY	ETF	413.98	413.99	413.916	413.95	9741.0
2023-02-15 18:00:00	SPY	ETF	413.9	414.0	413.73	414.0	57542.0
2023-02-15 18:30:00	SPY	ETF	414.01	414.1	413.97	414.07	12665.0
2023-02-15 19:00:00	SPY	ETF	414.09	414.5	414.07	414.25	30121.0
2023-02-15 19:30:00	SPY	ETF	414.3	414.4	413.98	414.37	41625.0
2023-02-15 04:00:00	QQQ	ETF	305.35	305.81	305.32	305.62	57391.0
2023-02-15 04:30:00	QQQ	ETF	305.48	305.73	305.42	305.42	11924.0
2023-02-15 05:00:00	QQQ	ETF	305.39	305.39	305.15	305.15	22915.0
2023-02-15 05:30:00	QQQ	ETF	305.18	305.57	305.07	305.5	23360.0
2023-02-15 06:00:00	QQQ	ETF	305.48	305.55	305.25	305.4	18052.0
2023-02-15 06:30:00	QQQ	ETF	305.47	305.57	305.1	305.3	23431.0
2023-02-15 07:00:00	QQQ	ETF	305.41	306.46	305.41	306.23	102541.0
2023-02-15 07:30:00	QQQ	ETF	306.25	306.34	305.64	305.88	126748.0
2023-02-15 08:00:00	QQQ	ETF	305.5232	306.98	304.6	305.45	176732.0
2023-02-15 08:30:00	QQQ	ETF	305.45	306.35	304.49	305.62	851228.0
2023-02-15 09:00:00	QQQ	ETF	305.62	305.76	304.61	304.84	424870.0
2023-02-15 09:30:00	QQQ	ETF	304.9	306.79	304.65	305.14	5076238.0
2023-02-15 10:00:00	QQQ	ETF	305.14	306.1099	304.2	305.52	2823695.0
2023-02-15 10:30:00	QQQ	ETF	305.56	306.31	304.96	305.13	1970803.0
2023-02-15 11:00:00	QQQ	ETF	305.12	306.87	305.03	306.81	1857208.0
2023-02-15 11:30:00	QQQ	ETF	306.81	307.7577	306.19	307.17	2496948.0
2023-02-15 12:00:00	QQQ	ETF	307.17	307.32	306.2	306.4301	1891045.0
2023-02-15 12:30:00	QQQ	ETF	306.39	307.17	306.22	306.74	1721467.0

> showing 50 of 27,625 rows — these rows as CSV

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