PREVIEW / stock_1hour / 2009-06-11

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-06-11.parquet
  size:    858 KB
  rows:    41,854
  symbols: 3,368

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-06-11 07:00:00	AAPL	Stock	5.0221	5.0286	4.9996	5.0089	150472.0
2009-06-11 08:00:00	AAPL	Stock	5.0136	5.0396	4.975	4.9796	1530452.0
2009-06-11 09:00:00	AAPL	Stock	4.9804	5.0337	4.9482	5.0146	90714764.0
2009-06-11 10:00:00	AAPL	Stock	5.0146	5.0557	4.9932	5.0239	89588772.0
2009-06-11 11:00:00	AAPL	Stock	5.0243	5.0518	5.0179	5.0289	51888284.0
2009-06-11 12:00:00	AAPL	Stock	5.0289	5.0304	4.9911	5.0275	62716472.0
2009-06-11 13:00:00	AAPL	Stock	5.0271	5.0429	5.0136	5.0193	54284384.0
2009-06-11 14:00:00	AAPL	Stock	5.0193	5.0261	4.9943	5.0154	62157872.0
2009-06-11 15:00:00	AAPL	Stock	5.015	5.0339	4.9871	4.9921	89861548.0
2009-06-11 16:00:00	AAPL	Stock	4.9982	5.0164	4.9825	5.0164	10756620.0
2009-06-11 17:00:00	AAPL	Stock	4.9914	4.9929	4.9875	4.9929	69160.0
2009-06-11 18:00:00	AAPL	Stock	4.9982	4.9982	4.9864	4.9925	263256.0
2009-06-11 19:00:00	AAPL	Stock	4.9882	4.99	4.9821	4.9821	419804.0
2009-06-11 08:00:00	MSFT	Stock	22.59	22.59	22.47	22.47	23510.0
2009-06-11 09:00:00	MSFT	Stock	22.47	23.0	22.45	22.94	6908079.0
2009-06-11 10:00:00	MSFT	Stock	22.94	22.95	22.77	22.81	9150868.0
2009-06-11 11:00:00	MSFT	Stock	22.8	22.92	22.78	22.82	4398505.0
2009-06-11 12:00:00	MSFT	Stock	22.82	22.92	22.73	22.91	5063998.0
2009-06-11 13:00:00	MSFT	Stock	22.91	23.26	22.91	23.18	12610275.0
2009-06-11 14:00:00	MSFT	Stock	23.18	23.2	23.05	23.122	7059419.0
2009-06-11 15:00:00	MSFT	Stock	23.12	23.12	22.76	22.82	14312391.0
2009-06-11 16:00:00	MSFT	Stock	22.82	22.981	22.74	22.934	2951999.0
2009-06-11 17:00:00	MSFT	Stock	22.84	22.84	22.83	22.83	2194.0
2009-06-11 18:00:00	MSFT	Stock	22.82	22.83	22.82	22.82	4810.0
2009-06-11 08:00:00	NVDA	Stock	0.2908	0.2948	0.2908	0.2948	28000.0
2009-06-11 09:00:00	NVDA	Stock	0.294	0.305	0.2928	0.3018	126638200.0
2009-06-11 10:00:00	NVDA	Stock	0.3018	0.3025	0.297	0.2972	132279080.0
2009-06-11 11:00:00	NVDA	Stock	0.2972	0.299	0.2922	0.2922	105287720.0
2009-06-11 12:00:00	NVDA	Stock	0.2922	0.2925	0.2875	0.2922	126115800.0
2009-06-11 13:00:00	NVDA	Stock	0.2922	0.2945	0.2905	0.2925	57453640.0
2009-06-11 14:00:00	NVDA	Stock	0.2925	0.2935	0.2905	0.2922	62448160.0
2009-06-11 15:00:00	NVDA	Stock	0.2922	0.2925	0.2882	0.2888	195587280.0
2009-06-11 16:00:00	NVDA	Stock	0.2892	0.2943	0.2878	0.2878	20700920.0
2009-06-11 17:00:00	NVDA	Stock	0.29	0.29	0.29	0.29	12440.0
2009-06-11 18:00:00	NVDA	Stock	0.2888	0.2912	0.2888	0.2912	71040.0
2009-06-11 19:00:00	NVDA	Stock	0.2922	0.2922	0.2922	0.2922	8000.0
2009-06-11 07:00:00	AMZN	Stock	4.35	4.35	4.35	4.35	2000.0
2009-06-11 08:00:00	AMZN	Stock	4.325	4.33	4.305	4.305	82500.0
2009-06-11 09:00:00	AMZN	Stock	4.305	4.3485	4.2525	4.3358	15422220.0
2009-06-11 10:00:00	AMZN	Stock	4.337	4.3745	4.323	4.346	15179920.0
2009-06-11 11:00:00	AMZN	Stock	4.345	4.3465	4.3135	4.3173	7741480.0
2009-06-11 12:00:00	AMZN	Stock	4.317	4.3365	4.2825	4.3335	9668100.0
2009-06-11 13:00:00	AMZN	Stock	4.332	4.353	4.312	4.3345	9244320.0
2009-06-11 14:00:00	AMZN	Stock	4.3338	4.3385	4.3105	4.327	9122980.0
2009-06-11 15:00:00	AMZN	Stock	4.3255	4.3325	4.279	4.2825	25576260.0
2009-06-11 16:00:00	AMZN	Stock	4.281	4.3184	4.2715	4.3132	62340.0
2009-06-11 17:00:00	AMZN	Stock	4.2765	4.2765	4.2728	4.2728	49820.0
2009-06-11 18:00:00	AMZN	Stock	4.27	4.271	4.267	4.267	45000.0
2009-06-11 19:00:00	AMZN	Stock	4.27	4.27	4.256	4.259	27500.0
2009-06-11 07:00:00	TLT	Stock	88.06	88.06	87.83	87.85	2300.0

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

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