PREVIEW / stock_1hour / 2007-04-02

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-02.parquet
  size:    687 KB
  rows:    32,629
  symbols: 2,562

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
2007-04-02 05:00:00	AAPL	Stock	3.36	3.36	3.3571	3.3571	14840.0
2007-04-02 07:00:00	AAPL	Stock	3.3468	3.3571	3.3454	3.3571	292880.0
2007-04-02 08:00:00	AAPL	Stock	3.3471	3.3554	3.3182	3.3429	2672936.0
2007-04-02 09:00:00	AAPL	Stock	3.3436	3.37	3.3357	3.3475	97021008.0
2007-04-02 10:00:00	AAPL	Stock	3.3479	3.3514	3.3221	3.3496	129132052.0
2007-04-02 11:00:00	AAPL	Stock	3.3496	3.3525	3.3339	3.3421	60248076.0
2007-04-02 12:00:00	AAPL	Stock	3.3421	3.35	3.3368	3.3389	36510152.0
2007-04-02 13:00:00	AAPL	Stock	3.3396	3.3432	3.3282	3.3289	43063804.0
2007-04-02 14:00:00	AAPL	Stock	3.3286	3.3361	3.3229	3.3346	51548952.0
2007-04-02 15:00:00	AAPL	Stock	3.3346	3.3443	3.3321	3.3439	68681144.0
2007-04-02 16:00:00	AAPL	Stock	3.3436	3.3446	3.3379	3.3414	5373760.0
2007-04-02 17:00:00	AAPL	Stock	3.3425	3.3429	3.3414	3.3425	190848.0
2007-04-02 18:00:00	AAPL	Stock	3.3414	3.3418	3.3379	3.3386	194068.0
2007-04-02 19:00:00	AAPL	Stock	3.3386	3.3429	3.3386	3.3429	135800.0
2007-04-02 08:00:00	MSFT	Stock	27.9	27.9	27.82	27.82	13650.0
2007-04-02 09:00:00	MSFT	Stock	27.85	27.93	27.78	27.86	3492740.0
2007-04-02 10:00:00	MSFT	Stock	27.86	27.87	27.62	27.71	7110528.0
2007-04-02 11:00:00	MSFT	Stock	27.7	27.78	27.68	27.72	3134509.0
2007-04-02 12:00:00	MSFT	Stock	27.71	27.74	27.59	27.62	5224618.0
2007-04-02 13:00:00	MSFT	Stock	27.61	27.72	27.61	27.62	3545587.0
2007-04-02 14:00:00	MSFT	Stock	27.62	27.68	27.56	27.62	4190890.0
2007-04-02 15:00:00	MSFT	Stock	27.62	27.73	27.61	27.73	9122672.0
2007-04-02 16:00:00	MSFT	Stock	27.74	27.75	27.72	27.74	4016624.0
2007-04-02 17:00:00	MSFT	Stock	27.73	27.74	27.7	27.74	8250.0
2007-04-02 18:00:00	MSFT	Stock	27.74	27.74	27.74	27.74	3500.0
2007-04-02 08:00:00	NVDA	Stock	0.4755	0.4755	0.4755	0.4755	6000.0
2007-04-02 09:00:00	NVDA	Stock	0.4792	0.4825	0.4742	0.479	40944480.0
2007-04-02 10:00:00	NVDA	Stock	0.479	0.479	0.4713	0.4748	106052700.0
2007-04-02 11:00:00	NVDA	Stock	0.4748	0.478	0.4727	0.4765	48190860.0
2007-04-02 12:00:00	NVDA	Stock	0.4765	0.4773	0.4745	0.4745	23784420.0
2007-04-02 13:00:00	NVDA	Stock	0.4747	0.476	0.474	0.4755	28624440.0
2007-04-02 14:00:00	NVDA	Stock	0.4755	0.4775	0.4738	0.4775	35746260.0
2007-04-02 15:00:00	NVDA	Stock	0.4775	0.4815	0.4773	0.479	92936700.0
2007-04-02 16:00:00	NVDA	Stock	0.4788	0.4792	0.4787	0.4792	12758580.0
2007-04-02 17:00:00	NVDA	Stock	0.4778	0.4778	0.4778	0.4778	66000.0
2007-04-02 18:00:00	NVDA	Stock	0.4778	0.4778	0.4773	0.4773	18000.0
2007-04-02 19:00:00	NVDA	Stock	0.4795	0.4797	0.4795	0.4797	83640.0
2007-04-02 08:00:00	AMZN	Stock	1.9895	1.9935	1.9895	1.9935	444000.0
2007-04-02 09:00:00	AMZN	Stock	1.9895	1.999	1.987	1.997	7676420.0
2007-04-02 10:00:00	AMZN	Stock	1.997	2.0	1.9775	1.992	16463480.0
2007-04-02 11:00:00	AMZN	Stock	1.992	2.0059	1.9905	2.0055	13958580.0
2007-04-02 12:00:00	AMZN	Stock	2.005	2.0165	2.0045	2.0065	34209600.0
2007-04-02 13:00:00	AMZN	Stock	2.007	2.0135	2.0055	2.0085	11108300.0
2007-04-02 14:00:00	AMZN	Stock	2.0085	2.0122	1.998	2.0115	16866840.0
2007-04-02 15:00:00	AMZN	Stock	2.012	2.0235	2.0115	2.0225	30226960.0
2007-04-02 16:00:00	AMZN	Stock	2.0235	2.0235	2.015	2.019	284180.0
2007-04-02 17:00:00	AMZN	Stock	2.02	2.02	2.02	2.02	4000.0
2007-04-02 18:00:00	AMZN	Stock	2.02	2.021	2.02	2.021	38240.0
2007-04-02 19:00:00	AMZN	Stock	2.0145	2.0145	2.0145	2.0145	2000.0
2007-04-02 09:00:00	CL	Stock	33.355	33.51	33.31	33.335	240000.0

> showing 50 of 32,629 rows — these rows as CSV

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