PREVIEW / stock_1hour / 2013-08-07

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-07.parquet
  size:    1006 KB
  rows:    46,530
  symbols: 3,503

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-08-07 07:00:00	AAPL	Stock	16.5571	16.5936	16.5464	16.5589	158312.0
2013-08-07 08:00:00	AAPL	Stock	16.5536	16.5904	16.5482	16.575	996436.0
2013-08-07 09:00:00	AAPL	Stock	16.5746	16.6786	16.5368	16.6206	45613456.0
2013-08-07 10:00:00	AAPL	Stock	16.6204	16.6293	16.4918	16.5561	56320152.0
2013-08-07 11:00:00	AAPL	Stock	16.558	16.5642	16.51	16.5292	21752864.0
2013-08-07 12:00:00	AAPL	Stock	16.5275	16.5843	16.5071	16.5693	19360460.0
2013-08-07 13:00:00	AAPL	Stock	16.57	16.6214	16.5575	16.6029	18286576.0
2013-08-07 14:00:00	AAPL	Stock	16.6074	16.6454	16.5693	16.5886	31798088.0
2013-08-07 15:00:00	AAPL	Stock	16.5921	16.6218	16.5718	16.605	40375748.0
2013-08-07 16:00:00	AAPL	Stock	16.6064	16.6111	16.5785	16.5818	41685252.0
2013-08-07 17:00:00	AAPL	Stock	16.5889	16.6064	16.5746	16.5746	366548.0
2013-08-07 18:00:00	AAPL	Stock	16.5779	16.5886	16.5714	16.5804	118048.0
2013-08-07 19:00:00	AAPL	Stock	16.5804	16.5893	16.5804	16.5893	81340.0
2013-08-07 08:00:00	MSFT	Stock	31.45	31.5	31.42	31.49	3343.0
2013-08-07 09:00:00	MSFT	Stock	31.49	31.56	31.43	31.47	2353222.0
2013-08-07 10:00:00	MSFT	Stock	31.46	31.487	31.25	31.39	5318671.0
2013-08-07 11:00:00	MSFT	Stock	31.4	31.44	31.25	31.31	3424980.0
2013-08-07 12:00:00	MSFT	Stock	31.307	31.48	31.29	31.48	2617723.0
2013-08-07 13:00:00	MSFT	Stock	31.475	31.64	31.46	31.511	3129355.0
2013-08-07 14:00:00	MSFT	Stock	31.52	31.9	31.5	31.89	5194376.0
2013-08-07 15:00:00	MSFT	Stock	31.89	32.1	31.89	32.065	13454006.0
2013-08-07 16:00:00	MSFT	Stock	32.06	32.11	31.334	32.05	1777606.0
2013-08-07 17:00:00	MSFT	Stock	32.03	32.063	32.03	32.05	18817.0
2013-08-07 18:00:00	MSFT	Stock	32.03	32.05	31.97	32.04	6938.0
2013-08-07 19:00:00	MSFT	Stock	32.04	32.04	32.01	32.01	8213.0
2013-08-07 09:00:00	NVDA	Stock	0.365	0.3678	0.363	0.3645	20179880.0
2013-08-07 10:00:00	NVDA	Stock	0.3642	0.3688	0.364	0.3675	69173600.0
2013-08-07 11:00:00	NVDA	Stock	0.3672	0.368	0.3665	0.367	24942240.0
2013-08-07 12:00:00	NVDA	Stock	0.367	0.3685	0.3668	0.3679	26905760.0
2013-08-07 13:00:00	NVDA	Stock	0.3678	0.3682	0.3672	0.3678	15754240.0
2013-08-07 14:00:00	NVDA	Stock	0.3675	0.368	0.3652	0.3652	37952880.0
2013-08-07 15:00:00	NVDA	Stock	0.3655	0.366	0.3648	0.3652	38235840.0
2013-08-07 16:00:00	NVDA	Stock	0.365	0.3658	0.365	0.3658	10889400.0
2013-08-07 17:00:00	NVDA	Stock	0.3648	0.365	0.3648	0.365	54080.0
2013-08-07 07:00:00	AMZN	Stock	14.965	14.965	14.965	14.965	2000.0
2013-08-07 08:00:00	AMZN	Stock	14.9745	14.9895	14.962	14.983	40380.0
2013-08-07 09:00:00	AMZN	Stock	15.0	15.0495	14.903	14.9155	6915080.0
2013-08-07 10:00:00	AMZN	Stock	14.915	14.9225	14.8075	14.8615	8215500.0
2013-08-07 11:00:00	AMZN	Stock	14.862	14.87	14.8245	14.8402	5686680.0
2013-08-07 12:00:00	AMZN	Stock	14.843	14.897	14.8425	14.8605	2334560.0
2013-08-07 13:00:00	AMZN	Stock	14.8605	14.889	14.854	14.8725	3342340.0
2013-08-07 14:00:00	AMZN	Stock	14.869	14.8775	14.8172	14.844	3549020.0
2013-08-07 15:00:00	AMZN	Stock	14.8425	14.8805	14.824	14.8415	7032100.0
2013-08-07 16:00:00	AMZN	Stock	14.8455	14.968	14.8365	14.8455	987000.0
2013-08-07 17:00:00	AMZN	Stock	14.846	14.85	14.827	14.827	74920.0
2013-08-07 18:00:00	AMZN	Stock	14.8415	14.8415	14.8415	14.8415	2000.0
2013-08-07 04:00:00	META	Stock	38.23	38.46	38.19	38.3	13021.0
2013-08-07 05:00:00	META	Stock	38.27	38.35	38.25	38.26	5500.0
2013-08-07 06:00:00	META	Stock	38.34	38.43	38.34	38.35	10877.0
2013-08-07 07:00:00	META	Stock	38.32	38.75	38.24	38.55	233266.0

> showing 50 of 46,530 rows — these rows as CSV

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