PREVIEW / stock_1hour / 2010-06-23

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-06-23.parquet
  size:    877 KB
  rows:    42,642
  symbols: 3,437

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-06-23 04:00:00	AAPL	Stock	9.8393	9.8393	9.8393	9.8393	2800.0
2010-06-23 05:00:00	AAPL	Stock	9.8393	9.8929	9.8393	9.8929	57568.0
2010-06-23 06:00:00	AAPL	Stock	9.8929	9.8929	9.8857	9.8929	22400.0
2010-06-23 07:00:00	AAPL	Stock	9.8575	9.8575	9.8	9.8354	1522556.0
2010-06-23 08:00:00	AAPL	Stock	9.8357	9.8482	9.8146	9.8261	4747988.0
2010-06-23 09:00:00	AAPL	Stock	9.8264	9.8307	9.625	9.6474	147055076.0
2010-06-23 10:00:00	AAPL	Stock	9.6475	9.6818	9.5679	9.67	177465288.0
2010-06-23 11:00:00	AAPL	Stock	9.6698	9.6857	9.6339	9.655	64040424.0
2010-06-23 12:00:00	AAPL	Stock	9.6546	9.7311	9.6186	9.6882	55410264.0
2010-06-23 13:00:00	AAPL	Stock	9.6861	9.7196	9.6536	9.7125	50070552.0
2010-06-23 14:00:00	AAPL	Stock	9.7111	9.7539	9.6296	9.6532	126704116.0
2010-06-23 15:00:00	AAPL	Stock	9.655	9.725	9.6071	9.6779	121417968.0
2010-06-23 16:00:00	AAPL	Stock	9.6761	9.8007	9.6436	9.6607	6856164.0
2010-06-23 17:00:00	AAPL	Stock	9.6636	9.6775	9.6418	9.6418	945448.0
2010-06-23 18:00:00	AAPL	Stock	9.6429	9.6775	9.6375	9.6536	466816.0
2010-06-23 19:00:00	AAPL	Stock	9.6604	9.6604	9.6464	9.6482	296912.0
2010-06-23 08:00:00	MSFT	Stock	25.95	25.95	25.85	25.9	4848.0
2010-06-23 09:00:00	MSFT	Stock	25.85	25.88	25.45	25.54	6111436.0
2010-06-23 10:00:00	MSFT	Stock	25.53	25.53	25.25	25.36	10778547.0
2010-06-23 11:00:00	MSFT	Stock	25.36	25.46	25.3	25.34	4984094.0
2010-06-23 12:00:00	MSFT	Stock	25.348	25.48	25.322	25.45	3033801.0
2010-06-23 13:00:00	MSFT	Stock	25.45	25.52	25.37	25.44	4977952.0
2010-06-23 14:00:00	MSFT	Stock	25.43	25.58	25.3	25.352	10332044.0
2010-06-23 15:00:00	MSFT	Stock	25.36	25.42	25.22	25.32	16854599.0
2010-06-23 16:00:00	MSFT	Stock	25.33	25.399	25.25	25.31	2482231.0
2010-06-23 17:00:00	MSFT	Stock	25.33	25.385	25.31	25.32	128772.0
2010-06-23 18:00:00	MSFT	Stock	25.32	25.34	25.31	25.31	65678.0
2010-06-23 19:00:00	MSFT	Stock	25.31	25.34	25.31	25.34	1700.0
2010-06-23 08:00:00	NVDA	Stock	0.2918	0.2932	0.291	0.2928	290800.0
2010-06-23 09:00:00	NVDA	Stock	0.2918	0.2925	0.2875	0.2898	64191720.0
2010-06-23 10:00:00	NVDA	Stock	0.2898	0.2898	0.2835	0.2869	110415880.0
2010-06-23 11:00:00	NVDA	Stock	0.2872	0.2878	0.2848	0.2875	32926320.0
2010-06-23 12:00:00	NVDA	Stock	0.2872	0.291	0.2868	0.2905	41168120.0
2010-06-23 13:00:00	NVDA	Stock	0.2906	0.292	0.2902	0.2918	28918000.0
2010-06-23 14:00:00	NVDA	Stock	0.2918	0.2952	0.2898	0.2918	179474760.0
2010-06-23 15:00:00	NVDA	Stock	0.2918	0.2935	0.2898	0.292	149147200.0
2010-06-23 16:00:00	NVDA	Stock	0.292	0.2935	0.289	0.2915	6495000.0
2010-06-23 17:00:00	NVDA	Stock	0.2922	0.2922	0.2915	0.2915	383280.0
2010-06-23 18:00:00	NVDA	Stock	0.292	0.2925	0.292	0.2925	36000.0
2010-06-23 19:00:00	NVDA	Stock	0.2925	0.2925	0.2925	0.2925	20000.0
2010-06-23 08:00:00	AMZN	Stock	6.1155	6.144	6.11	6.1255	148800.0
2010-06-23 09:00:00	AMZN	Stock	6.126	6.161	6.0765	6.1055	15014980.0
2010-06-23 10:00:00	AMZN	Stock	6.1055	6.106	6.002	6.0404	22658440.0
2010-06-23 11:00:00	AMZN	Stock	6.04	6.0565	6.0095	6.049	7690420.0
2010-06-23 12:00:00	AMZN	Stock	6.0475	6.0625	6.0335	6.044	7216960.0
2010-06-23 13:00:00	AMZN	Stock	6.046	6.0985	6.0245	6.085	12603560.0
2010-06-23 14:00:00	AMZN	Stock	6.085	6.135	6.05	6.0775	13146580.0
2010-06-23 15:00:00	AMZN	Stock	6.078	6.0955	6.039	6.0725	28349000.0
2010-06-23 16:00:00	AMZN	Stock	6.0715	6.1155	6.0275	6.0555	740760.0
2010-06-23 17:00:00	AMZN	Stock	6.0725	6.0725	6.0405	6.0405	133740.0

> showing 50 of 42,642 rows — these rows as CSV

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