PREVIEW / stock_1hour / 2018-07-25

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-25.parquet
  size:    1.1 MB
  rows:    49,372
  symbols: 2,808

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-07-25 06:00:00	AAPL	Stock	48.2525	48.2525	48.2225	48.2225	1160.0
2018-07-25 07:00:00	AAPL	Stock	48.225	48.225	48.1275	48.1775	30700.0
2018-07-25 08:00:00	AAPL	Stock	48.25	48.2975	48.1475	48.2125	42856.0
2018-07-25 09:00:00	AAPL	Stock	48.2025	48.4125	48.19	48.3125	6698604.0
2018-07-25 10:00:00	AAPL	Stock	48.3075	48.325	48.1075	48.185	7188752.0
2018-07-25 11:00:00	AAPL	Stock	48.1825	48.37	48.1425	48.37	6165384.0
2018-07-25 12:00:00	AAPL	Stock	48.37	48.5025	48.36	48.4525	6927852.0
2018-07-25 13:00:00	AAPL	Stock	48.4525	48.4775	48.355	48.4538	3646484.0
2018-07-25 14:00:00	AAPL	Stock	48.455	48.495	48.4025	48.43	4606412.0
2018-07-25 15:00:00	AAPL	Stock	48.4275	48.7125	48.3825	48.705	15847024.0
2018-07-25 16:00:00	AAPL	Stock	48.705	48.705	48.4625	48.6	7609936.0
2018-07-25 17:00:00	AAPL	Stock	48.6	48.61	47.925	48.1225	481016.0
2018-07-25 18:00:00	AAPL	Stock	48.155	48.3675	48.15	48.23	489180.0
2018-07-25 19:00:00	AAPL	Stock	48.23	48.3	48.2125	48.2125	94796.0
2018-07-25 05:00:00	MSFT	Stock	107.64	107.64	107.64	107.64	566.0
2018-07-25 06:00:00	MSFT	Stock	107.64	107.64	107.64	107.64	100.0
2018-07-25 07:00:00	MSFT	Stock	107.63	107.63	107.4	107.41	1988.0
2018-07-25 08:00:00	MSFT	Stock	107.622	107.9	107.41	107.75	20122.0
2018-07-25 09:00:00	MSFT	Stock	107.77	108.25	107.6	108.17	2419674.0
2018-07-25 10:00:00	MSFT	Stock	108.16	108.59	107.91	108.4	2835544.0
2018-07-25 11:00:00	MSFT	Stock	108.41	109.22	108.36	109.04	3485848.0
2018-07-25 12:00:00	MSFT	Stock	109.04	109.55	108.88	109.445	2436950.0
2018-07-25 13:00:00	MSFT	Stock	109.445	109.55	109.2	109.536	2179426.0
2018-07-25 14:00:00	MSFT	Stock	109.53	109.95	109.1	109.92	3129060.0
2018-07-25 15:00:00	MSFT	Stock	109.912	111.15	109.75	110.82	8709806.0
2018-07-25 16:00:00	MSFT	Stock	110.83	110.83	108.985	110.5	3007346.0
2018-07-25 17:00:00	MSFT	Stock	110.5	110.58	108.75	109.5	95086.0
2018-07-25 18:00:00	MSFT	Stock	109.62	110.6	109.2	110.25	108201.0
2018-07-25 19:00:00	MSFT	Stock	110.25	110.38	110.04	110.1	24696.0
2018-07-25 04:00:00	NVDA	Stock	6.225	6.225	6.225	6.225	12000.0
2018-07-25 06:00:00	NVDA	Stock	6.225	6.225	6.225	6.225	5080.0
2018-07-25 07:00:00	NVDA	Stock	6.209	6.209	6.2063	6.2075	36960.0
2018-07-25 08:00:00	NVDA	Stock	6.227	6.2272	6.2	6.2008	369560.0
2018-07-25 09:00:00	NVDA	Stock	6.2005	6.2623	6.198	6.2153	34594720.0
2018-07-25 10:00:00	NVDA	Stock	6.2155	6.2338	6.1688	6.2048	56571640.0
2018-07-25 11:00:00	NVDA	Stock	6.2055	6.2805	6.2003	6.277	36733520.0
2018-07-25 12:00:00	NVDA	Stock	6.277	6.3095	6.2675	6.297	35455880.0
2018-07-25 13:00:00	NVDA	Stock	6.2968	6.3055	6.2763	6.2858	21838240.0
2018-07-25 14:00:00	NVDA	Stock	6.2862	6.3	6.2587	6.261	29674360.0
2018-07-25 15:00:00	NVDA	Stock	6.2618	6.2985	6.2364	6.2972	58778440.0
2018-07-25 16:00:00	NVDA	Stock	6.2968	6.3595	6.225	6.3263	8618560.0
2018-07-25 17:00:00	NVDA	Stock	6.3398	6.3538	6.2125	6.2125	5219040.0
2018-07-25 18:00:00	NVDA	Stock	6.2125	6.2735	6.2125	6.227	1301280.0
2018-07-25 19:00:00	NVDA	Stock	6.2195	6.245	6.2195	6.225	379360.0
2018-07-25 04:00:00	AMZN	Stock	91.6	91.6	91.585	91.585	6260.0
2018-07-25 05:00:00	AMZN	Stock	91.7	91.75	91.7	91.75	6960.0
2018-07-25 06:00:00	AMZN	Stock	91.75	91.75	91.75	91.75	4000.0
2018-07-25 07:00:00	AMZN	Stock	91.545	91.6555	91.423	91.45	72560.0
2018-07-25 08:00:00	AMZN	Stock	91.65	91.791	91.35	91.547	229680.0
2018-07-25 09:00:00	AMZN	Stock	91.55	91.792	91.132	91.7855	7239040.0

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

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