PREVIEW / stock_1hour / 2013-03-04

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-04.parquet
  size:    969 KB
  rows:    45,248
  symbols: 3,497

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-03-04 04:00:00	AAPL	Stock	15.3929	15.3929	15.2857	15.3393	101640.0
2013-03-04 05:00:00	AAPL	Stock	15.35	15.3571	15.3357	15.3571	19600.0
2013-03-04 06:00:00	AAPL	Stock	15.3518	15.3518	15.3214	15.3214	59864.0
2013-03-04 07:00:00	AAPL	Stock	15.3118	15.3357	15.2857	15.3286	768124.0
2013-03-04 08:00:00	AAPL	Stock	15.3393	15.3811	15.2857	15.2939	2966544.0
2013-03-04 09:00:00	AAPL	Stock	15.2971	15.3296	15.1893	15.2168	91870548.0
2013-03-04 10:00:00	AAPL	Stock	15.2161	15.2754	15.0939	15.126	107715384.0
2013-03-04 11:00:00	AAPL	Stock	15.1296	15.1871	15.0754	15.0996	66607464.0
2013-03-04 12:00:00	AAPL	Stock	15.1014	15.1371	15.0471	15.1043	54605600.0
2013-03-04 13:00:00	AAPL	Stock	15.1036	15.1746	15.0764	15.107	50632204.0
2013-03-04 14:00:00	AAPL	Stock	15.1054	15.1379	15.0411	15.1221	55992188.0
2013-03-04 15:00:00	AAPL	Stock	15.1182	15.1275	14.9643	15.0004	120201116.0
2013-03-04 16:00:00	AAPL	Stock	14.9966	15.1308	14.9779	14.9971	10127852.0
2013-03-04 17:00:00	AAPL	Stock	14.9964	15.0018	14.9789	14.9918	1117480.0
2013-03-04 18:00:00	AAPL	Stock	14.9921	14.9961	14.9896	14.995	256424.0
2013-03-04 19:00:00	AAPL	Stock	14.995	14.9957	14.94	14.9518	855708.0
2013-03-04 05:00:00	MSFT	Stock	27.8	27.8	27.8	27.8	300.0
2013-03-04 07:00:00	MSFT	Stock	27.82	27.87	27.82	27.87	1800.0
2013-03-04 08:00:00	MSFT	Stock	27.87	27.92	27.82	27.82	20035.0
2013-03-04 09:00:00	MSFT	Stock	27.84	27.91	27.72	27.72	3749405.0
2013-03-04 10:00:00	MSFT	Stock	27.72	27.829	27.7	27.8	4290675.0
2013-03-04 11:00:00	MSFT	Stock	27.8	27.89	27.77	27.87	3494776.0
2013-03-04 12:00:00	MSFT	Stock	27.87	27.89	27.755	27.785	2787172.0
2013-03-04 13:00:00	MSFT	Stock	27.78	27.88	27.76	27.85	2905875.0
2013-03-04 14:00:00	MSFT	Stock	27.84	28.03	27.83	28.03	6219238.0
2013-03-04 15:00:00	MSFT	Stock	28.028	28.15	28.01	28.135	10642329.0
2013-03-04 16:00:00	MSFT	Stock	28.15	28.17	27.898	28.14	3128737.0
2013-03-04 17:00:00	MSFT	Stock	28.13	28.15	27.774	28.13	12501.0
2013-03-04 18:00:00	MSFT	Stock	28.13	28.15	28.13	28.15	2748.0
2013-03-04 19:00:00	MSFT	Stock	28.14	28.15	28.14	28.15	1200.0
2013-03-04 09:00:00	NVDA	Stock	0.3163	0.3175	0.3154	0.3168	33816240.0
2013-03-04 10:00:00	NVDA	Stock	0.3168	0.3193	0.3168	0.3191	74477320.0
2013-03-04 11:00:00	NVDA	Stock	0.319	0.3194	0.3173	0.3173	49537480.0
2013-03-04 12:00:00	NVDA	Stock	0.3173	0.3175	0.313	0.3143	39304800.0
2013-03-04 13:00:00	NVDA	Stock	0.3143	0.3159	0.314	0.3148	59659160.0
2013-03-04 14:00:00	NVDA	Stock	0.3148	0.3163	0.3138	0.3159	31799880.0
2013-03-04 15:00:00	NVDA	Stock	0.3158	0.3168	0.3155	0.3164	51397600.0
2013-03-04 16:00:00	NVDA	Stock	0.316	0.3173	0.3156	0.3163	2985080.0
2013-03-04 17:00:00	NVDA	Stock	0.3163	0.3163	0.3163	0.3163	6600.0
2013-03-04 18:00:00	NVDA	Stock	0.3163	0.3163	0.3163	0.3163	12000.0
2013-03-04 05:00:00	AMZN	Stock	13.1845	13.1845	13.1845	13.1845	2000.0
2013-03-04 07:00:00	AMZN	Stock	13.244	13.246	13.244	13.246	4000.0
2013-03-04 08:00:00	AMZN	Stock	13.213	13.2535	13.213	13.24	105460.0
2013-03-04 09:00:00	AMZN	Stock	13.2375	13.443	13.207	13.4425	9553760.0
2013-03-04 10:00:00	AMZN	Stock	13.443	13.4875	13.364	13.4875	9963420.0
2013-03-04 11:00:00	AMZN	Stock	13.487	13.4905	13.4305	13.4555	6955880.0
2013-03-04 12:00:00	AMZN	Stock	13.4585	13.4869	13.4165	13.473	6758620.0
2013-03-04 13:00:00	AMZN	Stock	13.473	13.5365	13.4385	13.518	4805480.0
2013-03-04 14:00:00	AMZN	Stock	13.5175	13.646	13.4915	13.6195	8419080.0
2013-03-04 15:00:00	AMZN	Stock	13.6175	13.665	13.572	13.6585	12628840.0

> showing 50 of 45,248 rows — these rows as CSV

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