PREVIEW / stock_1hour / 2011-02-07

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-07.parquet
  size:    953 KB
  rows:    45,875
  symbols: 3,537

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-02-07 04:00:00	AAPL	Stock	12.3929	12.49	12.3929	12.4736	55720.0
2011-02-07 05:00:00	AAPL	Stock	12.4714	12.4714	12.4546	12.4575	19600.0
2011-02-07 06:00:00	AAPL	Stock	12.4554	12.4554	12.4321	12.4421	36400.0
2011-02-07 07:00:00	AAPL	Stock	12.4429	12.4464	12.4111	12.4214	312060.0
2011-02-07 08:00:00	AAPL	Stock	12.425	12.4589	12.4143	12.45	3519432.0
2011-02-07 09:00:00	AAPL	Stock	12.4496	12.4986	12.4154	12.4982	75417832.0
2011-02-07 10:00:00	AAPL	Stock	12.4982	12.5714	12.495	12.5507	102880512.0
2011-02-07 11:00:00	AAPL	Stock	12.5521	12.6132	12.5511	12.5925	70442512.0
2011-02-07 12:00:00	AAPL	Stock	12.5915	12.6161	12.5779	12.6	40084996.0
2011-02-07 13:00:00	AAPL	Stock	12.6007	12.6139	12.5957	12.6039	24335164.0
2011-02-07 14:00:00	AAPL	Stock	12.6039	12.6089	12.5311	12.5457	46334428.0
2011-02-07 15:00:00	AAPL	Stock	12.5454	12.5729	12.515	12.5668	74871132.0
2011-02-07 16:00:00	AAPL	Stock	12.5671	12.5807	12.4234	12.5646	39398912.0
2011-02-07 17:00:00	AAPL	Stock	12.5657	12.5714	12.5657	12.5711	176120.0
2011-02-07 18:00:00	AAPL	Stock	12.5711	12.575	12.5671	12.5682	333900.0
2011-02-07 19:00:00	AAPL	Stock	12.5696	12.5821	12.5689	12.5804	418852.0
2011-02-07 05:00:00	MSFT	Stock	27.84	27.85	27.84	27.85	800.0
2011-02-07 07:00:00	MSFT	Stock	27.85	27.93	27.85	27.87	5120.0
2011-02-07 08:00:00	MSFT	Stock	27.87	27.9	27.77	27.87	32896.0
2011-02-07 09:00:00	MSFT	Stock	27.87	28.16	27.79	28.16	8489911.0
2011-02-07 10:00:00	MSFT	Stock	28.16	28.23	28.08	28.2	10261318.0
2011-02-07 11:00:00	MSFT	Stock	28.195	28.25	28.15	28.24	10312389.0
2011-02-07 12:00:00	MSFT	Stock	28.23	28.34	28.18	28.243	7742903.0
2011-02-07 13:00:00	MSFT	Stock	28.24	28.32	28.21	28.255	6782777.0
2011-02-07 14:00:00	MSFT	Stock	28.26	28.27	28.18	28.225	5228215.0
2011-02-07 15:00:00	MSFT	Stock	28.235	28.3	28.19	28.19	15909816.0
2011-02-07 16:00:00	MSFT	Stock	28.19	28.27	28.14	28.25	2764488.0
2011-02-07 17:00:00	MSFT	Stock	28.14	28.24	28.14	28.18	20980.0
2011-02-07 18:00:00	MSFT	Stock	28.18	28.2	28.13	28.17	19143.0
2011-02-07 19:00:00	MSFT	Stock	28.17	28.17	28.16	28.16	11200.0
2011-02-07 07:00:00	NVDA	Stock	0.6408	0.6408	0.619	0.627	892000.0
2011-02-07 08:00:00	NVDA	Stock	0.627	0.637	0.627	0.635	2922960.0
2011-02-07 09:00:00	NVDA	Stock	0.6362	0.6375	0.6195	0.625	169433400.0
2011-02-07 10:00:00	NVDA	Stock	0.625	0.6275	0.6205	0.6229	153058120.0
2011-02-07 11:00:00	NVDA	Stock	0.623	0.6242	0.6213	0.6225	76490720.0
2011-02-07 12:00:00	NVDA	Stock	0.6225	0.625	0.621	0.6233	60549240.0
2011-02-07 13:00:00	NVDA	Stock	0.6231	0.6248	0.6215	0.6229	75844640.0
2011-02-07 14:00:00	NVDA	Stock	0.623	0.6239	0.6158	0.6171	119126200.0
2011-02-07 15:00:00	NVDA	Stock	0.6173	0.6195	0.6128	0.6153	264377320.0
2011-02-07 16:00:00	NVDA	Stock	0.6155	0.6263	0.615	0.616	8687320.0
2011-02-07 17:00:00	NVDA	Stock	0.616	0.6185	0.615	0.6185	614800.0
2011-02-07 18:00:00	NVDA	Stock	0.6165	0.619	0.6165	0.6168	280600.0
2011-02-07 19:00:00	NVDA	Stock	0.6175	0.6193	0.6153	0.6153	401400.0
2011-02-07 07:00:00	AMZN	Stock	8.835	8.835	8.835	8.835	3000.0
2011-02-07 08:00:00	AMZN	Stock	8.807	8.835	8.797	8.8275	107680.0
2011-02-07 09:00:00	AMZN	Stock	8.8275	8.83	8.7385	8.7739	11947600.0
2011-02-07 10:00:00	AMZN	Stock	8.775	8.8322	8.759	8.826	15056460.0
2011-02-07 11:00:00	AMZN	Stock	8.8245	8.8615	8.808	8.8185	11537140.0
2011-02-07 12:00:00	AMZN	Stock	8.8195	8.85	8.81	8.838	13585560.0
2011-02-07 13:00:00	AMZN	Stock	8.835	8.8575	8.8305	8.8515	17437080.0

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

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