PREVIEW / stock_1hour / 2017-02-27

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-27.parquet
  size:    1.1 MB
  rows:    49,303
  symbols: 3,107

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
2017-02-27 04:00:00	AAPL	Stock	34.125	34.125	34.125	34.125	800.0
2017-02-27 06:00:00	AAPL	Stock	34.1525	34.3225	34.15	34.3125	106184.0
2017-02-27 07:00:00	AAPL	Stock	34.3125	34.325	34.215	34.25	204784.0
2017-02-27 08:00:00	AAPL	Stock	34.25	34.3125	34.2125	34.2475	317392.0
2017-02-27 09:00:00	AAPL	Stock	34.25	34.325	34.07	34.27	17640408.0
2017-02-27 10:00:00	AAPL	Stock	34.2725	34.3588	34.225	34.26	13612668.0
2017-02-27 11:00:00	AAPL	Stock	34.2622	34.2925	34.1925	34.25	8890564.0
2017-02-27 12:00:00	AAPL	Stock	34.2518	34.275	34.2262	34.2463	4539168.0
2017-02-27 13:00:00	AAPL	Stock	34.2463	34.31	34.245	34.265	4906072.0
2017-02-27 14:00:00	AAPL	Stock	34.265	34.28	34.2325	34.2425	4402852.0
2017-02-27 15:00:00	AAPL	Stock	34.2425	34.275	34.2025	34.235	9471760.0
2017-02-27 16:00:00	AAPL	Stock	34.24	34.24	34.19	34.19	8757280.0
2017-02-27 17:00:00	AAPL	Stock	34.19	34.23	34.1875	34.2075	44224.0
2017-02-27 18:00:00	AAPL	Stock	34.2075	34.2275	34.175	34.175	29088.0
2017-02-27 19:00:00	AAPL	Stock	34.2225	34.2225	34.18	34.18	73660.0
2017-02-27 08:00:00	MSFT	Stock	64.51	64.57	64.51	64.57	558.0
2017-02-27 09:00:00	MSFT	Stock	64.51	64.54	64.045	64.185	2627544.0
2017-02-27 10:00:00	MSFT	Stock	64.19	64.24	64.06	64.125	2543192.0
2017-02-27 11:00:00	MSFT	Stock	64.13	64.21	64.05	64.08	1325178.0
2017-02-27 12:00:00	MSFT	Stock	64.075	64.12	64.055	64.09	1055450.0
2017-02-27 13:00:00	MSFT	Stock	64.09	64.19	64.08	64.19	1189951.0
2017-02-27 14:00:00	MSFT	Stock	64.18	64.2	64.09	64.17	1262641.0
2017-02-27 15:00:00	MSFT	Stock	64.165	64.3	64.16	64.22	3539662.0
2017-02-27 16:00:00	MSFT	Stock	64.23	64.25	64.19	64.22	1208653.0
2017-02-27 17:00:00	MSFT	Stock	64.22	64.22	64.22	64.22	160.0
2017-02-27 18:00:00	MSFT	Stock	64.21	64.22	64.17	64.17	350.0
2017-02-27 19:00:00	MSFT	Stock	64.22	64.22	64.17	64.22	450.0
2017-02-27 04:00:00	NVDA	Stock	2.547	2.547	2.5462	2.5462	36080.0
2017-02-27 05:00:00	NVDA	Stock	2.5392	2.5433	2.5392	2.543	84240.0
2017-02-27 06:00:00	NVDA	Stock	2.5453	2.55	2.5428	2.5438	227240.0
2017-02-27 07:00:00	NVDA	Stock	2.5438	2.5622	2.5438	2.5563	411200.0
2017-02-27 08:00:00	NVDA	Stock	2.5585	2.562	2.5288	2.5533	2758040.0
2017-02-27 09:00:00	NVDA	Stock	2.553	2.6112	2.539	2.608	206723520.0
2017-02-27 10:00:00	NVDA	Stock	2.6082	2.6245	2.5935	2.6108	144071320.0
2017-02-27 11:00:00	NVDA	Stock	2.611	2.62	2.6052	2.6074	54091760.0
2017-02-27 12:00:00	NVDA	Stock	2.6073	2.625	2.6055	2.6192	58874560.0
2017-02-27 13:00:00	NVDA	Stock	2.6198	2.6248	2.6105	2.6105	39464040.0
2017-02-27 14:00:00	NVDA	Stock	2.611	2.6255	2.6105	2.6169	44443880.0
2017-02-27 15:00:00	NVDA	Stock	2.6168	2.6168	2.6075	2.6102	107439760.0
2017-02-27 16:00:00	NVDA	Stock	2.6102	2.6118	2.6075	2.6075	20562800.0
2017-02-27 17:00:00	NVDA	Stock	2.6088	2.6115	2.6075	2.6105	253680.0
2017-02-27 18:00:00	NVDA	Stock	2.6085	2.615	2.6085	2.6112	114000.0
2017-02-27 19:00:00	NVDA	Stock	2.6122	2.6138	2.611	2.6125	178760.0
2017-02-27 07:00:00	AMZN	Stock	42.373	42.373	42.346	42.346	36960.0
2017-02-27 08:00:00	AMZN	Stock	42.35	42.35	42.24	42.275	161760.0
2017-02-27 09:00:00	AMZN	Stock	42.275	42.2805	41.9835	42.2205	10103800.0
2017-02-27 10:00:00	AMZN	Stock	42.225	42.4325	42.1855	42.384	7521700.0
2017-02-27 11:00:00	AMZN	Stock	42.387	42.5305	42.3845	42.4942	6144080.0
2017-02-27 12:00:00	AMZN	Stock	42.4885	42.575	42.4645	42.5275	4083460.0
2017-02-27 13:00:00	AMZN	Stock	42.536	42.625	42.5208	42.5325	4682820.0

> showing 50 of 49,303 rows — these rows as CSV

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