PREVIEW / stock_1hour / 2013-11-13

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-11-13.parquet
  size:    1.0 MB
  rows:    47,374
  symbols: 3,534

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
2013-11-13 04:00:00	AAPL	Stock	18.5625	18.5643	18.5375	18.5375	35112.0
2013-11-13 05:00:00	AAPL	Stock	18.5568	18.5568	18.5568	18.5568	2800.0
2013-11-13 06:00:00	AAPL	Stock	18.5364	18.5714	18.5364	18.5714	8400.0
2013-11-13 07:00:00	AAPL	Stock	18.5554	18.5982	18.5446	18.5536	213892.0
2013-11-13 08:00:00	AAPL	Stock	18.55	18.5971	18.4911	18.5071	5305496.0
2013-11-13 09:00:00	AAPL	Stock	18.5046	18.5607	18.4629	18.5536	34725684.0
2013-11-13 10:00:00	AAPL	Stock	18.5532	18.5979	18.5243	18.5539	36164744.0
2013-11-13 11:00:00	AAPL	Stock	18.5529	18.5971	18.5379	18.5875	19670672.0
2013-11-13 12:00:00	AAPL	Stock	18.59	18.6518	18.5689	18.6075	23433704.0
2013-11-13 13:00:00	AAPL	Stock	18.6069	18.6189	18.5611	18.5696	15289708.0
2013-11-13 14:00:00	AAPL	Stock	18.5625	18.5779	18.515	18.5436	17164532.0
2013-11-13 15:00:00	AAPL	Stock	18.5432	18.5989	18.5411	18.5971	28591220.0
2013-11-13 16:00:00	AAPL	Stock	18.5982	18.6071	18.5514	18.605	10803800.0
2013-11-13 17:00:00	AAPL	Stock	18.5986	18.5986	18.5536	18.5539	366016.0
2013-11-13 18:00:00	AAPL	Stock	18.5607	18.5982	18.5589	18.5804	81984.0
2013-11-13 19:00:00	AAPL	Stock	18.5879	18.6036	18.5879	18.5914	265076.0
2013-11-13 07:00:00	MSFT	Stock	37.12	37.12	37.12	37.12	300.0
2013-11-13 08:00:00	MSFT	Stock	37.24	37.36	37.02	37.07	99930.0
2013-11-13 09:00:00	MSFT	Stock	37.06	37.14	36.9	37.05	7184935.0
2013-11-13 10:00:00	MSFT	Stock	37.045	37.22	37.01	37.185	5442221.0
2013-11-13 11:00:00	MSFT	Stock	37.182	37.19	36.96	37.15	4489751.0
2013-11-13 12:00:00	MSFT	Stock	37.15	37.57	37.12	37.57	3996973.0
2013-11-13 13:00:00	MSFT	Stock	37.56	37.7	37.46	37.67	2946855.0
2013-11-13 14:00:00	MSFT	Stock	37.68	37.74	37.66	37.715	2915375.0
2013-11-13 15:00:00	MSFT	Stock	37.72	38.16	37.71	38.15	11361863.0
2013-11-13 16:00:00	MSFT	Stock	38.15	38.17	37.091	38.14	4365785.0
2013-11-13 17:00:00	MSFT	Stock	38.06	38.16	37.88	37.9	67638.0
2013-11-13 18:00:00	MSFT	Stock	37.9	38.16	37.88	37.94	5877.0
2013-11-13 19:00:00	MSFT	Stock	37.9	38.0	37.88	38.0	10200.0
2013-11-13 08:00:00	NVDA	Stock	0.3925	0.3925	0.3913	0.3913	12000.0
2013-11-13 09:00:00	NVDA	Stock	0.3885	0.395	0.3885	0.3942	53940240.0
2013-11-13 10:00:00	NVDA	Stock	0.394	0.3968	0.3938	0.3965	43607040.0
2013-11-13 11:00:00	NVDA	Stock	0.3965	0.3993	0.3962	0.3978	34562400.0
2013-11-13 12:00:00	NVDA	Stock	0.3978	0.3995	0.3973	0.3995	18244520.0
2013-11-13 13:00:00	NVDA	Stock	0.3995	0.4022	0.3993	0.4006	57358840.0
2013-11-13 14:00:00	NVDA	Stock	0.4005	0.4025	0.4005	0.4022	27161960.0
2013-11-13 15:00:00	NVDA	Stock	0.4024	0.4038	0.4015	0.4038	78883600.0
2013-11-13 16:00:00	NVDA	Stock	0.4038	0.4038	0.399	0.402	16265040.0
2013-11-13 17:00:00	NVDA	Stock	0.4013	0.4013	0.4013	0.4013	94000.0
2013-11-13 19:00:00	NVDA	Stock	0.4048	0.4048	0.4048	0.4048	6000.0
2013-11-13 07:00:00	AMZN	Stock	17.4445	17.4445	17.4445	17.4445	2000.0
2013-11-13 08:00:00	AMZN	Stock	17.431	17.4765	17.36	17.36	448920.0
2013-11-13 09:00:00	AMZN	Stock	17.36	17.4367	17.284	17.363	5901520.0
2013-11-13 10:00:00	AMZN	Stock	17.3525	17.557	17.35	17.499	8467980.0
2013-11-13 11:00:00	AMZN	Stock	17.505	17.534	17.4695	17.483	4946860.0
2013-11-13 12:00:00	AMZN	Stock	17.489	17.608	17.45	17.6035	4266900.0
2013-11-13 13:00:00	AMZN	Stock	17.592	17.726	17.5725	17.718	4615720.0
2013-11-13 14:00:00	AMZN	Stock	17.7215	17.7275	17.68	17.7184	5241660.0
2013-11-13 15:00:00	AMZN	Stock	17.7122	17.811	17.71	17.811	17076040.0
2013-11-13 16:00:00	AMZN	Stock	17.808	17.83	17.6046	17.8115	4290760.0

> showing 50 of 47,374 rows — these rows as CSV

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