PREVIEW / stock_1hour / 2018-12-18

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-18.parquet
  size:    1.1 MB
  rows:    50,887
  symbols: 2,731

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-12-18 04:00:00	AAPL	Stock	41.175	41.3325	41.1	41.3325	21692.0
2018-12-18 05:00:00	AAPL	Stock	41.3325	41.375	41.255	41.3	11340.0
2018-12-18 06:00:00	AAPL	Stock	41.275	41.4	41.275	41.3825	22832.0
2018-12-18 07:00:00	AAPL	Stock	41.41	41.4375	41.3	41.4025	204088.0
2018-12-18 08:00:00	AAPL	Stock	41.352	41.44	41.2925	41.3375	314684.0
2018-12-18 09:00:00	AAPL	Stock	41.3025	41.5475	41.1675	41.4875	16927900.0
2018-12-18 10:00:00	AAPL	Stock	41.4875	41.5825	41.2775	41.345	17081968.0
2018-12-18 11:00:00	AAPL	Stock	41.3475	41.49	41.215	41.3938	10556084.0
2018-12-18 12:00:00	AAPL	Stock	41.3825	41.8825	41.3825	41.82	13153516.0
2018-12-18 13:00:00	AAPL	Stock	41.825	41.8375	41.475	41.5625	9479992.0
2018-12-18 14:00:00	AAPL	Stock	41.565	41.6625	41.22	41.2348	13140368.0
2018-12-18 15:00:00	AAPL	Stock	41.235	41.7525	41.0975	41.4725	26860232.0
2018-12-18 16:00:00	AAPL	Stock	41.46	41.575	41.2375	41.2375	13818100.0
2018-12-18 17:00:00	AAPL	Stock	41.2025	41.305	41.1275	41.1875	148732.0
2018-12-18 18:00:00	AAPL	Stock	41.1875	41.33	41.1775	41.3025	44548.0
2018-12-18 19:00:00	AAPL	Stock	41.3075	41.3975	41.25	41.34	76632.0
2018-12-18 04:00:00	MSFT	Stock	103.26	103.5	103.13	103.5	2299.0
2018-12-18 05:00:00	MSFT	Stock	103.6	103.6	103.5	103.5	1377.0
2018-12-18 06:00:00	MSFT	Stock	103.46	103.65	103.4	103.6	16846.0
2018-12-18 07:00:00	MSFT	Stock	103.58	103.95	103.44	103.95	16327.0
2018-12-18 08:00:00	MSFT	Stock	103.65	103.96	103.15	103.62	52443.0
2018-12-18 09:00:00	MSFT	Stock	103.62	104.08	102.91	103.48	3662863.0
2018-12-18 10:00:00	MSFT	Stock	103.47	103.62	102.77	103.04	5270702.0
2018-12-18 11:00:00	MSFT	Stock	103.04	103.3	102.52	103.005	3716409.0
2018-12-18 12:00:00	MSFT	Stock	102.98	104.2	102.98	104.11	3536118.0
2018-12-18 13:00:00	MSFT	Stock	104.105	104.205	103.32	103.55	2730874.0
2018-12-18 14:00:00	MSFT	Stock	103.53	103.99	103.11	103.13	5012066.0
2018-12-18 15:00:00	MSFT	Stock	103.15	104.51	102.67	103.94	9529846.0
2018-12-18 16:00:00	MSFT	Stock	103.94	103.97	103.05	103.23	9925664.0
2018-12-18 17:00:00	MSFT	Stock	103.5	103.5	103.22	103.3	11173.0
2018-12-18 18:00:00	MSFT	Stock	103.39	103.55	103.2	103.4	8377.0
2018-12-18 19:00:00	MSFT	Stock	103.6	103.8	103.4	103.8	9927.0
2018-12-18 04:00:00	NVDA	Stock	3.6125	3.6125	3.6125	3.6125	21400.0
2018-12-18 05:00:00	NVDA	Stock	3.6112	3.6112	3.6112	3.6112	15520.0
2018-12-18 06:00:00	NVDA	Stock	3.63	3.6662	3.63	3.6662	17600.0
2018-12-18 07:00:00	NVDA	Stock	3.6275	3.6495	3.6225	3.6475	597960.0
2018-12-18 08:00:00	NVDA	Stock	3.648	3.6492	3.615	3.6315	932760.0
2018-12-18 09:00:00	NVDA	Stock	3.6368	3.72	3.6062	3.7045	72665600.0
2018-12-18 10:00:00	NVDA	Stock	3.7055	3.7468	3.6778	3.7444	121853600.0
2018-12-18 11:00:00	NVDA	Stock	3.7455	3.7575	3.6795	3.6945	77228080.0
2018-12-18 12:00:00	NVDA	Stock	3.692	3.7552	3.6918	3.7525	55077680.0
2018-12-18 13:00:00	NVDA	Stock	3.7528	3.7582	3.6918	3.7044	54256160.0
2018-12-18 14:00:00	NVDA	Stock	3.7048	3.7195	3.654	3.6572	40348920.0
2018-12-18 15:00:00	NVDA	Stock	3.6555	3.7102	3.6448	3.6735	76682080.0
2018-12-18 16:00:00	NVDA	Stock	3.6735	3.6775	3.63	3.63	18837200.0
2018-12-18 17:00:00	NVDA	Stock	3.63	3.6735	3.5878	3.59	2297640.0
2018-12-18 18:00:00	NVDA	Stock	3.596	3.63	3.588	3.6175	415120.0
2018-12-18 19:00:00	NVDA	Stock	3.6238	3.6375	3.615	3.625	449160.0
2018-12-18 04:00:00	AMZN	Stock	76.5	76.5	76.5	76.5	2000.0
2018-12-18 06:00:00	AMZN	Stock	76.95	77.0	76.868	76.868	6000.0

> showing 50 of 50,887 rows — these rows as CSV

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