PREVIEW / etf_30min / 2023-02-06

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-06.parquet
  size:    696 KB
  rows:    28,237

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-06 04:00:00	SPY	ETF	410.25	410.95	409.61	409.91	37886.0
2023-02-06 04:30:00	SPY	ETF	409.98	410.06	409.04	409.08	61789.0
2023-02-06 05:00:00	SPY	ETF	409.04	409.09	408.62	408.78	28520.0
2023-02-06 05:30:00	SPY	ETF	408.76	408.97	408.39	408.93	39367.0
2023-02-06 06:00:00	SPY	ETF	408.84	408.95	408.44	408.7	15975.0
2023-02-06 06:30:00	SPY	ETF	408.64	409.31	408.44	409.29	45491.0
2023-02-06 07:00:00	SPY	ETF	409.24	409.66	409.22	409.41	89369.0
2023-02-06 07:30:00	SPY	ETF	409.41	410.13	409.21	410.01	172949.0
2023-02-06 08:00:00	SPY	ETF	409.98	411.15	408.86	409.76	181358.0
2023-02-06 08:30:00	SPY	ETF	409.82	409.87	408.98	409.36	202888.0
2023-02-06 09:00:00	SPY	ETF	409.36	409.91	409.18	409.72	251926.0
2023-02-06 09:30:00	SPY	ETF	409.79	410.89	409.365	410.29	5487174.0
2023-02-06 10:00:00	SPY	ETF	410.32	410.689	408.5805	408.74	4654195.0
2023-02-06 10:30:00	SPY	ETF	408.7399	410.42	408.1	410.27	4102459.0
2023-02-06 11:00:00	SPY	ETF	410.27	411.2	409.9549	411.02	3371461.0
2023-02-06 11:30:00	SPY	ETF	411.02	411.29	409.5999	409.7207	2927134.0
2023-02-06 12:00:00	SPY	ETF	409.72	410.1088	409.33	409.68	1839065.0
2023-02-06 12:30:00	SPY	ETF	409.6509	410.48	409.63	409.9499	1785410.0
2023-02-06 13:00:00	SPY	ETF	409.94	410.34	409.18	409.73	1816527.0
2023-02-06 13:30:00	SPY	ETF	409.71	410.08	409.395	409.97	1549871.0
2023-02-06 14:00:00	SPY	ETF	409.96	411.05	409.93	410.426	2554801.0
2023-02-06 14:30:00	SPY	ETF	410.4099	410.5017	409.7	410.26	2100263.0
2023-02-06 15:00:00	SPY	ETF	410.24	410.33	409.02	409.186	2476589.0
2023-02-06 15:30:00	SPY	ETF	409.19	410.28	408.72	409.9	7254642.0
2023-02-06 16:00:00	SPY	ETF	409.91	410.15	409.81	410.0	2185657.0
2023-02-06 16:30:00	SPY	ETF	409.99	410.05	409.86	410.02	212330.0
2023-02-06 17:00:00	SPY	ETF	410.02	410.09	409.9	409.99	68960.0
2023-02-06 17:30:00	SPY	ETF	410.0	410.17	409.97	410.08	83626.0
2023-02-06 18:00:00	SPY	ETF	410.08	410.5	410.05	410.39	145859.0
2023-02-06 18:30:00	SPY	ETF	410.35	410.65	410.26	410.65	38636.0
2023-02-06 19:00:00	SPY	ETF	410.67	410.9	410.54	410.79	63329.0
2023-02-06 19:30:00	SPY	ETF	410.85	410.99	410.71	410.97	35218.0
2023-02-06 04:00:00	QQQ	ETF	304.12	304.44	303.57	303.85	57635.0
2023-02-06 04:30:00	QQQ	ETF	303.84	304.05	302.99	303.0	55666.0
2023-02-06 05:00:00	QQQ	ETF	302.97	303.1	302.59	302.68	36816.0
2023-02-06 05:30:00	QQQ	ETF	302.81	303.15	302.48	303.03	40958.0
2023-02-06 06:00:00	QQQ	ETF	303.09	303.09	302.65	302.67	101040.0
2023-02-06 06:30:00	QQQ	ETF	302.65	303.16	302.3	303.16	103666.0
2023-02-06 07:00:00	QQQ	ETF	303.14	303.7	303.1	303.44	161602.0
2023-02-06 07:30:00	QQQ	ETF	303.45	304.21	303.29	303.98	207618.0
2023-02-06 08:00:00	QQQ	ETF	303.3	306.409	302.3185	303.9	309573.0
2023-02-06 08:30:00	QQQ	ETF	303.89	304.0	302.871	303.32	351628.0
2023-02-06 09:00:00	QQQ	ETF	303.27	303.59	303.01	303.52	377402.0
2023-02-06 09:30:00	QQQ	ETF	303.53	304.96	303.33	304.5	4679142.0
2023-02-06 10:00:00	QQQ	ETF	304.54	305.51	302.67	302.875	3878647.0
2023-02-06 10:30:00	QQQ	ETF	302.88	304.82	302.22	304.66	2827117.0
2023-02-06 11:00:00	QQQ	ETF	304.67	305.65	304.12	305.5	2250836.0
2023-02-06 11:30:00	QQQ	ETF	305.5	305.91	304.01	304.214	1868371.0
2023-02-06 12:00:00	QQQ	ETF	304.2	304.58	303.73	304.1	1205452.0
2023-02-06 12:30:00	QQQ	ETF	304.12	304.92	304.12	304.33	1321303.0

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

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