PREVIEW / stock_1hour / 2009-03-31

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-03-31.parquet
  size:    843 KB
  rows:    41,927
  symbols: 3,345

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-03-31 07:00:00	AAPL	Stock	3.7518	3.7664	3.7496	3.75	313516.0
2009-03-31 08:00:00	AAPL	Stock	3.7639	3.7664	3.7504	3.7607	707504.0
2009-03-31 09:00:00	AAPL	Stock	3.7625	3.7864	3.7536	3.772	68781328.0
2009-03-31 10:00:00	AAPL	Stock	3.7714	3.7921	3.7632	3.77	76158096.0
2009-03-31 11:00:00	AAPL	Stock	3.7707	3.7768	3.7536	3.7607	54922196.0
2009-03-31 12:00:00	AAPL	Stock	3.7607	3.7946	3.7548	3.7946	51839424.0
2009-03-31 13:00:00	AAPL	Stock	3.7943	3.8136	3.7907	3.8021	56631708.0
2009-03-31 14:00:00	AAPL	Stock	3.8021	3.8375	3.7939	3.8261	67600176.0
2009-03-31 15:00:00	AAPL	Stock	3.8257	3.8275	3.75	3.7554	135323104.0
2009-03-31 16:00:00	AAPL	Stock	3.7525	3.8054	3.7507	3.7543	29153992.0
2009-03-31 17:00:00	AAPL	Stock	3.7543	3.7543	3.75	3.7518	2361492.0
2009-03-31 18:00:00	AAPL	Stock	3.7518	3.7543	3.7471	3.7471	359884.0
2009-03-31 19:00:00	AAPL	Stock	3.7471	3.7471	3.7286	3.7346	248388.0
2009-03-31 04:00:00	MSFT	Stock	17.7	17.7	17.7	17.7	285.0
2009-03-31 07:00:00	MSFT	Stock	17.74	17.78	17.74	17.77	4530.0
2009-03-31 08:00:00	MSFT	Stock	17.75	17.88	17.66	17.83	30600.0
2009-03-31 09:00:00	MSFT	Stock	17.82	18.4	17.78	18.26	8659238.0
2009-03-31 10:00:00	MSFT	Stock	18.26	18.56	18.17	18.39	12506362.0
2009-03-31 11:00:00	MSFT	Stock	18.38	18.57	18.378	18.471	6952255.0
2009-03-31 12:00:00	MSFT	Stock	18.48	18.58	18.43	18.56	7660822.0
2009-03-31 13:00:00	MSFT	Stock	18.55	18.67	18.53	18.6	7182015.0
2009-03-31 14:00:00	MSFT	Stock	18.6	18.79	18.57	18.682	10092007.0
2009-03-31 15:00:00	MSFT	Stock	18.69	18.75	18.3	18.33	29806773.0
2009-03-31 16:00:00	MSFT	Stock	18.33	18.648	18.3	18.37	7427798.0
2009-03-31 17:00:00	MSFT	Stock	18.37	18.38	18.28	18.32	297858.0
2009-03-31 18:00:00	MSFT	Stock	18.33	18.37	18.29	18.34	323504.0
2009-03-31 19:00:00	MSFT	Stock	18.34	18.37	18.3	18.37	8400.0
2009-03-31 08:00:00	NVDA	Stock	0.2473	0.2488	0.2473	0.2485	133680.0
2009-03-31 09:00:00	NVDA	Stock	0.2488	0.2488	0.245	0.246	79230120.0
2009-03-31 10:00:00	NVDA	Stock	0.2458	0.251	0.2448	0.2481	198233520.0
2009-03-31 11:00:00	NVDA	Stock	0.2482	0.2507	0.2478	0.25	93591520.0
2009-03-31 12:00:00	NVDA	Stock	0.25	0.2509	0.2478	0.2507	79337440.0
2009-03-31 13:00:00	NVDA	Stock	0.2507	0.2513	0.2488	0.25	66728040.0
2009-03-31 14:00:00	NVDA	Stock	0.25	0.2525	0.2495	0.2515	92527480.0
2009-03-31 15:00:00	NVDA	Stock	0.2515	0.2518	0.2453	0.2465	150116880.0
2009-03-31 16:00:00	NVDA	Stock	0.2462	0.2493	0.2448	0.2465	9411640.0
2009-03-31 17:00:00	NVDA	Stock	0.2465	0.2465	0.2418	0.2418	2029840.0
2009-03-31 18:00:00	NVDA	Stock	0.245	0.2462	0.245	0.2462	24000.0
2009-03-31 19:00:00	NVDA	Stock	0.2425	0.2425	0.2425	0.2425	8000.0
2009-03-31 07:00:00	AMZN	Stock	3.65	3.65	3.6165	3.6425	100000.0
2009-03-31 08:00:00	AMZN	Stock	3.63	3.6415	3.62	3.6325	304000.0
2009-03-31 09:00:00	AMZN	Stock	3.628	3.675	3.626	3.6605	26104800.0
2009-03-31 10:00:00	AMZN	Stock	3.6585	3.674	3.6245	3.628	22601740.0
2009-03-31 11:00:00	AMZN	Stock	3.628	3.6615	3.606	3.655	32640820.0
2009-03-31 12:00:00	AMZN	Stock	3.654	3.683	3.6475	3.6795	11684620.0
2009-03-31 13:00:00	AMZN	Stock	3.68	3.7095	3.676	3.698	19297820.0
2009-03-31 14:00:00	AMZN	Stock	3.6972	3.725	3.69	3.704	19363500.0
2009-03-31 15:00:00	AMZN	Stock	3.7045	3.7125	3.653	3.6705	36972220.0
2009-03-31 16:00:00	AMZN	Stock	3.671	3.705	3.657	3.665	8119280.0
2009-03-31 17:00:00	AMZN	Stock	3.672	3.672	3.66	3.66	421020.0

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

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