PREVIEW / etf_30min / 2023-02-08

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-08.parquet
  size:    685 KB
  rows:    27,544

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-08 04:00:00	SPY	ETF	414.35	414.76	414.13	414.53	8666.0
2023-02-08 04:30:00	SPY	ETF	414.21	414.3	413.95	414.3	7207.0
2023-02-08 05:00:00	SPY	ETF	414.32	414.32	413.84	414.16	14473.0
2023-02-08 05:30:00	SPY	ETF	414.0	414.3	413.89	414.26	12260.0
2023-02-08 06:00:00	SPY	ETF	414.33	414.38	413.89	414.0	16679.0
2023-02-08 06:30:00	SPY	ETF	414.19	414.19	413.56	413.81	18632.0
2023-02-08 07:00:00	SPY	ETF	413.89	414.43	413.81	413.95	61116.0
2023-02-08 07:30:00	SPY	ETF	413.9	414.27	413.24	413.57	86407.0
2023-02-08 08:00:00	SPY	ETF	414.09	415.7	413.15	413.35	207347.0
2023-02-08 08:30:00	SPY	ETF	413.37	413.53	413.13	413.38	278556.0
2023-02-08 09:00:00	SPY	ETF	413.35	413.65	412.94	413.16	374379.0
2023-02-08 09:30:00	SPY	ETF	413.13	414.42	412.77	414.09	5565063.0
2023-02-08 10:00:00	SPY	ETF	414.07	414.53	412.96	413.37	3831095.0
2023-02-08 10:30:00	SPY	ETF	413.35	413.35	412.01	412.45	4152372.0
2023-02-08 11:00:00	SPY	ETF	412.44	412.53	410.43	410.8	4877746.0
2023-02-08 11:30:00	SPY	ETF	410.8	411.52	410.15	411.44	4186015.0
2023-02-08 12:00:00	SPY	ETF	411.44	411.81	410.555	411.695	3072955.0
2023-02-08 12:30:00	SPY	ETF	411.71	411.995	410.69	411.89	2189881.0
2023-02-08 13:00:00	SPY	ETF	411.89	412.61	411.63	411.64	3028557.0
2023-02-08 13:30:00	SPY	ETF	411.645	411.75	410.94	411.41	2502273.0
2023-02-08 14:00:00	SPY	ETF	411.41	412.15	410.85	411.17	2822480.0
2023-02-08 14:30:00	SPY	ETF	411.175	411.55	410.49	411.3539	2571969.0
2023-02-08 15:00:00	SPY	ETF	411.36	411.435	409.93	410.53	4836115.0
2023-02-08 15:30:00	SPY	ETF	410.54	411.17	410.29	410.66	9484813.0
2023-02-08 16:00:00	SPY	ETF	410.67	410.88	410.4	410.79	2727830.0
2023-02-08 16:30:00	SPY	ETF	410.79	411.07	410.65	411.0	161051.0
2023-02-08 17:00:00	SPY	ETF	410.97	411.05	410.89	410.99	41204.0
2023-02-08 17:30:00	SPY	ETF	411.0	411.0	410.85	410.9	36761.0
2023-02-08 18:00:00	SPY	ETF	410.9	410.98	410.57	410.9	143187.0
2023-02-08 18:30:00	SPY	ETF	410.9	411.27	410.9	411.16	30544.0
2023-02-08 19:00:00	SPY	ETF	411.2	411.43	411.18	411.31	15504.0
2023-02-08 19:30:00	SPY	ETF	411.3	411.43	411.25	411.4087	49299.0
2023-02-08 04:00:00	QQQ	ETF	309.53	309.89	309.25	309.78	16579.0
2023-02-08 04:30:00	QQQ	ETF	309.57	309.6	309.09	309.46	15296.0
2023-02-08 05:00:00	QQQ	ETF	309.51	309.51	308.88	309.05	48735.0
2023-02-08 05:30:00	QQQ	ETF	308.98	309.59	308.87	309.57	23386.0
2023-02-08 06:00:00	QQQ	ETF	309.57	309.68	309.15	309.38	27644.0
2023-02-08 06:30:00	QQQ	ETF	309.48	309.6	309.18	309.4	36074.0
2023-02-08 07:00:00	QQQ	ETF	309.44	310.18	309.27	309.54	143563.0
2023-02-08 07:30:00	QQQ	ETF	309.53	309.97	308.84	309.2	183284.0
2023-02-08 08:00:00	QQQ	ETF	309.28	310.79	308.7	308.85	200136.0
2023-02-08 08:30:00	QQQ	ETF	308.8	309.07	308.48	308.71	169794.0
2023-02-08 09:00:00	QQQ	ETF	308.7	309.88	308.22	308.55	606605.0
2023-02-08 09:30:00	QQQ	ETF	308.54	309.5	307.31	308.19	4801187.0
2023-02-08 10:00:00	QQQ	ETF	308.19	309.0	307.12	307.49	3576702.0
2023-02-08 10:30:00	QQQ	ETF	307.46	307.46	305.76	306.04	3459729.0
2023-02-08 11:00:00	QQQ	ETF	306.015	306.225	303.82	304.2399	3337360.0
2023-02-08 11:30:00	QQQ	ETF	304.22	305.42	303.79	305.33	2812310.0
2023-02-08 12:00:00	QQQ	ETF	305.34	305.69	304.43	305.54	1913475.0
2023-02-08 12:30:00	QQQ	ETF	305.56	305.84	304.42	305.59	1570326.0

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

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