PREVIEW / stock_1hour / 2012-11-21

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-11-21.parquet
  size:    909 KB
  rows:    42,839
  symbols: 3,453

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
2012-11-21 04:00:00	AAPL	Stock	20.125	20.1607	20.125	20.125	37520.0
2012-11-21 05:00:00	AAPL	Stock	20.1071	20.1071	20.0893	20.0896	72800.0
2012-11-21 06:00:00	AAPL	Stock	20.1071	20.1425	20.1071	20.1425	69720.0
2012-11-21 07:00:00	AAPL	Stock	20.1318	20.1318	20.0718	20.0718	455280.0
2012-11-21 08:00:00	AAPL	Stock	20.0714	20.1336	20.0464	20.1318	2077320.0
2012-11-21 09:00:00	AAPL	Stock	20.1279	20.2632	20.045	20.095	82313028.0
2012-11-21 10:00:00	AAPL	Stock	20.1018	20.105	19.8786	19.9439	88147304.0
2012-11-21 11:00:00	AAPL	Stock	19.9443	20.0629	19.9293	19.9354	48264356.0
2012-11-21 12:00:00	AAPL	Stock	19.9389	20.1357	19.9357	20.1096	40220628.0
2012-11-21 13:00:00	AAPL	Stock	20.1121	20.1229	20.0214	20.0879	25679164.0
2012-11-21 14:00:00	AAPL	Stock	20.0853	20.1214	20.0407	20.0909	24714032.0
2012-11-21 15:00:00	AAPL	Stock	20.0939	20.1136	20.0282	20.0611	43844612.0
2012-11-21 16:00:00	AAPL	Stock	20.0607	20.0857	20.0543	20.0846	7510412.0
2012-11-21 17:00:00	AAPL	Stock	20.0836	20.0946	20.0796	20.0854	304052.0
2012-11-21 18:00:00	AAPL	Stock	20.0775	20.0911	20.0768	20.0911	93520.0
2012-11-21 19:00:00	AAPL	Stock	20.0893	20.0961	20.0811	20.0821	181328.0
2012-11-21 07:00:00	MSFT	Stock	26.7	26.7	26.7	26.7	3500.0
2012-11-21 08:00:00	MSFT	Stock	26.72	26.75	26.71	26.75	16710.0
2012-11-21 09:00:00	MSFT	Stock	26.75	27.02	26.66	27.005	6722023.0
2012-11-21 10:00:00	MSFT	Stock	27.01	27.02	26.815	26.86	6346683.0
2012-11-21 11:00:00	MSFT	Stock	26.86	26.99	26.85	26.93	4033894.0
2012-11-21 12:00:00	MSFT	Stock	26.93	26.99	26.9	26.99	4179433.0
2012-11-21 13:00:00	MSFT	Stock	26.985	27.02	26.97	27.01	3395410.0
2012-11-21 14:00:00	MSFT	Stock	27.005	27.02	26.99	27.0	2411048.0
2012-11-21 15:00:00	MSFT	Stock	27.01	27.01	26.94	26.95	8153018.0
2012-11-21 16:00:00	MSFT	Stock	26.95	26.987	26.872	26.94	5048425.0
2012-11-21 17:00:00	MSFT	Stock	26.93	26.94	26.9	26.92	750.0
2012-11-21 18:00:00	MSFT	Stock	26.92	26.94	26.92	26.92	10770.0
2012-11-21 19:00:00	MSFT	Stock	26.94	26.99	26.94	26.99	8588.0
2012-11-21 09:00:00	NVDA	Stock	0.2872	0.2926	0.287	0.2916	54053760.0
2012-11-21 10:00:00	NVDA	Stock	0.2915	0.2938	0.2905	0.2932	90113640.0
2012-11-21 11:00:00	NVDA	Stock	0.2935	0.2952	0.2932	0.2948	58859280.0
2012-11-21 12:00:00	NVDA	Stock	0.2946	0.296	0.294	0.2953	39832360.0
2012-11-21 13:00:00	NVDA	Stock	0.2952	0.2955	0.2938	0.295	36309120.0
2012-11-21 14:00:00	NVDA	Stock	0.2949	0.2962	0.2948	0.2962	32088400.0
2012-11-21 15:00:00	NVDA	Stock	0.296	0.2962	0.2948	0.2958	94736680.0
2012-11-21 16:00:00	NVDA	Stock	0.2958	0.2962	0.2912	0.2912	15868000.0
2012-11-21 17:00:00	NVDA	Stock	0.295	0.295	0.295	0.295	26000.0
2012-11-21 06:00:00	AMZN	Stock	11.7	11.7	11.664	11.685	38000.0
2012-11-21 07:00:00	AMZN	Stock	11.685	11.685	11.685	11.685	8000.0
2012-11-21 08:00:00	AMZN	Stock	11.7	11.7	11.668	11.68	191440.0
2012-11-21 09:00:00	AMZN	Stock	11.686	11.8	11.673	11.7135	9754820.0
2012-11-21 10:00:00	AMZN	Stock	11.723	11.742	11.6375	11.6882	8856820.0
2012-11-21 11:00:00	AMZN	Stock	11.6875	11.7495	11.6795	11.7355	3989880.0
2012-11-21 12:00:00	AMZN	Stock	11.7375	11.808	11.734	11.806	4425180.0
2012-11-21 13:00:00	AMZN	Stock	11.803	11.8739	11.789	11.8403	5629800.0
2012-11-21 14:00:00	AMZN	Stock	11.8385	11.9335	11.8385	11.9295	8644000.0
2012-11-21 15:00:00	AMZN	Stock	11.9285	11.9285	11.8725	11.9035	12122660.0
2012-11-21 16:00:00	AMZN	Stock	11.9015	11.919	11.6993	11.9075	2806400.0
2012-11-21 17:00:00	AMZN	Stock	11.9015	11.9015	11.9	11.9	22620.0

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

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