PREVIEW / etf_30min / 2023-04-24

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-04-24.parquet
  size:    670 KB
  rows:    26,614

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-04-24 04:00:00	SPY	ETF	410.5	411.02	410.5	410.76	17948.0
2023-04-24 04:30:00	SPY	ETF	410.73	410.8	410.54	410.75	42083.0
2023-04-24 05:00:00	SPY	ETF	410.79	411.56	410.79	411.51	30974.0
2023-04-24 05:30:00	SPY	ETF	411.5	411.57	411.42	411.42	4325.0
2023-04-24 06:00:00	SPY	ETF	411.44	411.44	411.34	411.36	1720.0
2023-04-24 06:30:00	SPY	ETF	411.4	411.74	411.35	411.72	14633.0
2023-04-24 07:00:00	SPY	ETF	411.77	412.08	411.68	412.04	43778.0
2023-04-24 07:30:00	SPY	ETF	412.02	412.26	411.9	411.96	52319.0
2023-04-24 08:00:00	SPY	ETF	411.78	412.22	410.25	411.9	115425.0
2023-04-24 08:30:00	SPY	ETF	411.9	412.35	411.7	412.21	208719.0
2023-04-24 09:00:00	SPY	ETF	412.22	412.34	411.92	411.99	220073.0
2023-04-24 09:30:00	SPY	ETF	411.99	412.95	411.94	412.69	4576735.0
2023-04-24 10:00:00	SPY	ETF	412.7	413.02	412.39	412.95	2795205.0
2023-04-24 10:30:00	SPY	ETF	412.96	413.07	411.38	411.62	4893080.0
2023-04-24 11:00:00	SPY	ETF	411.6	411.72	411.12	411.23	2961426.0
2023-04-24 11:30:00	SPY	ETF	411.23	411.52	410.79	410.91	3308825.0
2023-04-24 12:00:00	SPY	ETF	410.92	411.43	410.6	411.39	2342874.0
2023-04-24 12:30:00	SPY	ETF	411.4	411.75	411.33	411.6899	2024832.0
2023-04-24 13:00:00	SPY	ETF	411.69	411.82	411.38	411.7599	1628005.0
2023-04-24 13:30:00	SPY	ETF	411.76	412.3	411.7	412.17	2849168.0
2023-04-24 14:00:00	SPY	ETF	412.18	412.4	411.87	412.005	3040581.0
2023-04-24 14:30:00	SPY	ETF	412.02	412.14	411.7	412.09	1896670.0
2023-04-24 15:00:00	SPY	ETF	412.1	412.55	412.09	412.29	2844316.0
2023-04-24 15:30:00	SPY	ETF	412.298	412.64	411.9	412.63	9214866.0
2023-04-24 16:00:00	SPY	ETF	412.62	412.8	412.4	412.76	2700853.0
2023-04-24 16:30:00	SPY	ETF	412.76	412.76	412.31	412.35	139432.0
2023-04-24 17:00:00	SPY	ETF	412.41	412.53	412.2	412.2	66798.0
2023-04-24 17:30:00	SPY	ETF	412.2499	412.26	412.15	412.2	18030.0
2023-04-24 18:00:00	SPY	ETF	412.27	412.43	412.2	412.26	83642.0
2023-04-24 18:30:00	SPY	ETF	412.29	412.35	412.21	412.21	16825.0
2023-04-24 19:00:00	SPY	ETF	412.24	412.34	412.2	412.26	14997.0
2023-04-24 19:30:00	SPY	ETF	412.26	412.39	412.23	412.25	25302.0
2023-04-24 04:00:00	QQQ	ETF	315.5	315.62	315.3	315.39	27493.0
2023-04-24 04:30:00	QQQ	ETF	315.33	315.39	315.14	315.3	15227.0
2023-04-24 05:00:00	QQQ	ETF	315.45	316.25	315.41	316.23	22692.0
2023-04-24 05:30:00	QQQ	ETF	316.26	316.49	316.19	316.3	19864.0
2023-04-24 06:00:00	QQQ	ETF	316.22	316.29	316.0	316.03	9147.0
2023-04-24 06:30:00	QQQ	ETF	316.15	316.44	315.91	316.4	71327.0
2023-04-24 07:00:00	QQQ	ETF	316.41	316.7	316.34	316.64	109234.0
2023-04-24 07:30:00	QQQ	ETF	316.65	316.85	316.38	316.46	38608.0
2023-04-24 08:00:00	QQQ	ETF	316.41	316.847	315.05	316.41	105121.0
2023-04-24 08:30:00	QQQ	ETF	316.46	316.91	315.19	316.75	173359.0
2023-04-24 09:00:00	QQQ	ETF	316.82	316.83	316.29	316.36	158498.0
2023-04-24 09:30:00	QQQ	ETF	316.37	317.7391	315.81	316.92	3732120.0
2023-04-24 10:00:00	QQQ	ETF	316.92	317.0	316.14	316.7701	2956262.0
2023-04-24 10:30:00	QQQ	ETF	316.775	316.855	314.71	315.09	3509252.0
2023-04-24 11:00:00	QQQ	ETF	315.1	315.28	314.425	314.47	2437498.0
2023-04-24 11:30:00	QQQ	ETF	314.46	314.81	313.74	314.01	2526086.0
2023-04-24 12:00:00	QQQ	ETF	314.02	314.58	313.82	314.56	1740324.0
2023-04-24 12:30:00	QQQ	ETF	314.56	314.9	314.48	314.84	1558325.0

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

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