PREVIEW / stock_1hour / 2001-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-19.parquet
  size:    357 KB
  rows:    17,221
  symbols: 1,309

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-19 08:00:00	AAPL	Stock	0.375	0.3825	0.3711	0.3777	1808800.0
2001-07-19 09:00:00	AAPL	Stock	0.377	0.3825	0.372	0.3721	76624800.0
2001-07-19 10:00:00	AAPL	Stock	0.3732	0.3768	0.3718	0.3739	130233600.0
2001-07-19 11:00:00	AAPL	Stock	0.3736	0.3741	0.3616	0.3661	110902400.0
2001-07-19 12:00:00	AAPL	Stock	0.3661	0.3668	0.3598	0.3614	85904000.0
2001-07-19 13:00:00	AAPL	Stock	0.3614	0.3632	0.3588	0.3598	76389600.0
2001-07-19 14:00:00	AAPL	Stock	0.3596	0.3598	0.3538	0.3554	132272000.0
2001-07-19 15:00:00	AAPL	Stock	0.3552	0.3571	0.3527	0.3563	169741600.0
2001-07-19 16:00:00	AAPL	Stock	0.3564	0.365	0.3536	0.3536	18844000.0
2001-07-19 17:00:00	AAPL	Stock	0.3545	0.3563	0.3529	0.3545	532000.0
2001-07-19 18:00:00	AAPL	Stock	0.3545	0.3545	0.352	0.352	145600.0
2001-07-19 08:00:00	MSFT	Stock	35.625	35.82	35.15	35.8	566400.0
2001-07-19 09:00:00	MSFT	Stock	35.8	36.0	35.285	35.985	8020800.0
2001-07-19 10:00:00	MSFT	Stock	35.985	36.235	35.885	36.165	12131600.0
2001-07-19 11:00:00	MSFT	Stock	36.175	36.25	36.15	36.19	8892800.0
2001-07-19 12:00:00	MSFT	Stock	36.19	36.39	36.1	36.36	6415600.0
2001-07-19 13:00:00	MSFT	Stock	36.365	36.5	36.215	36.325	6422600.0
2001-07-19 14:00:00	MSFT	Stock	36.335	36.36	36.025	36.05	7544400.0
2001-07-19 15:00:00	MSFT	Stock	36.065	36.3	35.785	36.295	12279200.0
2001-07-19 16:00:00	MSFT	Stock	36.3	37.125	35.0	35.005	8658600.0
2001-07-19 17:00:00	MSFT	Stock	35.0	36.25	34.56	34.925	3079000.0
2001-07-19 18:00:00	MSFT	Stock	34.91	34.95	34.6	34.6	158600.0
2001-07-19 08:00:00	NVDA	Stock	0.3165	0.3219	0.3165	0.3219	6456000.0
2001-07-19 09:00:00	NVDA	Stock	0.3213	0.3315	0.3165	0.3315	90936000.0
2001-07-19 10:00:00	NVDA	Stock	0.3317	0.3347	0.3256	0.3313	160104000.0
2001-07-19 11:00:00	NVDA	Stock	0.3316	0.3338	0.33	0.3313	159240000.0
2001-07-19 12:00:00	NVDA	Stock	0.3311	0.3333	0.3284	0.3319	64440000.0
2001-07-19 13:00:00	NVDA	Stock	0.3316	0.3331	0.3255	0.3267	76560000.0
2001-07-19 14:00:00	NVDA	Stock	0.3267	0.3281	0.3188	0.3189	105720000.0
2001-07-19 15:00:00	NVDA	Stock	0.3189	0.3228	0.3159	0.3213	121968000.0
2001-07-19 16:00:00	NVDA	Stock	0.3213	0.3275	0.3167	0.3167	12792000.0
2001-07-19 17:00:00	NVDA	Stock	0.3167	0.3213	0.3063	0.3158	3528000.0
2001-07-19 18:00:00	NVDA	Stock	0.3129	0.3129	0.3125	0.3126	384000.0
2001-07-19 08:00:00	AMZN	Stock	0.8025	0.815	0.8025	0.815	90000.0
2001-07-19 09:00:00	AMZN	Stock	0.8145	0.83	0.807	0.8275	21968000.0
2001-07-19 10:00:00	AMZN	Stock	0.8275	0.8355	0.816	0.8215	19790000.0
2001-07-19 11:00:00	AMZN	Stock	0.8215	0.8305	0.8165	0.818	8030000.0
2001-07-19 12:00:00	AMZN	Stock	0.8175	0.8375	0.815	0.8325	8746000.0
2001-07-19 13:00:00	AMZN	Stock	0.833	0.84	0.8225	0.829	15144000.0
2001-07-19 14:00:00	AMZN	Stock	0.8285	0.833	0.8255	0.8295	14564000.0
2001-07-19 15:00:00	AMZN	Stock	0.8295	0.8315	0.823	0.8245	11902000.0
2001-07-19 16:00:00	AMZN	Stock	0.824	0.8425	0.824	0.8245	1552000.0
2001-07-19 17:00:00	AMZN	Stock	0.8315	0.8575	0.824	0.852	1766000.0
2001-07-19 18:00:00	AMZN	Stock	0.84	0.85	0.84	0.84	144000.0
2001-07-19 09:00:00	CL	Stock	27.9	28.0	27.845	27.9	380600.0
2001-07-19 10:00:00	CL	Stock	27.9	28.03	27.85	27.885	574200.0
2001-07-19 11:00:00	CL	Stock	27.88	27.9	27.66	27.68	329400.0
2001-07-19 12:00:00	CL	Stock	27.675	27.675	27.505	27.605	457200.0
2001-07-19 13:00:00	CL	Stock	27.61	27.875	27.555	27.65	715400.0
2001-07-19 14:00:00	CL	Stock	27.65	27.75	27.585	27.585	375600.0

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

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