PREVIEW / stock_1hour / 2018-04-09

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-09.parquet
  size:    1.1 MB
  rows:    48,588
  symbols: 2,856

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-04-09 04:00:00	AAPL	Stock	42.535	42.6225	42.535	42.6125	2300.0
2018-04-09 05:00:00	AAPL	Stock	42.6075	42.61	42.5625	42.6075	3012.0
2018-04-09 06:00:00	AAPL	Stock	42.6025	42.6875	42.5625	42.5625	56156.0
2018-04-09 07:00:00	AAPL	Stock	42.575	42.6125	42.47	42.5225	202792.0
2018-04-09 08:00:00	AAPL	Stock	42.54	42.6125	42.4	42.4925	390628.0
2018-04-09 09:00:00	AAPL	Stock	42.495	42.9	42.4375	42.8375	14865948.0
2018-04-09 10:00:00	AAPL	Stock	42.84	42.9875	42.705	42.9375	14824680.0
2018-04-09 11:00:00	AAPL	Stock	42.94	43.12	42.8425	43.1112	12387748.0
2018-04-09 12:00:00	AAPL	Stock	43.1125	43.245	42.985	43.2	10929576.0
2018-04-09 13:00:00	AAPL	Stock	43.2	43.2725	43.14	43.245	8473960.0
2018-04-09 14:00:00	AAPL	Stock	43.245	43.2575	42.8875	43.1	9959768.0
2018-04-09 15:00:00	AAPL	Stock	43.1025	43.112	42.465	42.515	18125432.0
2018-04-09 16:00:00	AAPL	Stock	42.5125	43.0775	42.4375	42.5125	13062620.0
2018-04-09 17:00:00	AAPL	Stock	42.5275	42.555	42.5	42.5125	74360.0
2018-04-09 18:00:00	AAPL	Stock	42.515	42.575	42.5	42.5025	59732.0
2018-04-09 19:00:00	AAPL	Stock	42.5	42.55	42.5	42.535	60416.0
2018-04-09 04:00:00	MSFT	Stock	91.03	91.2	91.03	91.2	900.0
2018-04-09 05:00:00	MSFT	Stock	91.25	91.41	91.25	91.26	3445.0
2018-04-09 06:00:00	MSFT	Stock	91.2	91.4	91.11	91.11	4233.0
2018-04-09 07:00:00	MSFT	Stock	91.11	91.25	90.94	91.0	14845.0
2018-04-09 08:00:00	MSFT	Stock	91.2	91.25	90.9	91.05	21768.0
2018-04-09 09:00:00	MSFT	Stock	91.02	92.08	91.0	91.79	2953111.0
2018-04-09 10:00:00	MSFT	Stock	91.8	92.375	91.57	92.15	3314664.0
2018-04-09 11:00:00	MSFT	Stock	92.15	92.84	91.93	92.82	2569129.0
2018-04-09 12:00:00	MSFT	Stock	92.82	93.17	92.67	92.84	2647543.0
2018-04-09 13:00:00	MSFT	Stock	92.83	93.005	92.564	92.776	1824300.0
2018-04-09 14:00:00	MSFT	Stock	92.78	92.8	91.88	92.285	2805218.0
2018-04-09 15:00:00	MSFT	Stock	92.281	92.285	90.62	90.78	6399010.0
2018-04-09 16:00:00	MSFT	Stock	90.73	90.94	90.36	90.87	6360624.0
2018-04-09 17:00:00	MSFT	Stock	90.8	90.8	90.75	90.8	10792.0
2018-04-09 18:00:00	MSFT	Stock	90.8	90.8	90.72	90.78	11159.0
2018-04-09 19:00:00	MSFT	Stock	90.74	90.85	90.74	90.8	6945.0
2018-04-09 04:00:00	NVDA	Stock	5.4303	5.4595	5.4282	5.4595	46960.0
2018-04-09 05:00:00	NVDA	Stock	5.4595	5.4595	5.445	5.4498	68280.0
2018-04-09 06:00:00	NVDA	Stock	5.44	5.4498	5.4388	5.4388	35800.0
2018-04-09 07:00:00	NVDA	Stock	5.4375	5.4473	5.4125	5.4238	596680.0
2018-04-09 08:00:00	NVDA	Stock	5.4298	5.4473	5.4025	5.4188	2757480.0
2018-04-09 09:00:00	NVDA	Stock	5.4188	5.495	5.365	5.478	72426280.0
2018-04-09 10:00:00	NVDA	Stock	5.4785	5.532	5.4702	5.517	79444520.0
2018-04-09 11:00:00	NVDA	Stock	5.517	5.5201	5.472	5.5094	48791680.0
2018-04-09 12:00:00	NVDA	Stock	5.5086	5.5493	5.5	5.5154	39272480.0
2018-04-09 13:00:00	NVDA	Stock	5.5196	5.5355	5.497	5.5137	23990760.0
2018-04-09 14:00:00	NVDA	Stock	5.5138	5.515	5.4655	5.4902	33471440.0
2018-04-09 15:00:00	NVDA	Stock	5.4908	5.4913	5.3783	5.3852	75645840.0
2018-04-09 16:00:00	NVDA	Stock	5.3852	5.533	5.3763	5.5038	20267760.0
2018-04-09 17:00:00	NVDA	Stock	5.5038	5.5096	5.4812	5.4865	1407160.0
2018-04-09 18:00:00	NVDA	Stock	5.4875	5.4913	5.475	5.4812	508560.0
2018-04-09 19:00:00	NVDA	Stock	5.4812	5.49	5.4788	5.49	778720.0
2018-04-09 04:00:00	AMZN	Stock	71.0355	71.1	71.0355	71.1	6000.0
2018-04-09 05:00:00	AMZN	Stock	71.275	71.275	71.275	71.275	2000.0

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

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