PREVIEW / etf_30min / 2005-05-31

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-05-31.parquet
  size:    43 KB
  rows:    1,513

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
2005-05-31 05:30:00	SPY	ETF	120.04	120.14	120.04	120.14	3000.0
2005-05-31 06:00:00	SPY	ETF	120.04	120.04	120.04	120.04	1500.0
2005-05-31 06:30:00	SPY	ETF	119.96	120.04	119.96	120.04	103000.0
2005-05-31 07:00:00	SPY	ETF	120.07	120.07	120.0	120.0	13500.0
2005-05-31 07:30:00	SPY	ETF	120.02	120.05	120.0	120.0	38300.0
2005-05-31 08:00:00	SPY	ETF	120.02	120.09	119.99	120.09	22700.0
2005-05-31 08:30:00	SPY	ETF	120.08	120.15	120.08	120.14	38800.0
2005-05-31 09:00:00	SPY	ETF	120.15	120.17	120.06	120.06	80600.0
2005-05-31 09:30:00	SPY	ETF	120.08	120.17	119.53	119.59	5070400.0
2005-05-31 10:00:00	SPY	ETF	119.59	119.78	119.54	119.75	5845900.0
2005-05-31 10:30:00	SPY	ETF	119.75	119.86	119.58	119.6	3724500.0
2005-05-31 11:00:00	SPY	ETF	119.6	119.67	119.47	119.64	3103500.0
2005-05-31 11:30:00	SPY	ETF	119.64	119.66	119.57	119.64	1178700.0
2005-05-31 12:00:00	SPY	ETF	119.63	120.02	119.55	119.73	1186000.0
2005-05-31 12:30:00	SPY	ETF	119.74	119.75	119.57	119.63	548800.0
2005-05-31 13:00:00	SPY	ETF	119.62	119.67	119.58	119.66	1159700.0
2005-05-31 13:30:00	SPY	ETF	119.64	119.88	119.63	119.81	1550500.0
2005-05-31 14:00:00	SPY	ETF	119.81	119.87	119.71	119.78	1133900.0
2005-05-31 14:30:00	SPY	ETF	119.78	120.0	119.76	119.91	2735800.0
2005-05-31 15:00:00	SPY	ETF	119.9	120.05	119.82	119.84	2386300.0
2005-05-31 15:30:00	SPY	ETF	119.84	119.85	119.43	119.45	7119700.0
2005-05-31 16:00:00	SPY	ETF	119.46	119.6923	119.39	119.48	1788900.0
2005-05-31 16:30:00	SPY	ETF	119.48	119.5	119.4	119.44	343800.0
2005-05-31 17:00:00	SPY	ETF	119.45	119.45	119.42	119.45	1500900.0
2005-05-31 17:30:00	SPY	ETF	119.46	119.49	119.4	119.42	45500.0
2005-05-31 18:00:00	SPY	ETF	119.46	119.54	119.46	119.5	13200.0
2005-05-31 18:30:00	SPY	ETF	119.47	119.47	119.47	119.47	300.0
2005-05-31 19:30:00	SPY	ETF	119.5	119.53	119.5	119.53	4200.0
2005-05-31 09:30:00	QQQ	ETF	38.2	38.23	38.05	38.06	9771800.0
2005-05-31 10:00:00	QQQ	ETF	38.06	38.21	38.06	38.19	11309400.0
2005-05-31 10:30:00	QQQ	ETF	38.2	38.24	38.05	38.05	6432200.0
2005-05-31 11:00:00	QQQ	ETF	38.06	38.06	37.92	37.97	8998400.0
2005-05-31 11:30:00	QQQ	ETF	37.97	38.02	37.97	38.02	2404400.0
2005-05-31 12:00:00	QQQ	ETF	38.01	38.07	37.97	38.06	3084400.0
2005-05-31 12:30:00	QQQ	ETF	38.06	38.07	38.03	38.04	1608300.0
2005-05-31 13:00:00	QQQ	ETF	38.04	38.09	38.03	38.05	1662700.0
2005-05-31 13:30:00	QQQ	ETF	38.05	38.16	38.05	38.13	2956100.0
2005-05-31 14:00:00	QQQ	ETF	38.13	38.16	38.09	38.11	1979500.0
2005-05-31 14:30:00	QQQ	ETF	38.11	38.19	38.11	38.17	4379200.0
2005-05-31 15:00:00	QQQ	ETF	38.17	38.22	38.14	38.17	5257600.0
2005-05-31 15:30:00	QQQ	ETF	38.16	38.17	38.05	38.09	10146700.0
2005-05-31 07:30:00	IWM	ETF	61.44	61.44	61.43	61.43	3000.0
2005-05-31 08:30:00	IWM	ETF	61.475	61.475	61.475	61.475	5000.0
2005-05-31 09:00:00	IWM	ETF	61.485	61.485	61.485	61.485	2000.0
2005-05-31 09:30:00	IWM	ETF	61.52	61.61	61.21	61.24	1941600.0
2005-05-31 10:00:00	IWM	ETF	61.24	61.53	61.24	61.455	2482800.0
2005-05-31 10:30:00	IWM	ETF	61.455	61.52	61.335	61.34	842000.0
2005-05-31 11:00:00	IWM	ETF	61.34	61.395	61.25	61.325	1105600.0
2005-05-31 11:30:00	IWM	ETF	61.325	61.37	61.285	61.325	472400.0
2005-05-31 12:00:00	IWM	ETF	61.325	61.42	61.285	61.41	193200.0

> showing 50 of 1,513 rows — these rows as CSV

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