PREVIEW / etf_30min / 2023-02-07

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-07.parquet
  size:    708 KB
  rows:    28,444

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-07 04:00:00	SPY	ETF	410.0	410.98	409.96	410.85	62443.0
2023-02-07 04:30:00	SPY	ETF	410.85	411.04	410.76	410.84	41843.0
2023-02-07 05:00:00	SPY	ETF	410.77	410.99	410.53	410.98	34383.0
2023-02-07 05:30:00	SPY	ETF	411.02	411.02	410.2	410.23	46642.0
2023-02-07 06:00:00	SPY	ETF	410.2	410.55	410.07	410.3	42542.0
2023-02-07 06:30:00	SPY	ETF	410.27	410.3	409.96	410.25	85435.0
2023-02-07 07:00:00	SPY	ETF	410.26	410.74	410.23	410.58	104289.0
2023-02-07 07:30:00	SPY	ETF	410.51	410.59	410.18	410.51	66034.0
2023-02-07 08:00:00	SPY	ETF	410.29	411.07	409.37	409.8	422749.0
2023-02-07 08:30:00	SPY	ETF	409.8	409.85	409.26	409.47	285513.0
2023-02-07 09:00:00	SPY	ETF	409.49	409.49	408.84	408.88	408376.0
2023-02-07 09:30:00	SPY	ETF	408.87	409.58	408.5319	409.01	3820609.0
2023-02-07 10:00:00	SPY	ETF	408.99	409.29	408.36	408.6399	2851411.0
2023-02-07 10:30:00	SPY	ETF	408.63	409.41	408.49	408.75	2109444.0
2023-02-07 11:00:00	SPY	ETF	408.7799	410.0	408.7516	409.8106	2639291.0
2023-02-07 11:30:00	SPY	ETF	409.83	410.7	409.81	410.235	2753107.0
2023-02-07 12:00:00	SPY	ETF	410.23	410.62	409.75	409.861	1719819.0
2023-02-07 12:30:00	SPY	ETF	409.865	415.16	408.56	414.33	7479027.0
2023-02-07 13:00:00	SPY	ETF	414.33	414.95	409.75	409.77	7709225.0
2023-02-07 13:30:00	SPY	ETF	409.79	409.8	407.57	408.905	7888756.0
2023-02-07 14:00:00	SPY	ETF	408.9199	412.68	408.8724	412.06	6320115.0
2023-02-07 14:30:00	SPY	ETF	412.08	413.73	411.9	413.56	4968978.0
2023-02-07 15:00:00	SPY	ETF	413.58	414.77	412.68	414.68	4504834.0
2023-02-07 15:30:00	SPY	ETF	414.675	416.49	414.14	415.18	10762550.0
2023-02-07 16:00:00	SPY	ETF	415.18	415.1908	414.13	414.38	3869440.0
2023-02-07 16:30:00	SPY	ETF	414.42	415.19	414.21	414.33	169204.0
2023-02-07 17:00:00	SPY	ETF	414.37	414.55	414.29	414.55	69374.0
2023-02-07 17:30:00	SPY	ETF	414.53	414.6	414.41	414.44	39337.0
2023-02-07 18:00:00	SPY	ETF	414.45	414.93	414.45	414.57	84251.0
2023-02-07 18:30:00	SPY	ETF	414.62	414.78	414.39	414.5	95310.0
2023-02-07 19:00:00	SPY	ETF	414.54	414.66	414.31	414.38	14132.0
2023-02-07 19:30:00	SPY	ETF	414.46	414.77	414.42	414.76	24683.0
2023-02-07 04:00:00	QQQ	ETF	303.73	305.01	303.72	304.92	42343.0
2023-02-07 04:30:00	QQQ	ETF	304.99	305.09	304.76	304.76	31864.0
2023-02-07 05:00:00	QQQ	ETF	304.79	304.87	304.49	304.87	41372.0
2023-02-07 05:30:00	QQQ	ETF	304.95	305.01	304.06	304.06	24279.0
2023-02-07 06:00:00	QQQ	ETF	304.03	304.41	303.95	304.22	35137.0
2023-02-07 06:30:00	QQQ	ETF	304.2	304.34	303.92	304.32	24104.0
2023-02-07 07:00:00	QQQ	ETF	304.37	304.89	304.37	304.74	92726.0
2023-02-07 07:30:00	QQQ	ETF	304.74	304.8	304.4	304.79	49424.0
2023-02-07 08:00:00	QQQ	ETF	304.38	304.9004	303.817	304.1	228742.0
2023-02-07 08:30:00	QQQ	ETF	304.16	304.16	303.45	303.81	170906.0
2023-02-07 09:00:00	QQQ	ETF	303.8	303.8	303.34	303.39	340150.0
2023-02-07 09:30:00	QQQ	ETF	303.46	304.67	303.09	303.28	4758302.0
2023-02-07 10:00:00	QQQ	ETF	303.27	303.93	302.77	303.2748	2918181.0
2023-02-07 10:30:00	QQQ	ETF	303.2679	304.23	303.2	303.69	1971128.0
2023-02-07 11:00:00	QQQ	ETF	303.69	304.965	303.69	304.75	1447829.0
2023-02-07 11:30:00	QQQ	ETF	304.74	305.61	304.73	305.055	1980556.0
2023-02-07 12:00:00	QQQ	ETF	305.06	305.42	304.22	304.36	1321338.0
2023-02-07 12:30:00	QQQ	ETF	304.36	310.05	304.31	309.15	6715436.0

> showing 50 of 28,444 rows — these rows as CSV

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