PREVIEW / stock_1hour / 2001-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2001/2001-07-12.parquet
  size:    359 KB
  rows:    17,402
  symbols: 1,314

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-12 08:00:00	AAPL	Stock	0.4163	0.4241	0.4109	0.4134	2934400.0
2001-07-12 09:00:00	AAPL	Stock	0.4134	0.4286	0.4109	0.428	93111200.0
2001-07-12 10:00:00	AAPL	Stock	0.4282	0.4329	0.4241	0.4277	104288800.0
2001-07-12 11:00:00	AAPL	Stock	0.4277	0.4298	0.4255	0.4291	59494400.0
2001-07-12 12:00:00	AAPL	Stock	0.4291	0.4329	0.4271	0.4302	44452800.0
2001-07-12 13:00:00	AAPL	Stock	0.4302	0.4314	0.4275	0.4302	36136800.0
2001-07-12 14:00:00	AAPL	Stock	0.4304	0.438	0.4266	0.4348	55529600.0
2001-07-12 15:00:00	AAPL	Stock	0.4348	0.443	0.4346	0.4352	165026400.0
2001-07-12 16:00:00	AAPL	Stock	0.4345	0.4407	0.4271	0.4382	27344800.0
2001-07-12 17:00:00	AAPL	Stock	0.44	0.4446	0.4382	0.4393	582400.0
2001-07-12 18:00:00	AAPL	Stock	0.4396	0.4396	0.4396	0.4396	11200.0
2001-07-12 08:00:00	MSFT	Stock	35.5	35.655	33.26	35.45	2770200.0
2001-07-12 09:00:00	MSFT	Stock	35.45	35.75	35.05	35.71	30980800.0
2001-07-12 10:00:00	MSFT	Stock	35.71	35.8	35.325	35.38	26024600.0
2001-07-12 11:00:00	MSFT	Stock	35.38	35.45	35.165	35.3	13525200.0
2001-07-12 12:00:00	MSFT	Stock	35.29	35.53	35.25	35.43	8427800.0
2001-07-12 13:00:00	MSFT	Stock	35.43	35.535	35.375	35.475	7785400.0
2001-07-12 14:00:00	MSFT	Stock	35.47	35.625	35.3	35.59	9125800.0
2001-07-12 15:00:00	MSFT	Stock	35.595	35.95	35.535	35.795	17269200.0
2001-07-12 16:00:00	MSFT	Stock	35.8	35.94	35.56	35.85	5727000.0
2001-07-12 17:00:00	MSFT	Stock	35.85	36.145	35.81	35.99	230800.0
2001-07-12 18:00:00	MSFT	Stock	35.995	36.1	35.995	36.09	26200.0
2001-07-12 08:00:00	NVDA	Stock	0.3463	0.347	0.3427	0.3427	7944000.0
2001-07-12 09:00:00	NVDA	Stock	0.3419	0.3458	0.3375	0.344	159408000.0
2001-07-12 10:00:00	NVDA	Stock	0.3442	0.345	0.3358	0.3389	180720000.0
2001-07-12 11:00:00	NVDA	Stock	0.3385	0.3408	0.3344	0.3395	81576000.0
2001-07-12 12:00:00	NVDA	Stock	0.3395	0.3427	0.3375	0.341	101784000.0
2001-07-12 13:00:00	NVDA	Stock	0.3411	0.3419	0.3383	0.3392	97104000.0
2001-07-12 14:00:00	NVDA	Stock	0.3392	0.3436	0.3377	0.3426	97368000.0
2001-07-12 15:00:00	NVDA	Stock	0.3427	0.3469	0.3421	0.3444	204024000.0
2001-07-12 16:00:00	NVDA	Stock	0.3445	0.3445	0.3414	0.3445	7368000.0
2001-07-12 17:00:00	NVDA	Stock	0.3438	0.3456	0.3438	0.3445	456000.0
2001-07-12 08:00:00	AMZN	Stock	0.81	0.81	0.7925	0.803	340000.0
2001-07-12 09:00:00	AMZN	Stock	0.8	0.8115	0.783	0.81	24734000.0
2001-07-12 10:00:00	AMZN	Stock	0.81	0.821	0.8035	0.8035	24966000.0
2001-07-12 11:00:00	AMZN	Stock	0.8035	0.81	0.7995	0.81	14652000.0
2001-07-12 12:00:00	AMZN	Stock	0.81	0.815	0.804	0.8125	8554000.0
2001-07-12 13:00:00	AMZN	Stock	0.8125	0.8175	0.8095	0.812	8538000.0
2001-07-12 14:00:00	AMZN	Stock	0.811	0.8215	0.809	0.8185	10248000.0
2001-07-12 15:00:00	AMZN	Stock	0.819	0.827	0.815	0.823	22138000.0
2001-07-12 16:00:00	AMZN	Stock	0.82	0.8245	0.8185	0.8245	1964000.0
2001-07-12 17:00:00	AMZN	Stock	0.8225	0.8245	0.82	0.8235	36000.0
2001-07-12 18:00:00	AMZN	Stock	0.8235	0.8235	0.8235	0.8235	30000.0
2001-07-12 09:00:00	CL	Stock	27.725	27.725	27.44	27.625	619200.0
2001-07-12 10:00:00	CL	Stock	27.7	27.795	27.43	27.55	1261800.0
2001-07-12 11:00:00	CL	Stock	27.475	27.625	27.265	27.45	1093400.0
2001-07-12 12:00:00	CL	Stock	27.45	27.485	27.325	27.41	519000.0
2001-07-12 13:00:00	CL	Stock	27.4	27.46	27.355	27.4	570200.0
2001-07-12 14:00:00	CL	Stock	27.38	27.395	27.0	27.0	1113800.0
2001-07-12 15:00:00	CL	Stock	27.01	27.46	27.01	27.445	1425600.0

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

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