PREVIEW / stock_1hour / 2017-09-12

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-09-12.parquet
  size:    1.0 MB
  rows:    48,284
  symbols: 2,973

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-09-12 04:00:00	AAPL	Stock	40.6125	40.645	40.5525	40.625	6448.0
2017-09-12 05:00:00	AAPL	Stock	40.625	40.8675	40.625	40.825	33916.0
2017-09-12 06:00:00	AAPL	Stock	40.85	40.87	40.7125	40.725	156104.0
2017-09-12 07:00:00	AAPL	Stock	40.715	40.85	40.68	40.75	434376.0
2017-09-12 08:00:00	AAPL	Stock	40.7525	40.8475	40.375	40.6875	1060112.0
2017-09-12 09:00:00	AAPL	Stock	40.6875	40.72	40.0975	40.1875	26359568.0
2017-09-12 10:00:00	AAPL	Stock	40.1838	40.305	40.0775	40.2425	19335488.0
2017-09-12 11:00:00	AAPL	Stock	40.2408	40.4175	40.2175	40.2575	12871572.0
2017-09-12 12:00:00	AAPL	Stock	40.26	40.3625	40.165	40.2925	11333156.0
2017-09-12 13:00:00	AAPL	Stock	40.2925	40.99	40.2875	40.7075	57184864.0
2017-09-12 14:00:00	AAPL	Stock	40.7105	40.9175	39.8675	39.8875	78943448.0
2017-09-12 15:00:00	AAPL	Stock	39.8875	40.25	39.6925	40.2125	47434616.0
2017-09-12 16:00:00	AAPL	Stock	40.2125	40.2425	40.1875	40.2125	6478300.0
2017-09-12 17:00:00	AAPL	Stock	40.21	40.225	40.1	40.1125	247284.0
2017-09-12 18:00:00	AAPL	Stock	40.125	40.1975	40.125	40.1875	83012.0
2017-09-12 19:00:00	AAPL	Stock	40.2	40.245	40.19	40.245	261948.0
2017-09-12 06:00:00	MSFT	Stock	75.0	75.0	75.0	75.0	100.0
2017-09-12 07:00:00	MSFT	Stock	74.97	74.97	74.97	74.97	100.0
2017-09-12 08:00:00	MSFT	Stock	74.96	74.96	74.76	74.76	3221.0
2017-09-12 09:00:00	MSFT	Stock	74.92	75.24	74.72	74.92	2361876.0
2017-09-12 10:00:00	MSFT	Stock	74.91	74.93	74.46	74.6	1765530.0
2017-09-12 11:00:00	MSFT	Stock	74.59	74.79	74.54	74.59	1352360.0
2017-09-12 12:00:00	MSFT	Stock	74.59	74.65	74.46	74.555	912940.0
2017-09-12 13:00:00	MSFT	Stock	74.55	74.59	74.44	74.499	809271.0
2017-09-12 14:00:00	MSFT	Stock	74.5	74.61	74.37	74.51	1178716.0
2017-09-12 15:00:00	MSFT	Stock	74.51	74.68	74.48	74.67	2681131.0
2017-09-12 16:00:00	MSFT	Stock	74.68	74.74	74.63	74.66	1862528.0
2017-09-12 17:00:00	MSFT	Stock	74.64	74.68	74.64	74.68	550.0
2017-09-12 18:00:00	MSFT	Stock	74.67	74.68	74.64	74.68	1005.0
2017-09-12 19:00:00	MSFT	Stock	74.68	74.68	74.68	74.68	1709.0
2017-09-12 06:00:00	NVDA	Stock	4.2462	4.255	4.2462	4.2475	94440.0
2017-09-12 07:00:00	NVDA	Stock	4.2488	4.2548	4.245	4.2545	222160.0
2017-09-12 08:00:00	NVDA	Stock	4.225	4.2572	4.225	4.242	1510280.0
2017-09-12 09:00:00	NVDA	Stock	4.245	4.2513	4.1962	4.2138	87916080.0
2017-09-12 10:00:00	NVDA	Stock	4.213	4.2195	4.1882	4.1946	65370560.0
2017-09-12 11:00:00	NVDA	Stock	4.1942	4.2048	4.189	4.1899	36935920.0
2017-09-12 12:00:00	NVDA	Stock	4.1906	4.198	4.1742	4.193	45975400.0
2017-09-12 13:00:00	NVDA	Stock	4.193	4.2118	4.1905	4.1962	31984680.0
2017-09-12 14:00:00	NVDA	Stock	4.1964	4.2075	4.1868	4.199	39006640.0
2017-09-12 15:00:00	NVDA	Stock	4.199	4.2412	4.1923	4.2403	79595640.0
2017-09-12 16:00:00	NVDA	Stock	4.2395	4.2403	4.23	4.2318	2788480.0
2017-09-12 17:00:00	NVDA	Stock	4.2322	4.2375	4.2322	4.2362	269480.0
2017-09-12 18:00:00	NVDA	Stock	4.235	4.2375	4.235	4.2355	180560.0
2017-09-12 19:00:00	NVDA	Stock	4.2355	4.2375	4.2338	4.2338	236840.0
2017-09-12 07:00:00	AMZN	Stock	49.07	49.125	49.07	49.125	10000.0
2017-09-12 08:00:00	AMZN	Stock	49.0625	49.1375	48.898	49.0625	119280.0
2017-09-12 09:00:00	AMZN	Stock	49.0625	49.2336	48.923	48.96	9099260.0
2017-09-12 10:00:00	AMZN	Stock	48.9995	49.1185	48.7759	49.0814	7498300.0
2017-09-12 11:00:00	AMZN	Stock	49.076	49.137	49.003	49.043	3637620.0
2017-09-12 12:00:00	AMZN	Stock	49.0496	49.1325	48.988	49.1116	3273240.0

> showing 50 of 48,284 rows — these rows as CSV

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