PREVIEW / stock_1hour / 2001-07-26

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-26.parquet
  size:    362 KB
  rows:    17,193
  symbols: 1,315

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-07-26 08:00:00	AAPL	Stock	0.3334	0.3355	0.33	0.335	1215200.0
2001-07-26 09:00:00	AAPL	Stock	0.3304	0.3338	0.3248	0.3311	45841600.0
2001-07-26 10:00:00	AAPL	Stock	0.3311	0.3313	0.3236	0.3241	56907200.0
2001-07-26 11:00:00	AAPL	Stock	0.3236	0.3257	0.3188	0.323	64047200.0
2001-07-26 12:00:00	AAPL	Stock	0.3234	0.325	0.3214	0.3248	29629600.0
2001-07-26 13:00:00	AAPL	Stock	0.325	0.3289	0.3232	0.3279	30469600.0
2001-07-26 14:00:00	AAPL	Stock	0.3279	0.3338	0.3268	0.333	41568800.0
2001-07-26 15:00:00	AAPL	Stock	0.3323	0.3357	0.3304	0.3321	64792000.0
2001-07-26 16:00:00	AAPL	Stock	0.3321	0.3341	0.3277	0.332	18782400.0
2001-07-26 17:00:00	AAPL	Stock	0.3318	0.333	0.3318	0.3321	123200.0
2001-07-26 18:00:00	AAPL	Stock	0.3348	0.3348	0.3348	0.3348	22400.0
2001-07-26 08:00:00	MSFT	Stock	33.775	33.795	33.475	33.6	141200.0
2001-07-26 09:00:00	MSFT	Stock	33.6	33.71	33.305	33.45	8287000.0
2001-07-26 10:00:00	MSFT	Stock	33.455	33.66	33.24	33.355	9805400.0
2001-07-26 11:00:00	MSFT	Stock	33.325	33.365	32.75	32.95	11059200.0
2001-07-26 12:00:00	MSFT	Stock	32.95	33.035	32.775	32.92	6036000.0
2001-07-26 13:00:00	MSFT	Stock	32.92	33.31	32.92	33.285	9413600.0
2001-07-26 14:00:00	MSFT	Stock	33.285	33.605	33.225	33.46	10634600.0
2001-07-26 15:00:00	MSFT	Stock	33.46	33.63	33.2	33.295	16068400.0
2001-07-26 16:00:00	MSFT	Stock	33.3	33.51	33.0	33.325	2906600.0
2001-07-26 17:00:00	MSFT	Stock	33.325	33.35	33.185	33.285	14000.0
2001-07-26 18:00:00	MSFT	Stock	33.285	33.42	33.235	33.42	44400.0
2001-07-26 08:00:00	NVDA	Stock	0.299	0.2992	0.2954	0.2956	2568000.0
2001-07-26 09:00:00	NVDA	Stock	0.2966	0.3177	0.2944	0.3135	360000000.0
2001-07-26 10:00:00	NVDA	Stock	0.3135	0.3154	0.3063	0.3072	329184000.0
2001-07-26 11:00:00	NVDA	Stock	0.307	0.3087	0.3021	0.3079	160512000.0
2001-07-26 12:00:00	NVDA	Stock	0.3078	0.3098	0.3057	0.3092	93744000.0
2001-07-26 13:00:00	NVDA	Stock	0.3094	0.3178	0.3081	0.3175	152976000.0
2001-07-26 14:00:00	NVDA	Stock	0.3175	0.3245	0.3153	0.3235	213672000.0
2001-07-26 15:00:00	NVDA	Stock	0.3231	0.3306	0.3226	0.3292	302352000.0
2001-07-26 16:00:00	NVDA	Stock	0.3291	0.3306	0.3104	0.3292	16728000.0
2001-07-26 17:00:00	NVDA	Stock	0.3304	0.3313	0.3288	0.3313	2352000.0
2001-07-26 18:00:00	NVDA	Stock	0.3308	0.3308	0.3308	0.3308	96000.0
2001-07-26 08:00:00	AMZN	Stock	0.58	0.58	0.575	0.58	298000.0
2001-07-26 09:00:00	AMZN	Stock	0.58	0.586	0.5745	0.5815	16670000.0
2001-07-26 10:00:00	AMZN	Stock	0.58	0.583	0.5615	0.57	33010000.0
2001-07-26 11:00:00	AMZN	Stock	0.569	0.581	0.5655	0.579	22330000.0
2001-07-26 12:00:00	AMZN	Stock	0.579	0.5875	0.576	0.587	20578000.0
2001-07-26 13:00:00	AMZN	Stock	0.587	0.6035	0.5845	0.601	19328000.0
2001-07-26 14:00:00	AMZN	Stock	0.6005	0.621	0.5985	0.617	26592000.0
2001-07-26 15:00:00	AMZN	Stock	0.617	0.6375	0.6155	0.617	40980000.0
2001-07-26 16:00:00	AMZN	Stock	0.617	0.634	0.582	0.6165	13116000.0
2001-07-26 17:00:00	AMZN	Stock	0.6165	0.6175	0.6105	0.6125	30000.0
2001-07-26 18:00:00	AMZN	Stock	0.617	0.6175	0.617	0.6175	12000.0
2001-07-26 09:00:00	CL	Stock	27.195	27.25	27.045	27.05	427200.0
2001-07-26 10:00:00	CL	Stock	27.025	27.055	26.89	26.93	668400.0
2001-07-26 11:00:00	CL	Stock	26.93	26.985	26.775	26.98	657400.0
2001-07-26 12:00:00	CL	Stock	26.995	27.05	26.975	27.015	310600.0
2001-07-26 13:00:00	CL	Stock	27.015	27.025	26.95	26.995	218600.0
2001-07-26 14:00:00	CL	Stock	26.995	27.2	26.985	27.145	390400.0

> showing 50 of 17,193 rows — these rows as CSV

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