PREVIEW / etf_30min / 2023-03-30

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-03-30.parquet
  size:    675 KB
  rows:    27,324

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-03-30 04:00:00	SPY	ETF	402.78	403.14	402.12	402.81	60233.0
2023-03-30 04:30:00	SPY	ETF	402.81	403.12	402.8	402.98	10550.0
2023-03-30 05:00:00	SPY	ETF	402.98	403.12	402.89	403.03	11349.0
2023-03-30 05:30:00	SPY	ETF	403.02	403.12	402.81	402.98	20204.0
2023-03-30 06:00:00	SPY	ETF	403.05	403.31	403.05	403.19	11866.0
2023-03-30 06:30:00	SPY	ETF	403.24	403.85	403.24	403.75	61526.0
2023-03-30 07:00:00	SPY	ETF	403.75	403.96	403.581	403.78	67829.0
2023-03-30 07:30:00	SPY	ETF	403.76	403.84	403.41	403.67	110209.0
2023-03-30 08:00:00	SPY	ETF	403.75	403.91	401.5	403.38	224957.0
2023-03-30 08:30:00	SPY	ETF	403.44	404.18	403.26	403.93	346614.0
2023-03-30 09:00:00	SPY	ETF	403.92	404.25	403.48	404.09	348798.0
2023-03-30 09:30:00	SPY	ETF	404.09	404.14	403.51	404.07	6214967.0
2023-03-30 10:00:00	SPY	ETF	404.08	404.35	402.8144	403.82	6015381.0
2023-03-30 10:30:00	SPY	ETF	403.82	404.19	403.42	403.59	3915869.0
2023-03-30 11:00:00	SPY	ETF	403.61	404.035	403.21	403.4814	3101198.0
2023-03-30 11:30:00	SPY	ETF	403.49	403.53	402.73	403.08	3249820.0
2023-03-30 12:00:00	SPY	ETF	403.075	403.26	402.66	402.79	2122544.0
2023-03-30 12:30:00	SPY	ETF	402.8	402.81	402.06	402.37	3253666.0
2023-03-30 13:00:00	SPY	ETF	402.39	402.83	402.23	402.445	2246377.0
2023-03-30 13:30:00	SPY	ETF	402.44	402.45	401.76	402.33	2670435.0
2023-03-30 14:00:00	SPY	ETF	402.33	403.18	402.25	403.11	2825645.0
2023-03-30 14:30:00	SPY	ETF	403.1018	403.49	402.85	403.1401	3167924.0
2023-03-30 15:00:00	SPY	ETF	403.15	403.61	402.875	403.45	2772948.0
2023-03-30 15:30:00	SPY	ETF	403.44	403.78	403.3	403.7	9387555.0
2023-03-30 16:00:00	SPY	ETF	403.7	404.06	403.68	403.98	2447583.0
2023-03-30 16:30:00	SPY	ETF	403.98	404.17	403.93	403.96	257463.0
2023-03-30 17:00:00	SPY	ETF	403.96	404.0	403.87	404.0	58070.0
2023-03-30 17:30:00	SPY	ETF	403.96	404.0	403.81	403.82	15500.0
2023-03-30 18:00:00	SPY	ETF	403.81	403.81	403.44	403.51	43714.0
2023-03-30 18:30:00	SPY	ETF	403.55	403.76	403.55	403.73	15882.0
2023-03-30 19:00:00	SPY	ETF	403.75	404.04	403.7	403.95	24103.0
2023-03-30 19:30:00	SPY	ETF	403.94	404.23	403.92	404.22	18265.0
2023-03-30 04:00:00	QQQ	ETF	313.4	313.74	313.39	313.46	28630.0
2023-03-30 04:30:00	QQQ	ETF	313.44	313.71	313.38	313.62	13144.0
2023-03-30 05:00:00	QQQ	ETF	313.68	313.92	313.6	313.92	16413.0
2023-03-30 05:30:00	QQQ	ETF	313.94	313.96	313.74	313.89	16564.0
2023-03-30 06:00:00	QQQ	ETF	313.91	314.15	313.85	314.04	8777.0
2023-03-30 06:30:00	QQQ	ETF	314.04	314.5	314.04	314.42	30873.0
2023-03-30 07:00:00	QQQ	ETF	314.39	314.67	314.35	314.61	76645.0
2023-03-30 07:30:00	QQQ	ETF	314.58	314.589	314.28	314.46	78043.0
2023-03-30 08:00:00	QQQ	ETF	314.46	314.85	312.59	314.46	230522.0
2023-03-30 08:30:00	QQQ	ETF	314.54	315.3	314.27	314.92	446734.0
2023-03-30 09:00:00	QQQ	ETF	314.9	315.43	314.52	315.22	385830.0
2023-03-30 09:30:00	QQQ	ETF	315.22	315.59	314.54	315.55	5267928.0
2023-03-30 10:00:00	QQQ	ETF	315.56	316.12	314.32	315.87	4937280.0
2023-03-30 10:30:00	QQQ	ETF	315.87	316.24	315.22	315.66	3180420.0
2023-03-30 11:00:00	QQQ	ETF	315.675	316.32	315.4	315.55	2692709.0
2023-03-30 11:30:00	QQQ	ETF	315.555	315.73	315.15	315.51	2249806.0
2023-03-30 12:00:00	QQQ	ETF	315.515	315.66	314.9215	315.21	1795755.0
2023-03-30 12:30:00	QQQ	ETF	315.21	315.27	314.555	314.85	2225856.0

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

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