PREVIEW / stock_1hour / 2008-02-13

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-13.parquet
  size:    819 KB
  rows:    40,662
  symbols: 3,263

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-13 05:00:00	AAPL	Stock	4.4996	4.5004	4.4996	4.5004	5600.0
2008-02-13 07:00:00	AAPL	Stock	4.4986	4.5043	4.4893	4.5	113540.0
2008-02-13 08:00:00	AAPL	Stock	4.4929	4.5179	4.4821	4.4968	6036016.0
2008-02-13 09:00:00	AAPL	Stock	4.4996	4.5586	4.4868	4.5364	176210692.0
2008-02-13 10:00:00	AAPL	Stock	4.5361	4.5661	4.5118	4.5213	170517284.0
2008-02-13 11:00:00	AAPL	Stock	4.52	4.5525	4.5129	4.5318	90644736.0
2008-02-13 12:00:00	AAPL	Stock	4.5307	4.5589	4.5279	4.5575	67656372.0
2008-02-13 13:00:00	AAPL	Stock	4.5571	4.625	4.5471	4.6054	145675908.0
2008-02-13 14:00:00	AAPL	Stock	4.6056	4.625	4.5939	4.6214	117892824.0
2008-02-13 15:00:00	AAPL	Stock	4.6214	4.635	4.6107	4.6161	168291004.0
2008-02-13 16:00:00	AAPL	Stock	4.6175	4.6568	4.5668	4.655	22622824.0
2008-02-13 17:00:00	AAPL	Stock	4.6489	4.6489	4.5434	4.6379	1507184.0
2008-02-13 18:00:00	AAPL	Stock	4.6411	4.6411	4.6321	4.6364	519708.0
2008-02-13 19:00:00	AAPL	Stock	4.64	4.655	4.6371	4.6525	842240.0
2008-02-13 07:00:00	MSFT	Stock	28.4	28.58	28.4	28.5	2900.0
2008-02-13 08:00:00	MSFT	Stock	28.41	28.62	28.41	28.56	108844.0
2008-02-13 09:00:00	MSFT	Stock	28.56	28.75	28.5	28.7	10352186.0
2008-02-13 10:00:00	MSFT	Stock	28.705	28.92	28.63	28.85	17617884.0
2008-02-13 11:00:00	MSFT	Stock	28.85	28.88	28.65	28.69	9174353.0
2008-02-13 12:00:00	MSFT	Stock	28.68	28.75	28.6	28.66	6287450.0
2008-02-13 13:00:00	MSFT	Stock	28.66	28.87	28.62	28.82	7713864.0
2008-02-13 14:00:00	MSFT	Stock	28.83	29.05	28.82	29.01	15447391.0
2008-02-13 15:00:00	MSFT	Stock	29.01	29.04	28.86	28.97	18232732.0
2008-02-13 16:00:00	MSFT	Stock	28.99	29.049	28.818	28.98	4172900.0
2008-02-13 17:00:00	MSFT	Stock	29.02	29.05	28.325	29.05	64985.0
2008-02-13 18:00:00	MSFT	Stock	29.02	29.03	28.99	29.01	5883.0
2008-02-13 19:00:00	MSFT	Stock	29.02	29.04	29.02	29.03	2726.0
2008-02-13 08:00:00	NVDA	Stock	0.656	0.6622	0.6513	0.6605	256000.0
2008-02-13 09:00:00	NVDA	Stock	0.6622	0.6638	0.648	0.654	74797040.0
2008-02-13 10:00:00	NVDA	Stock	0.6538	0.6618	0.6525	0.656	84414640.0
2008-02-13 11:00:00	NVDA	Stock	0.6562	0.66	0.654	0.6572	91130280.0
2008-02-13 12:00:00	NVDA	Stock	0.6572	0.6638	0.6568	0.6628	69175400.0
2008-02-13 13:00:00	NVDA	Stock	0.6628	0.6765	0.6608	0.673	77569280.0
2008-02-13 14:00:00	NVDA	Stock	0.6728	0.6758	0.6675	0.675	89946840.0
2008-02-13 15:00:00	NVDA	Stock	0.675	0.6775	0.6682	0.6755	138625280.0
2008-02-13 16:00:00	NVDA	Stock	0.6755	0.6985	0.6545	0.6662	49027520.0
2008-02-13 17:00:00	NVDA	Stock	0.667	0.715	0.6463	0.6875	49784160.0
2008-02-13 18:00:00	NVDA	Stock	0.6878	0.6908	0.6728	0.6812	8031920.0
2008-02-13 19:00:00	NVDA	Stock	0.6812	0.6865	0.6812	0.6858	697000.0
2008-02-13 06:00:00	AMZN	Stock	3.7325	3.7325	3.7325	3.7325	2200.0
2008-02-13 08:00:00	AMZN	Stock	3.733	3.747	3.7	3.7325	448000.0
2008-02-13 09:00:00	AMZN	Stock	3.7365	3.7725	3.6635	3.733	29885320.0
2008-02-13 10:00:00	AMZN	Stock	3.7305	3.7695	3.704	3.768	26965000.0
2008-02-13 11:00:00	AMZN	Stock	3.7675	3.8155	3.753	3.7925	23169180.0
2008-02-13 12:00:00	AMZN	Stock	3.792	3.83	3.79	3.8265	17084220.0
2008-02-13 13:00:00	AMZN	Stock	3.8265	3.9125	3.8135	3.8938	39140560.0
2008-02-13 14:00:00	AMZN	Stock	3.894	3.9425	3.885	3.93	39417440.0
2008-02-13 15:00:00	AMZN	Stock	3.9305	3.9415	3.8735	3.8865	40389380.0
2008-02-13 16:00:00	AMZN	Stock	3.8865	3.915	3.8324	3.915	4529600.0
2008-02-13 17:00:00	AMZN	Stock	3.914	3.9245	3.875	3.9045	197840.0

> showing 50 of 40,662 rows — these rows as CSV

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