PREVIEW / etf_30min / 2001-08-20

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-08-20.parquet
  size:    15 KB
  rows:    365

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-08-20 09:30:00	SPY	ETF	116.8	117.0	116.65	116.68	1481200.0
2001-08-20 10:00:00	SPY	ETF	116.7	117.14	116.55	117.04	731300.0
2001-08-20 10:30:00	SPY	ETF	117.04	117.52	116.85	117.32	1083000.0
2001-08-20 11:00:00	SPY	ETF	117.28	117.42	117.1	117.11	354200.0
2001-08-20 11:30:00	SPY	ETF	117.15	117.33	117.13	117.24	250700.0
2001-08-20 12:00:00	SPY	ETF	117.24	117.4	117.14	117.16	323700.0
2001-08-20 12:30:00	SPY	ETF	117.12	117.18	116.94	116.94	217300.0
2001-08-20 13:00:00	SPY	ETF	116.98	117.21	116.92	117.11	1680100.0
2001-08-20 13:30:00	SPY	ETF	117.11	117.39	116.85	117.36	634800.0
2001-08-20 14:00:00	SPY	ETF	117.35	117.43	117.16	117.3	237800.0
2001-08-20 14:30:00	SPY	ETF	117.32	117.57	117.1	117.49	532600.0
2001-08-20 15:00:00	SPY	ETF	117.48	117.64	117.38	117.46	664400.0
2001-08-20 15:30:00	SPY	ETF	117.48	117.66	117.38	117.52	1116800.0
2001-08-20 16:00:00	SPY	ETF	117.56	117.9	116.72	117.75	723800.0
2001-08-20 16:30:00	SPY	ETF	117.75	118.62	117.75	117.97	50200.0
2001-08-20 17:00:00	SPY	ETF	117.85	117.85	117.85	117.85	40000.0
2001-08-20 09:30:00	QQQ	ETF	37.85	38.02	37.72	37.75	5556600.0
2001-08-20 10:00:00	QQQ	ETF	37.75	38.03	37.52	37.96	7438700.0
2001-08-20 10:30:00	QQQ	ETF	37.96	38.31	37.8	38.13	4857000.0
2001-08-20 11:00:00	QQQ	ETF	38.16	38.28	38.05	38.06	2511500.0
2001-08-20 11:30:00	QQQ	ETF	38.08	38.18	38.0	38.1	2070900.0
2001-08-20 12:00:00	QQQ	ETF	38.1	38.28	38.02	38.05	2649500.0
2001-08-20 12:30:00	QQQ	ETF	38.02	38.04	37.82	37.84	2691000.0
2001-08-20 13:00:00	QQQ	ETF	37.82	37.98	37.76	37.92	3570100.0
2001-08-20 13:30:00	QQQ	ETF	37.9	38.12	37.8	38.05	2004700.0
2001-08-20 14:00:00	QQQ	ETF	38.05	38.13	37.96	38.08	1776200.0
2001-08-20 14:30:00	QQQ	ETF	38.06	38.24	37.89	38.19	2860000.0
2001-08-20 15:00:00	QQQ	ETF	38.2	38.32	38.11	38.2	3729800.0
2001-08-20 15:30:00	QQQ	ETF	38.2	38.25	38.1	38.25	3291400.0
2001-08-20 16:00:00	QQQ	ETF	38.21	38.37	38.18	38.32	1593200.0
2001-08-20 16:30:00	QQQ	ETF	38.32	38.35	38.3	38.35	26900.0
2001-08-20 17:00:00	QQQ	ETF	38.34	38.37	38.31	38.34	54900.0
2001-08-20 17:30:00	QQQ	ETF	38.34	38.35	38.28	38.3	15400.0
2001-08-20 09:30:00	IWM	ETF	47.3	47.47	47.3	47.36	16200.0
2001-08-20 10:00:00	IWM	ETF	47.35	47.35	47.3	47.3	1600.0
2001-08-20 10:30:00	IWM	ETF	47.36	47.59	47.36	47.55	10000.0
2001-08-20 11:00:00	IWM	ETF	47.55	47.55	47.55	47.55	14600.0
2001-08-20 11:30:00	IWM	ETF	47.525	47.525	47.525	47.525	13200.0
2001-08-20 12:00:00	IWM	ETF	47.525	47.525	47.43	47.43	18600.0
2001-08-20 12:30:00	IWM	ETF	47.43	47.43	47.4	47.42	25600.0
2001-08-20 13:00:00	IWM	ETF	47.42	47.42	47.275	47.42	14600.0
2001-08-20 13:30:00	IWM	ETF	47.28	47.39	47.275	47.39	16200.0
2001-08-20 14:00:00	IWM	ETF	47.395	47.625	47.395	47.52	717600.0
2001-08-20 14:30:00	IWM	ETF	47.52	47.75	47.455	47.71	715000.0
2001-08-20 15:00:00	IWM	ETF	47.8	47.85	47.7	47.725	846800.0
2001-08-20 15:30:00	IWM	ETF	47.775	47.875	47.655	47.875	51200.0
2001-08-20 16:00:00	IWM	ETF	47.875	47.875	47.875	47.875	6200.0
2001-08-20 09:30:00	DIA	ETF	102.4	102.59	102.25	102.35	259200.0
2001-08-20 10:00:00	DIA	ETF	102.33	102.6	102.15	102.55	255800.0
2001-08-20 10:30:00	DIA	ETF	102.53	103.14	102.37	102.98	408500.0

> showing 50 of 365 rows — these rows as CSV

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