PREVIEW / etf_30min / 2023-02-13

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-13.parquet
  size:    680 KB
  rows:    27,155

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-13 04:00:00	SPY	ETF	408.02	408.44	408.02	408.25	20525.0
2023-02-13 04:30:00	SPY	ETF	408.29	408.29	407.81	408.11	8138.0
2023-02-13 05:00:00	SPY	ETF	408.11	408.22	407.74	407.87	9471.0
2023-02-13 05:30:00	SPY	ETF	407.8	408.29	407.8	408.22	3150.0
2023-02-13 06:00:00	SPY	ETF	408.28	408.46	408.21	408.33	13006.0
2023-02-13 06:30:00	SPY	ETF	408.42	408.65	408.4	408.49	18421.0
2023-02-13 07:00:00	SPY	ETF	408.46	409.54	408.46	409.45	113412.0
2023-02-13 07:30:00	SPY	ETF	409.43	409.5	409.18	409.2	128612.0
2023-02-13 08:00:00	SPY	ETF	408.51	409.55	406.36	408.8	303771.0
2023-02-13 08:30:00	SPY	ETF	408.8	408.9	408.28	408.32	137102.0
2023-02-13 09:00:00	SPY	ETF	408.3	408.85	408.3	408.72	162817.0
2023-02-13 09:30:00	SPY	ETF	408.72	410.35	408.24	410.3	5175068.0
2023-02-13 10:00:00	SPY	ETF	410.32	410.93	409.94	410.91	3597647.0
2023-02-13 10:30:00	SPY	ETF	410.92	411.86	410.67	411.44	3912790.0
2023-02-13 11:00:00	SPY	ETF	411.445	411.98	411.42	411.65	2568928.0
2023-02-13 11:30:00	SPY	ETF	411.66	412.38	411.1001	411.89	2834569.0
2023-02-13 12:00:00	SPY	ETF	411.89	412.42	411.79	412.1801	1592173.0
2023-02-13 12:30:00	SPY	ETF	412.19	412.55	411.935	412.1701	1480168.0
2023-02-13 13:00:00	SPY	ETF	412.16	412.5	411.63	412.3901	2473901.0
2023-02-13 13:30:00	SPY	ETF	412.4	412.78	412.226	412.75	1507947.0
2023-02-13 14:00:00	SPY	ETF	412.76	412.97	411.75	411.82	2644799.0
2023-02-13 14:30:00	SPY	ETF	411.85	411.935	411.14	411.73	3387795.0
2023-02-13 15:00:00	SPY	ETF	411.74	412.02	411.08	411.95	2821970.0
2023-02-13 15:30:00	SPY	ETF	411.96	412.84	411.94	412.82	11122450.0
2023-02-13 16:00:00	SPY	ETF	412.83	413.09	412.7527	412.91	3490779.0
2023-02-13 16:30:00	SPY	ETF	412.9	412.97	412.84	412.91	154544.0
2023-02-13 17:00:00	SPY	ETF	412.92	412.99	412.91	412.93	47915.0
2023-02-13 17:30:00	SPY	ETF	412.93	412.93	412.83	412.86	35441.0
2023-02-13 18:00:00	SPY	ETF	412.9	412.93	412.8	412.84	11325.0
2023-02-13 18:30:00	SPY	ETF	412.85	412.9	412.76	412.86	56179.0
2023-02-13 19:00:00	SPY	ETF	412.81	412.81	412.61	412.63	49088.0
2023-02-13 19:30:00	SPY	ETF	412.61	412.65	412.37	412.64	56297.0
2023-02-13 04:00:00	QQQ	ETF	299.9	300.6	299.9	300.38	49668.0
2023-02-13 04:30:00	QQQ	ETF	300.6	300.62	300.08	300.26	29807.0
2023-02-13 05:00:00	QQQ	ETF	300.3	300.55	300.14	300.26	12021.0
2023-02-13 05:30:00	QQQ	ETF	300.27	300.98	300.27	300.98	10089.0
2023-02-13 06:00:00	QQQ	ETF	300.89	301.01	300.79	300.86	31529.0
2023-02-13 06:30:00	QQQ	ETF	300.85	301.18	300.82	300.98	27377.0
2023-02-13 07:00:00	QQQ	ETF	300.91	301.89	300.87	301.82	64938.0
2023-02-13 07:30:00	QQQ	ETF	301.8	301.85	301.36	301.48	90876.0
2023-02-13 08:00:00	QQQ	ETF	301.08	301.85	298.33	301.15	167647.0
2023-02-13 08:30:00	QQQ	ETF	301.17	301.2	300.64	300.73	193028.0
2023-02-13 09:00:00	QQQ	ETF	300.72	301.26	300.67	301.14	160739.0
2023-02-13 09:30:00	QQQ	ETF	301.13	302.67	299.93	302.57	4416983.0
2023-02-13 10:00:00	QQQ	ETF	302.58	302.87	301.48	302.5459	2824154.0
2023-02-13 10:30:00	QQQ	ETF	302.545	303.7	302.21	303.28	2315548.0
2023-02-13 11:00:00	QQQ	ETF	303.335	304.35	303.335	304.05	2148682.0
2023-02-13 11:30:00	QQQ	ETF	304.07	304.7	303.52	304.2189	1714980.0
2023-02-13 12:00:00	QQQ	ETF	304.22	304.78	304.15	304.46	1319752.0
2023-02-13 12:30:00	QQQ	ETF	304.46	304.79	304.1601	304.37	1033586.0

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

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