PREVIEW / stock_1hour / 2013-08-01

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-08-01.parquet
  size:    1.0 MB
  rows:    47,250
  symbols: 3,540

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-08-01 04:00:00	AAPL	Stock	16.1786	16.1786	16.1786	16.1786	2800.0
2013-08-01 05:00:00	AAPL	Stock	16.2196	16.25	16.2196	16.25	5600.0
2013-08-01 06:00:00	AAPL	Stock	16.25	16.25	16.25	16.25	2800.0
2013-08-01 07:00:00	AAPL	Stock	16.25	16.3607	16.2411	16.3207	461888.0
2013-08-01 08:00:00	AAPL	Stock	16.3214	16.3214	16.1429	16.29	2123576.0
2013-08-01 09:00:00	AAPL	Stock	16.2904	16.3143	16.1879	16.2321	42520772.0
2013-08-01 10:00:00	AAPL	Stock	16.2321	16.3018	16.225	16.2821	42198212.0
2013-08-01 11:00:00	AAPL	Stock	16.2789	16.2964	16.2432	16.2762	23071916.0
2013-08-01 12:00:00	AAPL	Stock	16.2761	16.2835	16.2439	16.2511	13819064.0
2013-08-01 13:00:00	AAPL	Stock	16.2507	16.2768	16.2418	16.2636	10346252.0
2013-08-01 14:00:00	AAPL	Stock	16.2582	16.2757	16.2518	16.2643	14198380.0
2013-08-01 15:00:00	AAPL	Stock	16.2646	16.3132	16.2275	16.3125	44936612.0
2013-08-01 16:00:00	AAPL	Stock	16.3129	16.3329	16.2666	16.3321	9322964.0
2013-08-01 17:00:00	AAPL	Stock	16.3389	16.3464	16.3129	16.3396	492688.0
2013-08-01 18:00:00	AAPL	Stock	16.3404	16.3446	16.3339	16.3411	259420.0
2013-08-01 19:00:00	AAPL	Stock	16.3339	16.3421	16.3286	16.3421	147140.0
2013-08-01 06:00:00	MSFT	Stock	31.95	31.95	31.95	31.95	300.0
2013-08-01 07:00:00	MSFT	Stock	32.0	32.03	31.94	31.94	725.0
2013-08-01 08:00:00	MSFT	Stock	31.93	32.02	31.93	32.01	15619.0
2013-08-01 09:00:00	MSFT	Stock	32.0	32.13	31.84	31.91	3930518.0
2013-08-01 10:00:00	MSFT	Stock	31.91	32.01	31.75	31.75	5445233.0
2013-08-01 11:00:00	MSFT	Stock	31.755	31.84	31.7	31.79	5524034.0
2013-08-01 12:00:00	MSFT	Stock	31.785	31.8	31.68	31.69	3400095.0
2013-08-01 13:00:00	MSFT	Stock	31.69	31.73	31.6	31.67	4955467.0
2013-08-01 14:00:00	MSFT	Stock	31.66	31.73	31.65	31.68	4088406.0
2013-08-01 15:00:00	MSFT	Stock	31.67	31.79	31.6	31.68	10938411.0
2013-08-01 16:00:00	MSFT	Stock	31.68	31.776	31.63	31.68	2795634.0
2013-08-01 17:00:00	MSFT	Stock	31.69	31.7	31.69	31.7	57664.0
2013-08-01 18:00:00	MSFT	Stock	31.7	31.71	31.64	31.65	4486.0
2013-08-01 19:00:00	MSFT	Stock	31.7	31.7	31.69	31.69	919.0
2013-08-01 09:00:00	NVDA	Stock	0.3622	0.364	0.358	0.3585	30769160.0
2013-08-01 10:00:00	NVDA	Stock	0.3588	0.3612	0.3586	0.3612	40019000.0
2013-08-01 11:00:00	NVDA	Stock	0.3612	0.3632	0.361	0.3622	45108000.0
2013-08-01 12:00:00	NVDA	Stock	0.3622	0.3644	0.3622	0.3639	32716240.0
2013-08-01 13:00:00	NVDA	Stock	0.364	0.3645	0.3628	0.3632	18162880.0
2013-08-01 14:00:00	NVDA	Stock	0.3632	0.3645	0.363	0.3644	19708120.0
2013-08-01 15:00:00	NVDA	Stock	0.3645	0.3668	0.3638	0.3658	72942920.0
2013-08-01 16:00:00	NVDA	Stock	0.366	0.3662	0.3649	0.3658	2507560.0
2013-08-01 17:00:00	NVDA	Stock	0.366	0.366	0.366	0.366	131640.0
2013-08-01 18:00:00	NVDA	Stock	0.3632	0.3632	0.3632	0.3632	12000.0
2013-08-01 07:00:00	AMZN	Stock	15.171	15.195	15.171	15.195	13400.0
2013-08-01 08:00:00	AMZN	Stock	15.061	15.217	15.061	15.1785	74180.0
2013-08-01 09:00:00	AMZN	Stock	15.1875	15.25	14.995	15.0695	14705600.0
2013-08-01 10:00:00	AMZN	Stock	15.066	15.0745	14.964	14.981	9642960.0
2013-08-01 11:00:00	AMZN	Stock	14.9795	15.0075	14.9452	14.9975	6821520.0
2013-08-01 12:00:00	AMZN	Stock	14.9955	15.075	14.9882	15.036	3235240.0
2013-08-01 13:00:00	AMZN	Stock	15.0365	15.1745	15.0355	15.17	4446020.0
2013-08-01 14:00:00	AMZN	Stock	15.17	15.22	15.1675	15.2145	4881220.0
2013-08-01 15:00:00	AMZN	Stock	15.213	15.3105	15.2126	15.2725	12569660.0
2013-08-01 16:00:00	AMZN	Stock	15.277	15.3	15.236	15.2935	2559460.0

> showing 50 of 47,250 rows — these rows as CSV

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