PREVIEW / stock_1hour / 2013-07-30

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-30.parquet
  size:    1010 KB
  rows:    46,341
  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
2013-07-30 04:00:00	AAPL	Stock	16.0461	16.0536	16.0193	16.0193	11200.0
2013-07-30 06:00:00	AAPL	Stock	16.0289	16.0289	16.0289	16.0289	16968.0
2013-07-30 07:00:00	AAPL	Stock	16.0357	16.0893	16.0357	16.0679	570136.0
2013-07-30 08:00:00	AAPL	Stock	16.0643	16.0961	15.9643	16.0764	1844864.0
2013-07-30 09:00:00	AAPL	Stock	16.0768	16.1721	16.0439	16.1289	55873328.0
2013-07-30 10:00:00	AAPL	Stock	16.1307	16.2261	16.1132	16.2018	51205700.0
2013-07-30 11:00:00	AAPL	Stock	16.2007	16.3268	16.1807	16.3109	51896740.0
2013-07-30 12:00:00	AAPL	Stock	16.3118	16.3121	16.2325	16.2879	38389400.0
2013-07-30 13:00:00	AAPL	Stock	16.288	16.3036	16.1929	16.2071	29415736.0
2013-07-30 14:00:00	AAPL	Stock	16.2071	16.2673	16.19	16.2371	24661588.0
2013-07-30 15:00:00	AAPL	Stock	16.2361	16.2657	16.1804	16.19	40410160.0
2013-07-30 16:00:00	AAPL	Stock	16.19	16.3068	15.9695	16.2018	10576636.0
2013-07-30 17:00:00	AAPL	Stock	16.19	16.2036	16.19	16.2036	157780.0
2013-07-30 18:00:00	AAPL	Stock	16.2032	16.2143	16.19	16.2057	307888.0
2013-07-30 19:00:00	AAPL	Stock	16.1986	16.2068	16.1986	16.2	84644.0
2013-07-30 06:00:00	MSFT	Stock	31.55	31.55	31.55	31.55	1000.0
2013-07-30 07:00:00	MSFT	Stock	31.62	31.71	31.62	31.68	5687.0
2013-07-30 08:00:00	MSFT	Stock	31.59	31.7	31.59	31.68	10775.0
2013-07-30 09:00:00	MSFT	Stock	31.64	31.79	31.55	31.56	3699160.0
2013-07-30 10:00:00	MSFT	Stock	31.56	31.75	31.56	31.72	6413661.0
2013-07-30 11:00:00	MSFT	Stock	31.715	32.12	31.705	32.025	9877338.0
2013-07-30 12:00:00	MSFT	Stock	32.025	32.03	31.83	31.84	5154744.0
2013-07-30 13:00:00	MSFT	Stock	31.846	31.9	31.66	31.71	3716388.0
2013-07-30 14:00:00	MSFT	Stock	31.71	31.78	31.69	31.74	4333493.0
2013-07-30 15:00:00	MSFT	Stock	31.73	31.9	31.71	31.865	8120916.0
2013-07-30 16:00:00	MSFT	Stock	31.85	32.0	31.747	31.86	2860513.0
2013-07-30 17:00:00	MSFT	Stock	31.85	31.85	31.85	31.85	7294.0
2013-07-30 18:00:00	MSFT	Stock	31.88	31.88	31.8	31.8	1580.0
2013-07-30 19:00:00	MSFT	Stock	31.87	31.87	31.87	31.87	100.0
2013-07-30 08:00:00	NVDA	Stock	0.3515	0.3515	0.3515	0.3515	4000.0
2013-07-30 09:00:00	NVDA	Stock	0.3553	0.3588	0.3548	0.3582	25280000.0
2013-07-30 10:00:00	NVDA	Stock	0.3582	0.3624	0.3582	0.3611	42870320.0
2013-07-30 11:00:00	NVDA	Stock	0.3612	0.365	0.3608	0.3628	35791200.0
2013-07-30 12:00:00	NVDA	Stock	0.3629	0.364	0.3618	0.3632	27680280.0
2013-07-30 13:00:00	NVDA	Stock	0.3632	0.3635	0.3598	0.3605	28832080.0
2013-07-30 14:00:00	NVDA	Stock	0.3602	0.362	0.3592	0.3609	35708800.0
2013-07-30 15:00:00	NVDA	Stock	0.361	0.3618	0.3598	0.3602	59101040.0
2013-07-30 16:00:00	NVDA	Stock	0.3602	0.3612	0.359	0.3612	10635720.0
2013-07-30 18:00:00	NVDA	Stock	0.36	0.36	0.36	0.36	40000.0
2013-07-30 07:00:00	AMZN	Stock	15.3895	15.3895	15.3895	15.3895	2000.0
2013-07-30 08:00:00	AMZN	Stock	15.3875	15.4465	15.305	15.405	285680.0
2013-07-30 09:00:00	AMZN	Stock	15.4085	15.4295	15.1835	15.269	11911540.0
2013-07-30 10:00:00	AMZN	Stock	15.27	15.2905	15.157	15.1821	10802400.0
2013-07-30 11:00:00	AMZN	Stock	15.1865	15.325	15.183	15.305	7670360.0
2013-07-30 12:00:00	AMZN	Stock	15.314	15.317	15.2075	15.2375	3775600.0
2013-07-30 13:00:00	AMZN	Stock	15.238	15.4892	15.102	15.11	7611180.0
2013-07-30 14:00:00	AMZN	Stock	15.107	15.1235	15.0785	15.088	6185920.0
2013-07-30 15:00:00	AMZN	Stock	15.0863	15.1353	15.083	15.1205	9567100.0
2013-07-30 16:00:00	AMZN	Stock	15.1205	15.305	15.1072	15.1117	2717460.0
2013-07-30 17:00:00	AMZN	Stock	15.125	15.14	15.125	15.14	13620.0

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

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