PREVIEW / etf_30min / 2023-05-12

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-05-12.parquet
  size:    661 KB
  rows:    26,320

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-05-12 04:00:00	SPY	ETF	413.21	413.88	413.04	413.84	25134.0
2023-05-12 04:30:00	SPY	ETF	413.85	414.0	413.78	414.0	9283.0
2023-05-12 05:00:00	SPY	ETF	414.1	414.27	413.97	414.0	41510.0
2023-05-12 05:30:00	SPY	ETF	414.0	414.08	413.71	413.71	6903.0
2023-05-12 06:00:00	SPY	ETF	413.8	413.91	413.54	413.87	21371.0
2023-05-12 06:30:00	SPY	ETF	413.86	414.04	413.7	413.84	23114.0
2023-05-12 07:00:00	SPY	ETF	413.83	413.98	413.51	413.51	50016.0
2023-05-12 07:30:00	SPY	ETF	413.501	413.68	413.4	413.53	50441.0
2023-05-12 08:00:00	SPY	ETF	413.85	413.96	412.91	413.32	138928.0
2023-05-12 08:30:00	SPY	ETF	413.24	413.66	413.21	413.44	261076.0
2023-05-12 09:00:00	SPY	ETF	413.43	413.6	413.27	413.41	129546.0
2023-05-12 09:30:00	SPY	ETF	413.41	413.64	412.52	412.73	4926205.0
2023-05-12 10:00:00	SPY	ETF	412.73	412.95	411.83	411.97	4911050.0
2023-05-12 10:30:00	SPY	ETF	411.97	411.975	411.22	411.5057	3584814.0
2023-05-12 11:00:00	SPY	ETF	411.53	412.015	410.75	410.84	2972151.0
2023-05-12 11:30:00	SPY	ETF	410.85	411.53	410.67	411.47	2731199.0
2023-05-12 12:00:00	SPY	ETF	411.48	411.58	410.01	410.0801	3124466.0
2023-05-12 12:30:00	SPY	ETF	410.09	410.47	409.45	409.57	2755739.0
2023-05-12 13:00:00	SPY	ETF	409.57	410.715	409.31	410.3099	3148320.0
2023-05-12 13:30:00	SPY	ETF	410.31	410.61	409.19	409.3101	2678483.0
2023-05-12 14:00:00	SPY	ETF	409.32	409.84	409.07	409.53	3349815.0
2023-05-12 14:30:00	SPY	ETF	409.51	410.01	409.11	409.9	2639813.0
2023-05-12 15:00:00	SPY	ETF	409.91	410.47	409.65	410.39	3125358.0
2023-05-12 15:30:00	SPY	ETF	410.4	411.67	410.39	411.61	9099542.0
2023-05-12 16:00:00	SPY	ETF	411.62	411.64	411.1	411.16	3651088.0
2023-05-12 16:30:00	SPY	ETF	411.14	411.59	411.04	411.09	907793.0
2023-05-12 17:00:00	SPY	ETF	411.1	411.22	410.95	410.98	61274.0
2023-05-12 17:30:00	SPY	ETF	411.0	411.02	410.8	410.8	29968.0
2023-05-12 18:00:00	SPY	ETF	410.88	410.93	410.81	410.88	10709.0
2023-05-12 18:30:00	SPY	ETF	410.9	410.94	410.9	410.94	5115.0
2023-05-12 19:00:00	SPY	ETF	410.94	410.95	410.9	410.9	1210.0
2023-05-12 19:30:00	SPY	ETF	410.97	410.97	410.73	410.77	15133.0
2023-05-12 04:00:00	QQQ	ETF	326.73	327.15	326.59	327.12	23156.0
2023-05-12 04:30:00	QQQ	ETF	327.1	327.1	326.92	326.98	4635.0
2023-05-12 05:00:00	QQQ	ETF	327.13	327.3	327.13	327.17	4159.0
2023-05-12 05:30:00	QQQ	ETF	327.21	327.23	326.87	326.87	7861.0
2023-05-12 06:00:00	QQQ	ETF	326.91	326.99	326.8	326.9	8916.0
2023-05-12 06:30:00	QQQ	ETF	326.93	327.06	326.87	326.94	15170.0
2023-05-12 07:00:00	QQQ	ETF	326.93	327.08	326.74	326.76	85027.0
2023-05-12 07:30:00	QQQ	ETF	326.73	326.88	326.581	326.66	100334.0
2023-05-12 08:00:00	QQQ	ETF	326.87	327.16	326.44	326.48	122065.0
2023-05-12 08:30:00	QQQ	ETF	326.47	326.9	326.4	326.62	165492.0
2023-05-12 09:00:00	QQQ	ETF	326.63	326.87	326.57	326.66	144691.0
2023-05-12 09:30:00	QQQ	ETF	326.7	327.17	326.03	326.15	3629098.0
2023-05-12 10:00:00	QQQ	ETF	326.15	326.4291	325.15	325.2621	3142365.0
2023-05-12 10:30:00	QQQ	ETF	325.26	325.35	324.65	325.04	2353424.0
2023-05-12 11:00:00	QQQ	ETF	325.05	325.71	324.5	324.57	2098366.0
2023-05-12 11:30:00	QQQ	ETF	324.57	325.265	324.3	325.21	1744396.0
2023-05-12 12:00:00	QQQ	ETF	325.2	325.25	323.945	323.99	2132703.0
2023-05-12 12:30:00	QQQ	ETF	324.0	324.27	323.13	323.345	2213144.0

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

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