PREVIEW / stock_1hour / 2008-02-06

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-06.parquet
  size:    833 KB
  rows:    41,409
  symbols: 3,253

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
2008-02-06 05:00:00	AAPL	Stock	4.6357	4.6357	4.6357	4.6357	11200.0
2008-02-06 06:00:00	AAPL	Stock	4.6396	4.6429	4.6396	4.6429	28000.0
2008-02-06 07:00:00	AAPL	Stock	4.6518	4.6786	4.6518	4.6743	353192.0
2008-02-06 08:00:00	AAPL	Stock	4.665	4.6729	4.6339	4.6536	3161060.0
2008-02-06 09:00:00	AAPL	Stock	4.655	4.6896	4.6368	4.6768	128674476.0
2008-02-06 10:00:00	AAPL	Stock	4.6765	4.7114	4.5918	4.6111	242527012.0
2008-02-06 11:00:00	AAPL	Stock	4.6111	4.6382	4.5793	4.5879	155161104.0
2008-02-06 12:00:00	AAPL	Stock	4.5882	4.6007	4.5375	4.545	143668448.0
2008-02-06 13:00:00	AAPL	Stock	4.545	4.5454	4.4425	4.4539	265236692.0
2008-02-06 14:00:00	AAPL	Stock	4.455	4.4925	4.4154	4.4707	267892240.0
2008-02-06 15:00:00	AAPL	Stock	4.4696	4.4889	4.3489	4.3568	313656000.0
2008-02-06 16:00:00	AAPL	Stock	4.3536	4.5598	4.2825	4.2857	39782148.0
2008-02-06 17:00:00	AAPL	Stock	4.2811	4.5481	4.2143	4.2671	10215548.0
2008-02-06 18:00:00	AAPL	Stock	4.2679	4.6524	4.2679	4.2768	2094288.0
2008-02-06 19:00:00	AAPL	Stock	4.2786	4.2939	4.2721	4.2857	808332.0
2008-02-06 07:00:00	MSFT	Stock	29.35	29.36	29.25	29.25	11050.0
2008-02-06 08:00:00	MSFT	Stock	29.25	29.33	29.17	29.29	101057.0
2008-02-06 09:00:00	MSFT	Stock	29.3	29.35	28.82	29.0	12095420.0
2008-02-06 10:00:00	MSFT	Stock	29.0	29.17	28.81	29.03	25211971.0
2008-02-06 11:00:00	MSFT	Stock	29.03	29.35	29.01	29.13	16416646.0
2008-02-06 12:00:00	MSFT	Stock	29.14	29.15	28.9	28.93	8807229.0
2008-02-06 13:00:00	MSFT	Stock	28.94	29.05	28.79	28.805	10256201.0
2008-02-06 14:00:00	MSFT	Stock	28.81	28.95	28.67	28.85	16220278.0
2008-02-06 15:00:00	MSFT	Stock	28.84	28.9	28.32	28.52	38429839.0
2008-02-06 16:00:00	MSFT	Stock	28.52	28.948	28.079	28.3	9538316.0
2008-02-06 17:00:00	MSFT	Stock	28.3	28.909	28.1	28.25	819777.0
2008-02-06 18:00:00	MSFT	Stock	28.25	29.19	28.13	28.13	356069.0
2008-02-06 19:00:00	MSFT	Stock	28.13	28.21	28.1	28.17	118119.0
2008-02-06 08:00:00	NVDA	Stock	0.6178	0.6188	0.6178	0.6188	24000.0
2008-02-06 09:00:00	NVDA	Stock	0.62	0.6238	0.5965	0.6023	62834000.0
2008-02-06 10:00:00	NVDA	Stock	0.6025	0.6235	0.6023	0.6235	98301000.0
2008-02-06 11:00:00	NVDA	Stock	0.6233	0.631	0.6228	0.6305	65857720.0
2008-02-06 12:00:00	NVDA	Stock	0.6305	0.6332	0.6268	0.6308	50463120.0
2008-02-06 13:00:00	NVDA	Stock	0.631	0.632	0.6168	0.6188	64924360.0
2008-02-06 14:00:00	NVDA	Stock	0.619	0.6205	0.6125	0.6162	83190240.0
2008-02-06 15:00:00	NVDA	Stock	0.6158	0.6175	0.6053	0.6075	103823240.0
2008-02-06 16:00:00	NVDA	Stock	0.6073	0.62	0.6	0.6	15841800.0
2008-02-06 17:00:00	NVDA	Stock	0.6025	0.6025	0.595	0.595	554800.0
2008-02-06 18:00:00	NVDA	Stock	0.5958	0.6	0.595	0.595	252080.0
2008-02-06 19:00:00	NVDA	Stock	0.595	0.5988	0.595	0.5988	64000.0
2008-02-06 08:00:00	AMZN	Stock	3.609	3.609	3.609	3.609	5400.0
2008-02-06 09:00:00	AMZN	Stock	3.6245	3.6245	3.53	3.545	21614080.0
2008-02-06 10:00:00	AMZN	Stock	3.548	3.564	3.522	3.5405	37930260.0
2008-02-06 11:00:00	AMZN	Stock	3.539	3.5955	3.5365	3.563	29306140.0
2008-02-06 12:00:00	AMZN	Stock	3.5645	3.575	3.5235	3.534	17000140.0
2008-02-06 13:00:00	AMZN	Stock	3.5325	3.5555	3.5105	3.514	19522340.0
2008-02-06 14:00:00	AMZN	Stock	3.514	3.5245	3.477	3.493	48418520.0
2008-02-06 15:00:00	AMZN	Stock	3.493	3.4955	3.4085	3.4165	67525140.0
2008-02-06 16:00:00	AMZN	Stock	3.4245	3.5085	3.4	3.4	1637220.0
2008-02-06 17:00:00	AMZN	Stock	3.3925	3.4245	3.372	3.3755	232020.0

> showing 50 of 41,409 rows — these rows as CSV

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