PREVIEW / stock_1hour / 2005-06-29

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-06-29.parquet
  size:    555 KB
  rows:    26,554
  symbols: 2,015

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-06-29 08:00:00	AAPL	Stock	1.3268	1.3321	1.3229	1.3296	656656.0
2005-06-29 09:00:00	AAPL	Stock	1.3296	1.3336	1.2986	1.3036	79918468.0
2005-06-29 10:00:00	AAPL	Stock	1.3036	1.3089	1.295	1.2993	98037688.0
2005-06-29 11:00:00	AAPL	Stock	1.2989	1.3079	1.2971	1.305	59969420.0
2005-06-29 12:00:00	AAPL	Stock	1.305	1.3061	1.2989	1.3	37062648.0
2005-06-29 13:00:00	AAPL	Stock	1.3	1.3025	1.2911	1.2929	46816280.0
2005-06-29 14:00:00	AAPL	Stock	1.2925	1.2982	1.2911	1.2954	43579984.0
2005-06-29 15:00:00	AAPL	Stock	1.295	1.2989	1.29	1.2989	75047532.0
2005-06-29 16:00:00	AAPL	Stock	1.2975	1.2989	1.2911	1.2946	1906044.0
2005-06-29 17:00:00	AAPL	Stock	1.3097	1.3097	1.2914	1.2984	6246100.0
2005-06-29 18:00:00	AAPL	Stock	1.2964	1.2982	1.2946	1.2946	70000.0
2005-06-29 07:00:00	MSFT	Stock	25.17	25.18	25.16	25.18	10745.0
2005-06-29 08:00:00	MSFT	Stock	25.18	25.25	25.1	25.18	200124.0
2005-06-29 09:00:00	MSFT	Stock	25.2	25.32	25.17	25.22	12867410.0
2005-06-29 10:00:00	MSFT	Stock	25.22	25.26	25.13	25.23	10433352.0
2005-06-29 11:00:00	MSFT	Stock	25.23	25.24	25.145	25.2	5842941.0
2005-06-29 12:00:00	MSFT	Stock	25.2	25.22	25.17	25.19	5214029.0
2005-06-29 13:00:00	MSFT	Stock	25.19	25.2	25.15	25.19	5530942.0
2005-06-29 14:00:00	MSFT	Stock	25.2	25.24	25.13	25.17	6574593.0
2005-06-29 15:00:00	MSFT	Stock	25.17	25.2	25.0	25.1	7527839.0
2005-06-29 16:00:00	MSFT	Stock	25.09	25.31	25.05	25.07	616149.0
2005-06-29 17:00:00	MSFT	Stock	25.09	25.11	25.09	25.1	11800.0
2005-06-29 18:00:00	MSFT	Stock	25.1	25.12	25.1	25.1	5420.0
2005-06-29 08:00:00	NVDA	Stock	0.2257	0.2257	0.2257	0.2257	36000.0
2005-06-29 09:00:00	NVDA	Stock	0.2257	0.2258	0.2225	0.2227	37185240.0
2005-06-29 10:00:00	NVDA	Stock	0.2228	0.2237	0.2214	0.2236	76526280.0
2005-06-29 11:00:00	NVDA	Stock	0.2236	0.2237	0.2229	0.2234	31351200.0
2005-06-29 12:00:00	NVDA	Stock	0.2234	0.2237	0.223	0.2231	19014600.0
2005-06-29 13:00:00	NVDA	Stock	0.2232	0.2234	0.2217	0.222	19039200.0
2005-06-29 14:00:00	NVDA	Stock	0.2219	0.2232	0.2216	0.2219	35351280.0
2005-06-29 15:00:00	NVDA	Stock	0.2218	0.2235	0.2217	0.2235	57674760.0
2005-06-29 16:00:00	NVDA	Stock	0.2232	0.2233	0.2232	0.2232	1152960.0
2005-06-29 17:00:00	NVDA	Stock	0.2228	0.2228	0.2228	0.2228	2856000.0
2005-06-29 18:00:00	NVDA	Stock	0.2222	0.2222	0.2221	0.2221	180000.0
2005-06-29 08:00:00	AMZN	Stock	1.6855	1.6855	1.6855	1.6855	7760000.0
2005-06-29 09:00:00	AMZN	Stock	1.7015	1.705	1.6815	1.686	11086080.0
2005-06-29 10:00:00	AMZN	Stock	1.686	1.695	1.685	1.6895	15300240.0
2005-06-29 11:00:00	AMZN	Stock	1.6895	1.693	1.6855	1.6915	8831280.0
2005-06-29 12:00:00	AMZN	Stock	1.691	1.7035	1.69	1.694	9483320.0
2005-06-29 13:00:00	AMZN	Stock	1.694	1.696	1.667	1.6695	11406080.0
2005-06-29 14:00:00	AMZN	Stock	1.6695	1.6815	1.6655	1.666	11347360.0
2005-06-29 15:00:00	AMZN	Stock	1.6655	1.673	1.6635	1.667	20140800.0
2005-06-29 16:00:00	AMZN	Stock	1.6665	1.6675	1.6605	1.6605	119960.0
2005-06-29 17:00:00	AMZN	Stock	1.6665	1.6818	1.666	1.6665	829780.0
2005-06-29 09:00:00	CL	Stock	25.285	25.38	25.285	25.35	315600.0
2005-06-29 10:00:00	CL	Stock	25.35	25.46	25.34	25.415	747200.0
2005-06-29 11:00:00	CL	Stock	25.425	25.425	25.385	25.4	868800.0
2005-06-29 12:00:00	CL	Stock	25.4	25.535	25.395	25.475	589600.0
2005-06-29 13:00:00	CL	Stock	25.475	25.49	25.415	25.48	316200.0
2005-06-29 14:00:00	CL	Stock	25.475	25.48	25.375	25.39	514400.0

> showing 50 of 26,554 rows — these rows as CSV

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