PREVIEW / stock_1hour / 2018-08-15

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-15.parquet
  size:    1.1 MB
  rows:    49,015
  symbols: 2,796

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
2018-08-15 04:00:00	AAPL	Stock	52.5	52.635	52.5	52.62	15324.0
2018-08-15 05:00:00	AAPL	Stock	52.6225	52.6225	52.5	52.5	13260.0
2018-08-15 06:00:00	AAPL	Stock	52.55	52.5825	52.255	52.27	69644.0
2018-08-15 07:00:00	AAPL	Stock	52.3075	52.3175	52.0	52.0475	788512.0
2018-08-15 08:00:00	AAPL	Stock	52.275	52.3125	52.0175	52.11	458724.0
2018-08-15 09:00:00	AAPL	Stock	52.11	52.495	52.075	52.2838	13011332.0
2018-08-15 10:00:00	AAPL	Stock	52.2825	52.3125	52.0825	52.1502	16497724.0
2018-08-15 11:00:00	AAPL	Stock	52.1475	52.3025	52.0975	52.1038	11684320.0
2018-08-15 12:00:00	AAPL	Stock	52.1025	52.3125	52.0975	52.2962	7946720.0
2018-08-15 13:00:00	AAPL	Stock	52.2975	52.5375	52.265	52.381	14557428.0
2018-08-15 14:00:00	AAPL	Stock	52.3775	52.4263	52.2625	52.4263	8296820.0
2018-08-15 15:00:00	AAPL	Stock	52.425	52.685	52.4168	52.575	17985652.0
2018-08-15 16:00:00	AAPL	Stock	52.6225	52.6225	52.5325	52.605	7847756.0
2018-08-15 17:00:00	AAPL	Stock	52.605	52.6175	52.5825	52.6	66904.0
2018-08-15 18:00:00	AAPL	Stock	52.6	52.61	52.575	52.6	32236.0
2018-08-15 19:00:00	AAPL	Stock	52.5775	52.6	52.5375	52.5375	89152.0
2018-08-15 04:00:00	MSFT	Stock	109.48	109.72	109.48	109.48	1182.0
2018-08-15 05:00:00	MSFT	Stock	109.36	109.36	109.2	109.2	1392.0
2018-08-15 06:00:00	MSFT	Stock	109.2	109.28	108.58	108.58	20087.0
2018-08-15 07:00:00	MSFT	Stock	108.76	108.88	108.25	108.49	29324.0
2018-08-15 08:00:00	MSFT	Stock	108.76	108.79	108.42	108.58	25269.0
2018-08-15 09:00:00	MSFT	Stock	108.56	108.985	108.01	108.13	2844609.0
2018-08-15 10:00:00	MSFT	Stock	108.13	108.15	107.05	107.27	5319541.0
2018-08-15 11:00:00	MSFT	Stock	107.27	107.73	107.12	107.28	3721847.0
2018-08-15 12:00:00	MSFT	Stock	107.27	107.86	107.16	107.62	2172568.0
2018-08-15 13:00:00	MSFT	Stock	107.62	107.795	107.287	107.33	1906362.0
2018-08-15 14:00:00	MSFT	Stock	107.32	107.37	106.82	107.37	3291452.0
2018-08-15 15:00:00	MSFT	Stock	107.37	107.82	107.27	107.68	4774915.0
2018-08-15 16:00:00	MSFT	Stock	107.66	107.86	107.54	107.77	3067228.0
2018-08-15 17:00:00	MSFT	Stock	107.8	107.82	107.77	107.8	5866.0
2018-08-15 18:00:00	MSFT	Stock	107.82	107.83	107.8	107.83	3917.0
2018-08-15 19:00:00	MSFT	Stock	107.81	107.84	107.77	107.84	5782.0
2018-08-15 04:00:00	NVDA	Stock	6.615	6.6375	6.6002	6.6148	566800.0
2018-08-15 05:00:00	NVDA	Stock	6.6075	6.6118	6.581	6.5838	250080.0
2018-08-15 06:00:00	NVDA	Stock	6.5768	6.5782	6.5155	6.5305	1117840.0
2018-08-15 07:00:00	NVDA	Stock	6.548	6.5668	6.5013	6.5325	1799440.0
2018-08-15 08:00:00	NVDA	Stock	6.55	6.5685	6.5027	6.5475	5038040.0
2018-08-15 09:00:00	NVDA	Stock	6.5463	6.591	6.481	6.5022	99882040.0
2018-08-15 10:00:00	NVDA	Stock	6.5035	6.5038	6.4005	6.4015	104066440.0
2018-08-15 11:00:00	NVDA	Stock	6.4015	6.4712	6.3975	6.4165	71700840.0
2018-08-15 12:00:00	NVDA	Stock	6.4162	6.4575	6.4085	6.4478	48400680.0
2018-08-15 13:00:00	NVDA	Stock	6.4488	6.4688	6.425	6.4408	43065600.0
2018-08-15 14:00:00	NVDA	Stock	6.4398	6.444	6.4128	6.4421	40925200.0
2018-08-15 15:00:00	NVDA	Stock	6.4415	6.4903	6.437	6.4755	72462320.0
2018-08-15 16:00:00	NVDA	Stock	6.477	6.4963	6.4702	6.4963	17884360.0
2018-08-15 17:00:00	NVDA	Stock	6.496	6.496	6.4803	6.4862	1207240.0
2018-08-15 18:00:00	NVDA	Stock	6.49	6.491	6.48	6.4805	974280.0
2018-08-15 19:00:00	NVDA	Stock	6.4838	6.4875	6.48	6.4825	473920.0
2018-08-15 04:00:00	AMZN	Stock	96.2	96.3	96.2	96.3	10080.0
2018-08-15 05:00:00	AMZN	Stock	96.2	96.2895	96.2	96.2	13900.0

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

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