PREVIEW / etf_30min / 2023-02-03

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-03.parquet
  size:    724 KB
  rows:    29,216

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-03 04:00:00	SPY	ETF	413.6	413.65	412.93	413.48	37070.0
2023-02-03 04:30:00	SPY	ETF	413.47	413.82	413.45	413.45	18970.0
2023-02-03 05:00:00	SPY	ETF	413.42	413.54	413.04	413.04	8337.0
2023-02-03 05:30:00	SPY	ETF	413.06	413.5	412.93	413.44	9528.0
2023-02-03 06:00:00	SPY	ETF	413.03	413.49	412.96	413.49	8754.0
2023-02-03 06:30:00	SPY	ETF	413.48	413.89	413.48	413.5	13403.0
2023-02-03 07:00:00	SPY	ETF	413.59	414.32	413.58	413.91	85800.0
2023-02-03 07:30:00	SPY	ETF	413.92	414.59	413.76	414.52	123811.0
2023-02-03 08:00:00	SPY	ETF	414.5	414.95	413.0	414.67	643202.0
2023-02-03 08:30:00	SPY	ETF	414.23	414.23	411.13	411.9	2529980.0
2023-02-03 09:00:00	SPY	ETF	411.86	412.05	410.84	411.67	676187.0
2023-02-03 09:30:00	SPY	ETF	411.59	414.43	411.44	413.58	7645792.0
2023-02-03 10:00:00	SPY	ETF	413.46	415.95	412.43	414.99	7212453.0
2023-02-03 10:30:00	SPY	ETF	414.99	416.7	414.81	415.65	4844250.0
2023-02-03 11:00:00	SPY	ETF	415.665	416.62	415.61	416.3533	3308041.0
2023-02-03 11:30:00	SPY	ETF	416.37	416.97	414.61	414.8	3539367.0
2023-02-03 12:00:00	SPY	ETF	414.77	416.42	414.56	416.18	2414563.0
2023-02-03 12:30:00	SPY	ETF	416.175	416.54	413.92	414.11	2565068.0
2023-02-03 13:00:00	SPY	ETF	414.12	414.27	412.65	413.01	4410437.0
2023-02-03 13:30:00	SPY	ETF	413.0	413.47	411.69	412.9792	4334199.0
2023-02-03 14:00:00	SPY	ETF	412.96	413.23	411.86	412.5079	3286927.0
2023-02-03 14:30:00	SPY	ETF	412.51	413.24	411.555	411.82	2931170.0
2023-02-03 15:00:00	SPY	ETF	411.82	413.01	411.09	412.365	4432290.0
2023-02-03 15:30:00	SPY	ETF	412.38	412.9	411.56	412.36	8108967.0
2023-02-03 16:00:00	SPY	ETF	412.37	412.414	411.94	412.15	3530105.0
2023-02-03 16:30:00	SPY	ETF	412.15	413.0	412.0	412.19	283649.0
2023-02-03 17:00:00	SPY	ETF	412.19	412.25	411.85	412.01	108653.0
2023-02-03 17:30:00	SPY	ETF	412.03	412.35	411.93	412.0	514523.0
2023-02-03 18:00:00	SPY	ETF	412.04	412.15	411.9	411.9	24953.0
2023-02-03 18:30:00	SPY	ETF	411.95	412.08	411.92	411.93	4902.0
2023-02-03 19:00:00	SPY	ETF	411.93	411.93	411.77	411.81	14975.0
2023-02-03 19:30:00	SPY	ETF	411.81	411.96	411.42	411.5	32005.0
2023-02-03 04:00:00	QQQ	ETF	305.9	306.65	305.58	306.65	50803.0
2023-02-03 04:30:00	QQQ	ETF	306.64	307.25	306.64	306.87	65587.0
2023-02-03 05:00:00	QQQ	ETF	306.84	307.15	306.58	306.6	34652.0
2023-02-03 05:30:00	QQQ	ETF	306.51	306.95	306.36	306.95	40816.0
2023-02-03 06:00:00	QQQ	ETF	306.82	307.19	306.5	307.13	38961.0
2023-02-03 06:30:00	QQQ	ETF	307.25	307.61	307.21	307.42	164908.0
2023-02-03 07:00:00	QQQ	ETF	307.42	308.5	307.4	307.86	158794.0
2023-02-03 07:30:00	QQQ	ETF	307.84	308.92	307.56	308.86	196834.0
2023-02-03 08:00:00	QQQ	ETF	307.45	311.953	305.29	309.21	844292.0
2023-02-03 08:30:00	QQQ	ETF	309.2	309.2	304.89	305.33	2764704.0
2023-02-03 09:00:00	QQQ	ETF	305.32	305.83	304.42	305.06	937154.0
2023-02-03 09:30:00	QQQ	ETF	304.94	309.38	304.54	308.64	9230779.0
2023-02-03 10:00:00	QQQ	ETF	308.65	311.28	307.33	309.92	7967985.0
2023-02-03 10:30:00	QQQ	ETF	309.92	311.88	309.51	310.5907	4645280.0
2023-02-03 11:00:00	QQQ	ETF	310.61	311.75	310.56	311.5	2258667.0
2023-02-03 11:30:00	QQQ	ETF	311.5	312.39	309.73	309.93	3834573.0
2023-02-03 12:00:00	QQQ	ETF	309.9	311.53	309.65	311.21	1864251.0
2023-02-03 12:30:00	QQQ	ETF	311.21	311.44	308.55	308.75	1986088.0

> showing 50 of 29,216 rows — these rows as CSV

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