PREVIEW / stock_1hour / 2018-02-21

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-21.parquet
  size:    1.1 MB
  rows:    48,790
  symbols: 2,876

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-02-21 04:00:00	AAPL	Stock	42.975	42.975	42.9025	42.9025	20860.0
2018-02-21 05:00:00	AAPL	Stock	42.955	43.0575	42.955	43.045	31576.0
2018-02-21 06:00:00	AAPL	Stock	43.0525	43.0625	42.9675	43.0625	64484.0
2018-02-21 07:00:00	AAPL	Stock	43.03	43.15	43.0275	43.1225	197060.0
2018-02-21 08:00:00	AAPL	Stock	43.125	43.335	43.025	43.275	513868.0
2018-02-21 09:00:00	AAPL	Stock	43.26	43.3975	43.1062	43.2575	14621108.0
2018-02-21 10:00:00	AAPL	Stock	43.2588	43.445	43.2025	43.425	18104320.0
2018-02-21 11:00:00	AAPL	Stock	43.425	43.5175	43.245	43.425	16967300.0
2018-02-21 12:00:00	AAPL	Stock	43.425	43.435	43.165	43.2725	13163940.0
2018-02-21 13:00:00	AAPL	Stock	43.27	43.355	43.19	43.33	7513396.0
2018-02-21 14:00:00	AAPL	Stock	43.33	43.53	43.2725	43.3575	19809704.0
2018-02-21 15:00:00	AAPL	Stock	43.3575	43.3725	42.7525	42.7525	31313608.0
2018-02-21 16:00:00	AAPL	Stock	42.7675	42.8675	42.65	42.7125	11922284.0
2018-02-21 17:00:00	AAPL	Stock	42.7125	42.735	42.675	42.735	115508.0
2018-02-21 18:00:00	AAPL	Stock	42.73	42.745	42.63	42.6675	154708.0
2018-02-21 19:00:00	AAPL	Stock	42.6375	42.6875	42.605	42.6375	110368.0
2018-02-21 04:00:00	MSFT	Stock	92.37	92.37	92.37	92.37	100.0
2018-02-21 06:00:00	MSFT	Stock	92.71	92.71	92.71	92.71	492.0
2018-02-21 07:00:00	MSFT	Stock	92.84	92.99	92.84	92.99	4291.0
2018-02-21 08:00:00	MSFT	Stock	92.95	93.09	92.85	92.91	16262.0
2018-02-21 09:00:00	MSFT	Stock	92.95	93.17	92.83	93.01	2245153.0
2018-02-21 10:00:00	MSFT	Stock	93.02	93.36	92.93	93.14	3099322.0
2018-02-21 11:00:00	MSFT	Stock	93.14	93.21	92.78	92.82	2072710.0
2018-02-21 12:00:00	MSFT	Stock	92.815	93.01	92.68	92.83	1708590.0
2018-02-21 13:00:00	MSFT	Stock	92.82	92.9	92.445	92.715	1674114.0
2018-02-21 14:00:00	MSFT	Stock	92.71	93.3	92.58	92.79	3647689.0
2018-02-21 15:00:00	MSFT	Stock	92.81	92.84	91.5	91.5	7165003.0
2018-02-21 16:00:00	MSFT	Stock	91.49	93.0	91.49	91.5	2610641.0
2018-02-21 17:00:00	MSFT	Stock	91.56	91.56	91.48	91.54	27577.0
2018-02-21 18:00:00	MSFT	Stock	91.54	91.62	91.25	91.25	17801.0
2018-02-21 19:00:00	MSFT	Stock	91.25	91.63	91.22	91.39	6780.0
2018-02-21 06:00:00	NVDA	Stock	6.24	6.2665	6.24	6.255	105000.0
2018-02-21 07:00:00	NVDA	Stock	6.2528	6.2875	6.25	6.275	1385680.0
2018-02-21 08:00:00	NVDA	Stock	6.25	6.3	6.2465	6.2922	2861440.0
2018-02-21 09:00:00	NVDA	Stock	6.2925	6.3	6.152	6.1732	137727800.0
2018-02-21 10:00:00	NVDA	Stock	6.1732	6.1955	6.1278	6.135	121511960.0
2018-02-21 11:00:00	NVDA	Stock	6.1347	6.1895	6.113	6.1393	92599160.0
2018-02-21 12:00:00	NVDA	Stock	6.139	6.1495	6.0985	6.1305	71371360.0
2018-02-21 13:00:00	NVDA	Stock	6.1301	6.141	6.12	6.1268	32813560.0
2018-02-21 14:00:00	NVDA	Stock	6.1265	6.181	6.118	6.1268	71922200.0
2018-02-21 15:00:00	NVDA	Stock	6.127	6.1288	6.034	6.0378	133820400.0
2018-02-21 16:00:00	NVDA	Stock	6.0378	6.0435	6.0063	6.02	13311680.0
2018-02-21 17:00:00	NVDA	Stock	6.02	6.0298	6.0138	6.0275	615440.0
2018-02-21 18:00:00	NVDA	Stock	6.025	6.0372	6.0132	6.0188	440680.0
2018-02-21 19:00:00	NVDA	Stock	6.02	6.0298	6.014	6.0215	495120.0
2018-02-21 04:00:00	AMZN	Stock	73.6	73.6	73.6	73.6	6420.0
2018-02-21 05:00:00	AMZN	Stock	73.55	73.55	73.45	73.45	10740.0
2018-02-21 06:00:00	AMZN	Stock	73.5995	73.6	73.55	73.6	11100.0
2018-02-21 07:00:00	AMZN	Stock	73.699	74.05	73.699	74.05	291680.0
2018-02-21 08:00:00	AMZN	Stock	73.595	74.4175	73.595	74.3225	1194360.0

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

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