PREVIEW / stock_1hour / 2009-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-03-23.parquet
  size:    832 KB
  rows:    41,000
  symbols: 3,335

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-23 04:00:00	AAPL	Stock	3.7018	3.7018	3.7018	3.7018	5600.0
2009-03-23 06:00:00	AAPL	Stock	3.6989	3.6989	3.6986	3.6986	5600.0
2009-03-23 07:00:00	AAPL	Stock	3.7179	3.7179	3.675	3.6857	306404.0
2009-03-23 08:00:00	AAPL	Stock	3.6857	3.6964	3.6732	3.6821	1992676.0
2009-03-23 09:00:00	AAPL	Stock	3.6832	3.7	3.6339	3.6925	88896332.0
2009-03-23 10:00:00	AAPL	Stock	3.6929	3.7468	3.6925	3.7418	108786272.0
2009-03-23 11:00:00	AAPL	Stock	3.7414	3.7654	3.7407	3.7625	80978016.0
2009-03-23 12:00:00	AAPL	Stock	3.7626	3.7743	3.7418	3.7454	54166252.0
2009-03-23 13:00:00	AAPL	Stock	3.7454	3.7664	3.7289	3.7452	55425692.0
2009-03-23 14:00:00	AAPL	Stock	3.7439	3.7814	3.7339	3.7786	65752008.0
2009-03-23 15:00:00	AAPL	Stock	3.7786	3.8629	3.7707	3.8432	159351696.0
2009-03-23 16:00:00	AAPL	Stock	3.8429	3.8521	3.748	3.8454	35829612.0
2009-03-23 17:00:00	AAPL	Stock	3.8429	3.8429	3.8275	3.83	322924.0
2009-03-23 18:00:00	AAPL	Stock	3.845	3.8464	3.8339	3.8429	8039164.0
2009-03-23 19:00:00	AAPL	Stock	3.8489	3.8496	3.8354	3.8357	141484.0
2009-03-23 05:00:00	MSFT	Stock	17.3	17.3	17.3	17.3	500.0
2009-03-23 07:00:00	MSFT	Stock	17.31	17.51	17.28	17.4	2500.0
2009-03-23 08:00:00	MSFT	Stock	17.35	17.43	17.32	17.35	52395.0
2009-03-23 09:00:00	MSFT	Stock	17.4	17.49	17.31	17.47	6853402.0
2009-03-23 10:00:00	MSFT	Stock	17.47	17.75	17.47	17.683	10294532.0
2009-03-23 11:00:00	MSFT	Stock	17.69	17.83	17.64	17.8	5209844.0
2009-03-23 12:00:00	MSFT	Stock	17.82	17.85	17.69	17.78	5694990.0
2009-03-23 13:00:00	MSFT	Stock	17.78	17.88	17.61	17.72	5049716.0
2009-03-23 14:00:00	MSFT	Stock	17.72	17.94	17.64	17.92	6119218.0
2009-03-23 15:00:00	MSFT	Stock	17.91	18.35	17.85	18.34	21048155.0
2009-03-23 16:00:00	MSFT	Stock	18.35	18.59	17.785	18.26	10123418.0
2009-03-23 17:00:00	MSFT	Stock	18.26	18.27	17.7	18.25	35459.0
2009-03-23 18:00:00	MSFT	Stock	18.25	18.33	18.25	18.28	416383.0
2009-03-23 19:00:00	MSFT	Stock	18.28	18.28	18.22	18.22	5609.0
2009-03-23 08:00:00	NVDA	Stock	0.24	0.2495	0.24	0.2475	320000.0
2009-03-23 09:00:00	NVDA	Stock	0.2475	0.2475	0.2402	0.244	86136120.0
2009-03-23 10:00:00	NVDA	Stock	0.244	0.2485	0.244	0.2475	137082880.0
2009-03-23 11:00:00	NVDA	Stock	0.2476	0.2488	0.2462	0.248	77157120.0
2009-03-23 12:00:00	NVDA	Stock	0.248	0.2485	0.2455	0.2458	70047840.0
2009-03-23 13:00:00	NVDA	Stock	0.2458	0.2475	0.245	0.2455	47492560.0
2009-03-23 14:00:00	NVDA	Stock	0.2455	0.2489	0.2455	0.2485	78931520.0
2009-03-23 15:00:00	NVDA	Stock	0.2486	0.2558	0.247	0.2553	274967120.0
2009-03-23 16:00:00	NVDA	Stock	0.2553	0.256	0.248	0.2505	37260280.0
2009-03-23 17:00:00	NVDA	Stock	0.2543	0.2545	0.2494	0.2545	1928000.0
2009-03-23 19:00:00	NVDA	Stock	0.2543	0.2553	0.2543	0.2553	142680.0
2009-03-23 04:00:00	AMZN	Stock	3.5905	3.5905	3.56	3.5875	16000.0
2009-03-23 07:00:00	AMZN	Stock	3.5915	3.5915	3.55	3.55	16000.0
2009-03-23 08:00:00	AMZN	Stock	3.575	3.5765	3.55	3.575	678700.0
2009-03-23 09:00:00	AMZN	Stock	3.572	3.581	3.535	3.58	16463440.0
2009-03-23 10:00:00	AMZN	Stock	3.5805	3.658	3.579	3.654	31918820.0
2009-03-23 11:00:00	AMZN	Stock	3.655	3.6765	3.6355	3.6715	22732380.0
2009-03-23 12:00:00	AMZN	Stock	3.672	3.688	3.666	3.6755	11277660.0
2009-03-23 13:00:00	AMZN	Stock	3.675	3.6895	3.657	3.6635	13208680.0
2009-03-23 14:00:00	AMZN	Stock	3.664	3.7155	3.6625	3.714	16800040.0
2009-03-23 15:00:00	AMZN	Stock	3.7132	3.78	3.709	3.78	48842220.0

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

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