PREVIEW / stock_1hour / 2017-07-27

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-07-27.parquet
  size:    1.1 MB
  rows:    47,979
  symbols: 3,001

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-07-27 04:00:00	AAPL	Stock	38.4975	38.55	38.4975	38.55	17560.0
2017-07-27 05:00:00	AAPL	Stock	38.555	38.555	38.5375	38.5375	1480.0
2017-07-27 06:00:00	AAPL	Stock	38.5125	38.535	38.5	38.535	16508.0
2017-07-27 07:00:00	AAPL	Stock	38.505	38.53	38.485	38.5025	68076.0
2017-07-27 08:00:00	AAPL	Stock	38.5125	38.57	38.5	38.555	271780.0
2017-07-27 09:00:00	AAPL	Stock	38.5575	38.5975	38.2275	38.2522	12707060.0
2017-07-27 10:00:00	AAPL	Stock	38.2562	38.4712	38.2425	38.3825	9586732.0
2017-07-27 11:00:00	AAPL	Stock	38.385	38.395	38.2825	38.33	6866880.0
2017-07-27 12:00:00	AAPL	Stock	38.3275	38.3462	37.59	37.69	13969944.0
2017-07-27 13:00:00	AAPL	Stock	37.69	37.8222	36.825	37.3888	34275548.0
2017-07-27 14:00:00	AAPL	Stock	37.39	37.5175	37.2725	37.505	14491584.0
2017-07-27 15:00:00	AAPL	Stock	37.505	37.6575	37.3875	37.6375	18524448.0
2017-07-27 16:00:00	AAPL	Stock	37.64	37.64	37.55	37.6075	8703240.0
2017-07-27 17:00:00	AAPL	Stock	37.6025	37.64	37.5625	37.57	142472.0
2017-07-27 18:00:00	AAPL	Stock	37.6	37.6	37.46	37.5025	67252.0
2017-07-27 19:00:00	AAPL	Stock	37.5125	37.5375	37.4975	37.5	25884.0
2017-07-27 04:00:00	MSFT	Stock	74.12	74.22	74.12	74.21	1128.0
2017-07-27 06:00:00	MSFT	Stock	74.2	74.2	74.2	74.2	600.0
2017-07-27 07:00:00	MSFT	Stock	74.2	74.2	73.89	73.9	17714.0
2017-07-27 08:00:00	MSFT	Stock	73.9	73.9	73.7	73.73	42948.0
2017-07-27 09:00:00	MSFT	Stock	73.75	74.13	73.53	74.016	3252183.0
2017-07-27 10:00:00	MSFT	Stock	74.014	74.22	73.965	74.17	2446942.0
2017-07-27 11:00:00	MSFT	Stock	74.17	74.42	74.02	74.22	2282023.0
2017-07-27 12:00:00	MSFT	Stock	74.215	74.22	73.38	73.58	3581725.0
2017-07-27 13:00:00	MSFT	Stock	73.58	73.64	72.51	72.735	5435520.0
2017-07-27 14:00:00	MSFT	Stock	72.74	72.91	72.32	72.76	4674874.0
2017-07-27 15:00:00	MSFT	Stock	72.76	73.205	72.548	73.15	5597856.0
2017-07-27 16:00:00	MSFT	Stock	73.16	73.25	72.87	72.95	4327300.0
2017-07-27 17:00:00	MSFT	Stock	73.0	73.05	73.0	73.05	3030.0
2017-07-27 18:00:00	MSFT	Stock	73.0	73.16	72.99	72.99	1036643.0
2017-07-27 19:00:00	MSFT	Stock	73.1	73.1	73.1	73.1	970.0
2017-07-27 04:00:00	NVDA	Stock	4.205	4.2138	4.2048	4.2075	159320.0
2017-07-27 05:00:00	NVDA	Stock	4.2092	4.2092	4.2092	4.2092	10080.0
2017-07-27 06:00:00	NVDA	Stock	4.2002	4.2125	4.2002	4.2075	126120.0
2017-07-27 07:00:00	NVDA	Stock	4.2075	4.2075	4.1875	4.195	198280.0
2017-07-27 08:00:00	NVDA	Stock	4.1983	4.2058	4.1875	4.2	1651600.0
2017-07-27 09:00:00	NVDA	Stock	4.2	4.2185	4.166	4.166	63872320.0
2017-07-27 10:00:00	NVDA	Stock	4.1665	4.1788	4.1452	4.1575	78167480.0
2017-07-27 11:00:00	NVDA	Stock	4.1578	4.1578	4.1365	4.1443	61693440.0
2017-07-27 12:00:00	NVDA	Stock	4.1432	4.1443	4.0277	4.0404	131251600.0
2017-07-27 13:00:00	NVDA	Stock	4.0397	4.0572	3.939	4.0136	209492040.0
2017-07-27 14:00:00	NVDA	Stock	4.0162	4.05	4.0022	4.0413	84987880.0
2017-07-27 15:00:00	NVDA	Stock	4.0395	4.0475	4.0162	4.0435	78880720.0
2017-07-27 16:00:00	NVDA	Stock	4.0435	4.0735	4.0158	4.0378	3875800.0
2017-07-27 17:00:00	NVDA	Stock	4.0425	4.0435	4.035	4.0388	1373680.0
2017-07-27 18:00:00	NVDA	Stock	4.041	4.0435	4.0262	4.0375	18895360.0
2017-07-27 19:00:00	NVDA	Stock	4.037	4.037	4.025	4.025	556480.0
2017-07-27 04:00:00	AMZN	Stock	53.1	53.1	53.0705	53.0705	16900.0
2017-07-27 06:00:00	AMZN	Stock	53.1005	53.1005	53.1	53.1	7760.0
2017-07-27 07:00:00	AMZN	Stock	53.1005	53.3	53.0495	53.22	109020.0

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

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