PREVIEW / stock_1hour / 2009-04-01

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-01.parquet
  size:    815 KB
  rows:    40,319
  symbols: 3,311

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
2009-04-01 07:00:00	AAPL	Stock	3.7411	3.7411	3.7411	3.7411	2800.0
2009-04-01 08:00:00	AAPL	Stock	3.7339	3.7543	3.7104	3.7146	1022784.0
2009-04-01 09:00:00	AAPL	Stock	3.7146	3.7543	3.7104	3.7325	55098428.0
2009-04-01 10:00:00	AAPL	Stock	3.7325	3.8371	3.7318	3.8296	105410900.0
2009-04-01 11:00:00	AAPL	Stock	3.83	3.8464	3.8036	3.8454	68537588.0
2009-04-01 12:00:00	AAPL	Stock	3.8457	3.8614	3.835	3.8393	59533852.0
2009-04-01 13:00:00	AAPL	Stock	3.8389	3.8604	3.8329	3.8593	49637476.0
2009-04-01 14:00:00	AAPL	Stock	3.859	3.8832	3.8568	3.8807	86415112.0
2009-04-01 15:00:00	AAPL	Stock	3.8807	3.8929	3.8414	3.8818	141421728.0
2009-04-01 16:00:00	AAPL	Stock	3.8818	3.8868	3.7543	3.8818	9837156.0
2009-04-01 17:00:00	AAPL	Stock	3.8829	3.8864	3.8825	3.8864	128296.0
2009-04-01 18:00:00	AAPL	Stock	3.8896	3.8896	3.8818	3.8857	933016.0
2009-04-01 19:00:00	AAPL	Stock	3.8868	3.8904	3.8864	3.89	195104.0
2009-04-01 07:00:00	MSFT	Stock	18.35	18.38	18.35	18.36	8700.0
2009-04-01 08:00:00	MSFT	Stock	18.35	18.4	18.2	18.33	123256.0
2009-04-01 09:00:00	MSFT	Stock	18.33	18.58	18.17	18.53	9184501.0
2009-04-01 10:00:00	MSFT	Stock	18.53	18.93	18.52	18.88	14046562.0
2009-04-01 11:00:00	MSFT	Stock	18.88	19.11	18.81	19.03	12580603.0
2009-04-01 12:00:00	MSFT	Stock	19.04	19.25	19.04	19.12	13489188.0
2009-04-01 13:00:00	MSFT	Stock	19.12	19.24	19.07	19.22	8840253.0
2009-04-01 14:00:00	MSFT	Stock	19.21	19.36	19.16	19.21	10394646.0
2009-04-01 15:00:00	MSFT	Stock	19.21	19.3	19.0	19.3	21922610.0
2009-04-01 16:00:00	MSFT	Stock	19.3	19.31	18.37	19.31	3551826.0
2009-04-01 17:00:00	MSFT	Stock	19.19	19.3	19.17	19.29	511995.0
2009-04-01 18:00:00	MSFT	Stock	19.2	19.3	19.16	19.3	270302.0
2009-04-01 19:00:00	MSFT	Stock	19.24	19.3	19.23	19.3	1885.0
2009-04-01 20:00:00	MSFT	Stock	18.92	18.92	18.92	18.92	30900.0
2009-04-01 08:00:00	NVDA	Stock	0.2425	0.2445	0.2425	0.2445	125680.0
2009-04-01 09:00:00	NVDA	Stock	0.2448	0.2465	0.2342	0.2435	126420520.0
2009-04-01 10:00:00	NVDA	Stock	0.2438	0.25	0.242	0.2493	168888960.0
2009-04-01 11:00:00	NVDA	Stock	0.2493	0.2518	0.246	0.2513	125012400.0
2009-04-01 12:00:00	NVDA	Stock	0.2513	0.2526	0.2488	0.2493	72223840.0
2009-04-01 13:00:00	NVDA	Stock	0.2495	0.254	0.2488	0.2539	111098440.0
2009-04-01 14:00:00	NVDA	Stock	0.2538	0.255	0.2507	0.2533	91575480.0
2009-04-01 15:00:00	NVDA	Stock	0.253	0.2538	0.2495	0.2525	164324840.0
2009-04-01 16:00:00	NVDA	Stock	0.2525	0.2538	0.2487	0.2527	12569680.0
2009-04-01 17:00:00	NVDA	Stock	0.2527	0.2527	0.2527	0.2527	6000.0
2009-04-01 18:00:00	NVDA	Stock	0.253	0.253	0.253	0.253	20000.0
2009-04-01 19:00:00	NVDA	Stock	0.2527	0.2533	0.2527	0.2533	176000.0
2009-04-01 08:00:00	AMZN	Stock	3.672	3.688	3.65	3.662	237300.0
2009-04-01 09:00:00	AMZN	Stock	3.65	3.672	3.5855	3.6245	22196180.0
2009-04-01 10:00:00	AMZN	Stock	3.627	3.7305	3.6055	3.715	31681760.0
2009-04-01 11:00:00	AMZN	Stock	3.7146	3.735	3.683	3.734	15853220.0
2009-04-01 12:00:00	AMZN	Stock	3.7345	3.7545	3.711	3.7195	11609060.0
2009-04-01 13:00:00	AMZN	Stock	3.7195	3.73	3.6895	3.716	10036420.0
2009-04-01 14:00:00	AMZN	Stock	3.7185	3.7225	3.6875	3.7055	13660780.0
2009-04-01 15:00:00	AMZN	Stock	3.706	3.7065	3.643	3.675	30950300.0
2009-04-01 16:00:00	AMZN	Stock	3.675	3.6861	3.6676	3.675	3826660.0
2009-04-01 17:00:00	AMZN	Stock	3.6835	3.6835	3.6835	3.6835	2000.0
2009-04-01 19:00:00	AMZN	Stock	3.6775	3.6875	3.6775	3.6785	34080.0

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

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