PREVIEW / stock_1hour / 2013-10-11

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-10-11.parquet
  size:    1012 KB
  rows:    46,653
  symbols: 3,538

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-10-11 04:00:00	AAPL	Stock	17.4286	17.4643	17.4286	17.4643	25200.0
2013-10-11 05:00:00	AAPL	Stock	17.4625	17.4625	17.4214	17.4443	8400.0
2013-10-11 06:00:00	AAPL	Stock	17.4196	17.4289	17.3714	17.4096	23884.0
2013-10-11 07:00:00	AAPL	Stock	17.4286	17.4286	17.3929	17.3996	270704.0
2013-10-11 08:00:00	AAPL	Stock	17.4068	17.4871	17.35	17.3936	2479232.0
2013-10-11 09:00:00	AAPL	Stock	17.3996	17.4464	17.3271	17.4414	44671116.0
2013-10-11 10:00:00	AAPL	Stock	17.4414	17.4532	17.3621	17.3864	33936280.0
2013-10-11 11:00:00	AAPL	Stock	17.3837	17.5179	17.38	17.512	31421852.0
2013-10-11 12:00:00	AAPL	Stock	17.5118	17.5496	17.503	17.5416	33168408.0
2013-10-11 13:00:00	AAPL	Stock	17.5382	17.6111	17.5254	17.6043	35423780.0
2013-10-11 14:00:00	AAPL	Stock	17.6046	17.6371	17.5793	17.5935	23929640.0
2013-10-11 15:00:00	AAPL	Stock	17.5932	17.6082	17.5607	17.605	46767140.0
2013-10-11 16:00:00	AAPL	Stock	17.605	17.6225	17.4003	17.6032	12775980.0
2013-10-11 17:00:00	AAPL	Stock	17.6036	17.6036	17.5936	17.5982	224784.0
2013-10-11 18:00:00	AAPL	Stock	17.5982	17.6068	17.5982	17.6036	115892.0
2013-10-11 19:00:00	AAPL	Stock	17.6036	17.6179	17.6	17.6179	257208.0
2013-10-11 07:00:00	MSFT	Stock	33.67	33.67	33.67	33.67	427.0
2013-10-11 08:00:00	MSFT	Stock	33.5	33.81	33.5	33.64	61888.0
2013-10-11 09:00:00	MSFT	Stock	33.7	33.99	33.68	33.96	3663235.0
2013-10-11 10:00:00	MSFT	Stock	33.96	33.99	33.74	33.93	4320708.0
2013-10-11 11:00:00	MSFT	Stock	33.92	34.06	33.88	34.06	3790730.0
2013-10-11 12:00:00	MSFT	Stock	34.05	34.13	34.0	34.02	3657413.0
2013-10-11 13:00:00	MSFT	Stock	34.02	34.06	33.96	34.03	2199272.0
2013-10-11 14:00:00	MSFT	Stock	34.02	34.09	34.0	34.02	2093196.0
2013-10-11 15:00:00	MSFT	Stock	34.02	34.14	34.0	34.13	6714702.0
2013-10-11 16:00:00	MSFT	Stock	34.13	34.16	33.723	34.13	2937177.0
2013-10-11 17:00:00	MSFT	Stock	34.13	34.13	34.13	34.13	3918.0
2013-10-11 18:00:00	MSFT	Stock	34.14	34.17	34.14	34.17	1824.0
2013-10-11 04:00:00	NVDA	Stock	0.3848	0.3848	0.3848	0.3848	7200.0
2013-10-11 05:00:00	NVDA	Stock	0.377	0.377	0.377	0.377	90560.0
2013-10-11 07:00:00	NVDA	Stock	0.3768	0.3768	0.375	0.375	44000.0
2013-10-11 08:00:00	NVDA	Stock	0.375	0.3805	0.3708	0.3805	539840.0
2013-10-11 09:00:00	NVDA	Stock	0.381	0.3825	0.3775	0.3818	45231400.0
2013-10-11 10:00:00	NVDA	Stock	0.3815	0.3825	0.3805	0.3818	34544480.0
2013-10-11 11:00:00	NVDA	Stock	0.3818	0.3824	0.3813	0.3821	23560400.0
2013-10-11 12:00:00	NVDA	Stock	0.3821	0.3825	0.3818	0.3822	17775480.0
2013-10-11 13:00:00	NVDA	Stock	0.3822	0.3833	0.382	0.3828	23789480.0
2013-10-11 14:00:00	NVDA	Stock	0.3828	0.3835	0.3822	0.3825	15996880.0
2013-10-11 15:00:00	NVDA	Stock	0.3825	0.3828	0.3813	0.3815	43337000.0
2013-10-11 16:00:00	NVDA	Stock	0.3815	0.3818	0.3813	0.3818	928960.0
2013-10-11 19:00:00	NVDA	Stock	0.3813	0.3813	0.3813	0.3813	108000.0
2013-10-11 05:00:00	AMZN	Stock	15.2945	15.2945	15.2945	15.2945	2000.0
2013-10-11 06:00:00	AMZN	Stock	15.3195	15.3195	15.3195	15.3195	2000.0
2013-10-11 07:00:00	AMZN	Stock	15.3195	15.3195	15.315	15.315	4000.0
2013-10-11 08:00:00	AMZN	Stock	15.3345	15.3345	15.2	15.2	259900.0
2013-10-11 09:00:00	AMZN	Stock	15.2	15.481	15.192	15.471	9249720.0
2013-10-11 10:00:00	AMZN	Stock	15.465	15.5225	15.3875	15.45	11297380.0
2013-10-11 11:00:00	AMZN	Stock	15.4535	15.525	15.4	15.5105	2895620.0
2013-10-11 12:00:00	AMZN	Stock	15.507	15.524	15.4625	15.517	2828340.0
2013-10-11 13:00:00	AMZN	Stock	15.516	15.5465	15.485	15.522	2658460.0

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

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