PREVIEW / stock_1hour / 2011-08-25

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-08-25.parquet
  size:    923 KB
  rows:    44,819
  symbols: 3,490

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
2011-08-25 04:00:00	AAPL	Stock	12.7821	12.8393	12.75	12.7943	696584.0
2011-08-25 05:00:00	AAPL	Stock	12.7861	12.8268	12.7857	12.8125	600012.0
2011-08-25 06:00:00	AAPL	Stock	12.8218	12.9071	12.8214	12.8571	879928.0
2011-08-25 07:00:00	AAPL	Stock	12.8579	13.1379	12.8579	13.1136	15971228.0
2011-08-25 08:00:00	AAPL	Stock	13.0497	13.2457	13.0497	13.0657	40181988.0
2011-08-25 09:00:00	AAPL	Stock	13.0657	13.3296	13.0357	13.1996	224407092.0
2011-08-25 10:00:00	AAPL	Stock	13.1996	13.2911	13.1589	13.2086	141556044.0
2011-08-25 11:00:00	AAPL	Stock	13.2086	13.3179	13.1971	13.3143	81111156.0
2011-08-25 12:00:00	AAPL	Stock	13.3129	13.3443	13.2146	13.2525	74405716.0
2011-08-25 13:00:00	AAPL	Stock	13.2518	13.3104	13.2443	13.3104	45458532.0
2011-08-25 14:00:00	AAPL	Stock	13.31	13.4089	13.2821	13.3393	103615988.0
2011-08-25 15:00:00	AAPL	Stock	13.3393	13.4014	13.3043	13.3468	110854128.0
2011-08-25 16:00:00	AAPL	Stock	13.3464	13.3571	13.26	13.3464	25693388.0
2011-08-25 17:00:00	AAPL	Stock	13.345	13.3486	13.3296	13.3393	832720.0
2011-08-25 18:00:00	AAPL	Stock	13.3393	13.3571	13.3329	13.3536	359408.0
2011-08-25 19:00:00	AAPL	Stock	13.3471	13.3675	13.3318	13.3675	254016.0
2011-08-25 04:00:00	MSFT	Stock	25.03	25.03	24.9	24.9	600.0
2011-08-25 05:00:00	MSFT	Stock	24.92	24.92	24.92	24.92	200.0
2011-08-25 07:00:00	MSFT	Stock	24.95	24.99	24.95	24.95	4150.0
2011-08-25 08:00:00	MSFT	Stock	24.98	25.0	24.85	24.87	27622.0
2011-08-25 09:00:00	MSFT	Stock	24.88	25.16	24.79	25.03	5682251.0
2011-08-25 10:00:00	MSFT	Stock	25.03	25.04	24.62	24.64	8731629.0
2011-08-25 11:00:00	MSFT	Stock	24.64	24.835	24.64	24.772	5538423.0
2011-08-25 12:00:00	MSFT	Stock	24.77	24.795	24.51	24.62	5000267.0
2011-08-25 13:00:00	MSFT	Stock	24.62	24.7	24.58	24.67	5159584.0
2011-08-25 14:00:00	MSFT	Stock	24.67	24.695	24.54	24.54	4495565.0
2011-08-25 15:00:00	MSFT	Stock	24.54	24.67	24.5	24.58	10818673.0
2011-08-25 16:00:00	MSFT	Stock	24.58	25.07	24.53	24.53	2359014.0
2011-08-25 17:00:00	MSFT	Stock	24.57	24.58	24.55	24.58	181429.0
2011-08-25 19:00:00	MSFT	Stock	24.57	24.61	24.57	24.61	16095.0
2011-08-25 08:00:00	NVDA	Stock	0.32	0.3225	0.32	0.3225	42400.0
2011-08-25 09:00:00	NVDA	Stock	0.3213	0.3253	0.315	0.3208	108808720.0
2011-08-25 10:00:00	NVDA	Stock	0.3208	0.3238	0.315	0.3158	139771440.0
2011-08-25 11:00:00	NVDA	Stock	0.3158	0.3211	0.3158	0.3203	83667160.0
2011-08-25 12:00:00	NVDA	Stock	0.3203	0.3208	0.3158	0.317	58074160.0
2011-08-25 13:00:00	NVDA	Stock	0.3173	0.3195	0.316	0.3183	64999560.0
2011-08-25 14:00:00	NVDA	Stock	0.3181	0.3185	0.3125	0.3125	96262960.0
2011-08-25 15:00:00	NVDA	Stock	0.3125	0.3153	0.3115	0.3123	126337480.0
2011-08-25 16:00:00	NVDA	Stock	0.3125	0.3172	0.3118	0.312	4848240.0
2011-08-25 17:00:00	NVDA	Stock	0.3118	0.3123	0.3118	0.3118	647760.0
2011-08-25 18:00:00	NVDA	Stock	0.3133	0.3138	0.3123	0.3123	246520.0
2011-08-25 19:00:00	NVDA	Stock	0.312	0.313	0.312	0.313	229960.0
2011-08-25 04:00:00	AMZN	Stock	9.605	9.6835	9.605	9.65	14000.0
2011-08-25 07:00:00	AMZN	Stock	9.65	9.6935	9.65	9.688	20000.0
2011-08-25 08:00:00	AMZN	Stock	9.6565	9.7	9.65	9.669	113900.0
2011-08-25 09:00:00	AMZN	Stock	9.6215	9.8495	9.6205	9.6285	12116940.0
2011-08-25 10:00:00	AMZN	Stock	9.638	9.68	9.5535	9.5535	10939760.0
2011-08-25 11:00:00	AMZN	Stock	9.5542	9.685	9.5535	9.6849	8021040.0
2011-08-25 12:00:00	AMZN	Stock	9.6805	9.697	9.557	9.6035	5452700.0
2011-08-25 13:00:00	AMZN	Stock	9.605	9.6825	9.586	9.656	5752300.0

> showing 50 of 44,819 rows — these rows as CSV

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