PREVIEW / stock_1hour / 2013-12-05

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-05.parquet
  size:    1.0 MB
  rows:    47,610
  symbols: 3,533

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-12-05 04:00:00	AAPL	Stock	20.1821	20.5714	20.1821	20.5321	297640.0
2013-12-05 05:00:00	AAPL	Stock	20.5321	20.5321	20.4643	20.4718	350196.0
2013-12-05 06:00:00	AAPL	Stock	20.4757	20.54	20.4464	20.4589	975604.0
2013-12-05 07:00:00	AAPL	Stock	20.4554	20.6207	20.4289	20.4614	4595836.0
2013-12-05 08:00:00	AAPL	Stock	20.4604	20.5786	20.1607	20.4504	13252036.0
2013-12-05 09:00:00	AAPL	Stock	20.455	20.5406	20.3482	20.3925	119810040.0
2013-12-05 10:00:00	AAPL	Stock	20.3929	20.4464	20.3057	20.4297	80041696.0
2013-12-05 11:00:00	AAPL	Stock	20.4321	20.4486	20.38	20.4196	33527564.0
2013-12-05 12:00:00	AAPL	Stock	20.4179	20.4482	20.4018	20.4032	30534196.0
2013-12-05 13:00:00	AAPL	Stock	20.4046	20.4354	20.3968	20.4239	22633044.0
2013-12-05 14:00:00	AAPL	Stock	20.4221	20.4375	20.2354	20.2386	48547772.0
2013-12-05 15:00:00	AAPL	Stock	20.2375	20.3621	20.2289	20.2893	56792904.0
2013-12-05 16:00:00	AAPL	Stock	20.2846	20.4336	20.1475	20.2861	26835340.0
2013-12-05 17:00:00	AAPL	Stock	20.2893	20.2896	20.2321	20.2443	975240.0
2013-12-05 18:00:00	AAPL	Stock	20.2421	20.2536	20.2364	20.2504	158984.0
2013-12-05 19:00:00	AAPL	Stock	20.2507	20.2536	20.2354	20.2429	544236.0
2013-12-05 07:00:00	MSFT	Stock	38.94	38.96	38.89	38.95	1119.0
2013-12-05 08:00:00	MSFT	Stock	38.95	38.96	38.63	38.67	21650.0
2013-12-05 09:00:00	MSFT	Stock	38.77	38.93	38.59	38.6	4716887.0
2013-12-05 10:00:00	MSFT	Stock	38.6	38.695	37.52	37.77	37703457.0
2013-12-05 11:00:00	MSFT	Stock	37.77	37.83	37.18	37.389	24962860.0
2013-12-05 12:00:00	MSFT	Stock	37.39	37.92	37.38	37.83	20639546.0
2013-12-05 13:00:00	MSFT	Stock	37.83	37.95	37.75	37.833	5368896.0
2013-12-05 14:00:00	MSFT	Stock	37.84	37.93	37.78	37.91	5080819.0
2013-12-05 15:00:00	MSFT	Stock	37.91	38.02	37.8	38.01	8908464.0
2013-12-05 16:00:00	MSFT	Stock	38.0	38.88	37.481	38.0	7074614.0
2013-12-05 17:00:00	MSFT	Stock	38.0	38.01	37.95	37.95	23327.0
2013-12-05 18:00:00	MSFT	Stock	38.0	38.0	37.96	37.97	4843.0
2013-12-05 19:00:00	MSFT	Stock	37.98	37.99	37.98	37.99	4028.0
2013-12-05 08:00:00	NVDA	Stock	0.4	0.4	0.3973	0.3975	31600.0
2013-12-05 09:00:00	NVDA	Stock	0.3975	0.3998	0.3965	0.3968	34025560.0
2013-12-05 10:00:00	NVDA	Stock	0.3968	0.3973	0.395	0.3956	30038000.0
2013-12-05 11:00:00	NVDA	Stock	0.3957	0.3988	0.3953	0.3978	21083160.0
2013-12-05 12:00:00	NVDA	Stock	0.3978	0.3985	0.3973	0.3973	16208600.0
2013-12-05 13:00:00	NVDA	Stock	0.3973	0.3975	0.394	0.394	30105040.0
2013-12-05 14:00:00	NVDA	Stock	0.3941	0.3948	0.3928	0.3938	39567080.0
2013-12-05 15:00:00	NVDA	Stock	0.3938	0.394	0.392	0.3928	76013200.0
2013-12-05 16:00:00	NVDA	Stock	0.3925	0.3984	0.3922	0.3924	7102520.0
2013-12-05 17:00:00	NVDA	Stock	0.3925	0.3925	0.3925	0.3925	67080.0
2013-12-05 06:00:00	AMZN	Stock	19.3495	19.3495	19.3495	19.3495	2000.0
2013-12-05 07:00:00	AMZN	Stock	19.342	19.342	19.342	19.342	5000.0
2013-12-05 08:00:00	AMZN	Stock	19.35	19.377	19.3315	19.3525	103740.0
2013-12-05 09:00:00	AMZN	Stock	19.3525	19.3525	19.1	19.2075	8308920.0
2013-12-05 10:00:00	AMZN	Stock	19.198	19.2485	19.0685	19.1415	6311160.0
2013-12-05 11:00:00	AMZN	Stock	19.142	19.1715	19.077	19.1088	3767600.0
2013-12-05 12:00:00	AMZN	Stock	19.106	19.244	19.1	19.224	3839820.0
2013-12-05 13:00:00	AMZN	Stock	19.2268	19.2425	19.165	19.1898	3583900.0
2013-12-05 14:00:00	AMZN	Stock	19.182	19.2105	19.118	19.1381	1990720.0
2013-12-05 15:00:00	AMZN	Stock	19.1395	19.2745	19.13	19.2245	6187060.0
2013-12-05 16:00:00	AMZN	Stock	19.224	19.2683	19.1776	19.2345	3107340.0

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

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