PREVIEW / stock_1hour / 2010-09-21

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-21.parquet
  size:    910 KB
  rows:    43,165
  symbols: 3,472

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
2010-09-21 04:00:00	AAPL	Stock	10.1154	10.1154	10.1154	10.1154	13160.0
2010-09-21 05:00:00	AAPL	Stock	10.1214	10.125	10.1036	10.1036	47600.0
2010-09-21 06:00:00	AAPL	Stock	10.0982	10.105	10.0982	10.105	11200.0
2010-09-21 07:00:00	AAPL	Stock	10.1054	10.1175	10.0986	10.1071	109200.0
2010-09-21 08:00:00	AAPL	Stock	10.1071	10.1564	10.0929	10.1507	4861472.0
2010-09-21 09:00:00	AAPL	Stock	10.1518	10.1736	10.0996	10.1101	95193672.0
2010-09-21 10:00:00	AAPL	Stock	10.1114	10.1746	10.1036	10.1164	95307240.0
2010-09-21 11:00:00	AAPL	Stock	10.1163	10.1464	10.1	10.14	64996120.0
2010-09-21 12:00:00	AAPL	Stock	10.1375	10.1607	10.1311	10.1561	40164656.0
2010-09-21 13:00:00	AAPL	Stock	10.155	10.1714	10.1443	10.1686	38071656.0
2010-09-21 14:00:00	AAPL	Stock	10.1696	10.2625	10.1304	10.1964	152374992.0
2010-09-21 15:00:00	AAPL	Stock	10.1961	10.2111	10.1	10.1482	147291144.0
2010-09-21 16:00:00	AAPL	Stock	10.1479	10.1766	10.1122	10.1411	14228648.0
2010-09-21 17:00:00	AAPL	Stock	10.1404	10.1411	10.095	10.095	2230424.0
2010-09-21 18:00:00	AAPL	Stock	10.095	10.1346	10.0793	10.1107	1564528.0
2010-09-21 19:00:00	AAPL	Stock	10.1107	10.1232	10.1004	10.1161	450436.0
2010-09-21 08:00:00	MSFT	Stock	25.48	25.48	25.43	25.46	19080.0
2010-09-21 09:00:00	MSFT	Stock	25.47	25.48	25.15	25.2	5174035.0
2010-09-21 10:00:00	MSFT	Stock	25.19	25.31	25.19	25.25	5706306.0
2010-09-21 11:00:00	MSFT	Stock	25.25	25.26	25.17	25.24	4145723.0
2010-09-21 12:00:00	MSFT	Stock	25.235	25.27	25.21	25.23	2636103.0
2010-09-21 13:00:00	MSFT	Stock	25.235	25.25	25.17	25.24	2666666.0
2010-09-21 14:00:00	MSFT	Stock	25.235	25.375	25.14	25.29	12822884.0
2010-09-21 15:00:00	MSFT	Stock	25.295	25.31	25.08	25.15	14086776.0
2010-09-21 16:00:00	MSFT	Stock	25.15	25.32	25.09	25.16	2520689.0
2010-09-21 17:00:00	MSFT	Stock	25.1	25.12	25.05	25.05	6880.0
2010-09-21 18:00:00	MSFT	Stock	25.08	25.15	25.05	25.15	17690.0
2010-09-21 19:00:00	MSFT	Stock	25.11	25.34	25.11	25.34	231325.0
2010-09-21 08:00:00	NVDA	Stock	0.2678	0.2678	0.2652	0.2652	134320.0
2010-09-21 09:00:00	NVDA	Stock	0.2685	0.2763	0.2655	0.275	172955160.0
2010-09-21 10:00:00	NVDA	Stock	0.275	0.2862	0.2745	0.28	578012920.0
2010-09-21 11:00:00	NVDA	Stock	0.28	0.2838	0.2791	0.2825	230458280.0
2010-09-21 12:00:00	NVDA	Stock	0.2825	0.286	0.2809	0.2855	187630120.0
2010-09-21 13:00:00	NVDA	Stock	0.2853	0.2855	0.2815	0.2831	124180480.0
2010-09-21 14:00:00	NVDA	Stock	0.2832	0.2868	0.2815	0.2848	215552080.0
2010-09-21 15:00:00	NVDA	Stock	0.2848	0.2855	0.2808	0.282	250585280.0
2010-09-21 16:00:00	NVDA	Stock	0.282	0.285	0.2803	0.2803	18391160.0
2010-09-21 17:00:00	NVDA	Stock	0.28	0.2818	0.2798	0.2803	464280.0
2010-09-21 18:00:00	NVDA	Stock	0.2812	0.2812	0.2812	0.2812	169320.0
2010-09-21 19:00:00	NVDA	Stock	0.28	0.2818	0.28	0.2818	56000.0
2010-09-21 07:00:00	AMZN	Stock	7.55	7.55	7.55	7.55	12000.0
2010-09-21 08:00:00	AMZN	Stock	7.55	7.564	7.55	7.551	84800.0
2010-09-21 09:00:00	AMZN	Stock	7.56	7.6335	7.526	7.608	18737620.0
2010-09-21 10:00:00	AMZN	Stock	7.605	7.639	7.552	7.625	26719800.0
2010-09-21 11:00:00	AMZN	Stock	7.6255	7.6325	7.5745	7.5975	14040620.0
2010-09-21 12:00:00	AMZN	Stock	7.5963	7.6295	7.585	7.619	10306980.0
2010-09-21 13:00:00	AMZN	Stock	7.6195	7.6325	7.5995	7.6231	10304160.0
2010-09-21 14:00:00	AMZN	Stock	7.625	7.6655	7.579	7.595	22941780.0
2010-09-21 15:00:00	AMZN	Stock	7.5945	7.598	7.48	7.5365	41924240.0
2010-09-21 16:00:00	AMZN	Stock	7.5325	7.618	7.5155	7.618	1945280.0

> showing 50 of 43,165 rows — these rows as CSV

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