PREVIEW / etf_30min / 2001-09-19

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-09-19.parquet
  size:    18 KB
  rows:    470

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
2001-09-19 09:30:00	SPY	ETF	104.1	104.45	103.8	104.19	2587900.0
2001-09-19 10:00:00	SPY	ETF	104.19	104.5	103.51	103.59	1406400.0
2001-09-19 10:30:00	SPY	ETF	103.56	103.6	102.65	102.9	1934800.0
2001-09-19 11:00:00	SPY	ETF	102.87	102.93	101.67	102.05	2769200.0
2001-09-19 11:30:00	SPY	ETF	102.05	102.28	101.23	101.3	3376100.0
2001-09-19 12:00:00	SPY	ETF	101.32	101.85	100.8	101.41	2191600.0
2001-09-19 12:30:00	SPY	ETF	101.43	101.65	101.05	101.56	1004600.0
2001-09-19 13:00:00	SPY	ETF	101.62	101.76	101.0	101.23	1353400.0
2001-09-19 13:30:00	SPY	ETF	101.26	101.26	100.45	101.08	3904800.0
2001-09-19 14:00:00	SPY	ETF	101.09	101.2	99.94	100.13	2282400.0
2001-09-19 14:30:00	SPY	ETF	100.13	100.13	98.56	99.78	7325500.0
2001-09-19 15:00:00	SPY	ETF	99.75	100.8	99.7	100.76	3330400.0
2001-09-19 15:30:00	SPY	ETF	100.76	102.57	100.67	102.02	6469800.0
2001-09-19 16:00:00	SPY	ETF	101.99	102.3	101.62	102.3	771500.0
2001-09-19 16:30:00	SPY	ETF	101.84	101.9	101.75	101.75	1100.0
2001-09-19 17:00:00	SPY	ETF	101.75	101.75	101.75	101.75	500.0
2001-09-19 17:30:00	SPY	ETF	101.75	101.75	101.75	101.75	18000.0
2001-09-19 09:30:00	QQQ	ETF	30.64	30.94	30.53	30.71	8249800.0
2001-09-19 10:00:00	QQQ	ETF	30.73	30.98	30.26	30.3	9397600.0
2001-09-19 10:30:00	QQQ	ETF	30.27	30.33	29.84	29.92	8447300.0
2001-09-19 11:00:00	QQQ	ETF	29.91	29.94	29.2	29.58	12611600.0
2001-09-19 11:30:00	QQQ	ETF	29.58	29.68	29.15	29.15	6788100.0
2001-09-19 12:00:00	QQQ	ETF	29.15	29.46	29.0	29.27	6737800.0
2001-09-19 12:30:00	QQQ	ETF	29.3	29.43	29.11	29.42	3832900.0
2001-09-19 13:00:00	QQQ	ETF	29.4	29.58	29.16	29.28	4006900.0
2001-09-19 13:30:00	QQQ	ETF	29.3	29.33	28.91	29.17	4951000.0
2001-09-19 14:00:00	QQQ	ETF	29.19	29.25	28.68	28.75	6747600.0
2001-09-19 14:30:00	QQQ	ETF	28.75	28.8	28.26	28.75	10818000.0
2001-09-19 15:00:00	QQQ	ETF	28.77	29.35	28.74	29.32	11160400.0
2001-09-19 15:30:00	QQQ	ETF	29.32	30.36	29.3	30.11	15852100.0
2001-09-19 16:00:00	QQQ	ETF	30.1	30.15	28.55	29.97	2636400.0
2001-09-19 16:30:00	QQQ	ETF	29.98	30.1	29.89	30.0	113200.0
2001-09-19 17:00:00	QQQ	ETF	30.0	30.08	29.95	30.03	358700.0
2001-09-19 17:30:00	QQQ	ETF	30.02	30.06	29.95	30.02	23700.0
2001-09-19 18:00:00	QQQ	ETF	30.0	30.09	29.95	29.99	12100.0
2001-09-19 09:30:00	IWM	ETF	41.255	41.35	41.075	41.075	9000.0
2001-09-19 10:00:00	IWM	ETF	41.11	41.165	40.71	40.71	48600.0
2001-09-19 10:30:00	IWM	ETF	40.705	40.71	40.405	40.405	50600.0
2001-09-19 11:00:00	IWM	ETF	40.405	40.405	40.07	40.155	148200.0
2001-09-19 11:30:00	IWM	ETF	40.205	40.245	40.085	40.085	33800.0
2001-09-19 12:00:00	IWM	ETF	39.975	40.015	39.755	39.875	16400.0
2001-09-19 12:30:00	IWM	ETF	39.85	39.87	39.68	39.85	112600.0
2001-09-19 13:00:00	IWM	ETF	39.76	39.76	39.505	39.53	126600.0
2001-09-19 13:30:00	IWM	ETF	39.505	39.505	39.255	39.325	27200.0
2001-09-19 14:00:00	IWM	ETF	39.28	39.5	39.205	39.205	30800.0
2001-09-19 14:30:00	IWM	ETF	39.205	39.345	38.8	39.275	23400.0
2001-09-19 15:00:00	IWM	ETF	39.07	39.54	39.07	39.395	17600.0
2001-09-19 15:30:00	IWM	ETF	39.42	40.245	39.42	40.1	292800.0
2001-09-19 16:00:00	IWM	ETF	40.08	40.08	40.08	40.08	2000.0
2001-09-19 09:30:00	DIA	ETF	89.43	89.8	88.96	89.2	789900.0

> showing 50 of 470 rows — these rows as CSV

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