PREVIEW / stock_1hour / 2018-07-05

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-05.parquet
  size:    1.1 MB
  rows:    49,168
  symbols: 2,820

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-05 04:00:00	AAPL	Stock	46.1125	46.25	46.1125	46.25	10840.0
2018-07-05 05:00:00	AAPL	Stock	46.2375	46.3	46.2375	46.3	3216.0
2018-07-05 06:00:00	AAPL	Stock	46.295	46.295	46.24	46.24	6676.0
2018-07-05 07:00:00	AAPL	Stock	46.2425	46.355	46.24	46.35	158304.0
2018-07-05 08:00:00	AAPL	Stock	46.3562	46.41	46.2675	46.3275	258020.0
2018-07-05 09:00:00	AAPL	Stock	46.33	46.6025	46.275	46.39	10636364.0
2018-07-05 10:00:00	AAPL	Stock	46.41	46.4642	46.07	46.1375	12320144.0
2018-07-05 11:00:00	AAPL	Stock	46.135	46.425	46.105	46.36	6509732.0
2018-07-05 12:00:00	AAPL	Stock	46.36	46.5225	46.3425	46.4538	4166812.0
2018-07-05 13:00:00	AAPL	Stock	46.455	46.4875	46.3325	46.39	3237876.0
2018-07-05 14:00:00	AAPL	Stock	46.3875	46.4475	46.24	46.4175	5374052.0
2018-07-05 15:00:00	AAPL	Stock	46.4175	46.4875	46.335	46.345	10026784.0
2018-07-05 16:00:00	AAPL	Stock	46.3475	46.4225	46.3475	46.375	5605216.0
2018-07-05 17:00:00	AAPL	Stock	46.3675	46.375	46.25	46.255	43860.0
2018-07-05 18:00:00	AAPL	Stock	46.275	46.3	46.25	46.25	74600.0
2018-07-05 19:00:00	AAPL	Stock	46.25	46.2625	46.2	46.2125	29420.0
2018-07-05 05:00:00	MSFT	Stock	99.27	99.83	99.27	99.83	1505.0
2018-07-05 06:00:00	MSFT	Stock	99.39	99.78	99.39	99.78	505.0
2018-07-05 07:00:00	MSFT	Stock	99.7	99.92	99.7	99.9	7752.0
2018-07-05 08:00:00	MSFT	Stock	99.58	99.84	99.58	99.75	18367.0
2018-07-05 09:00:00	MSFT	Stock	99.75	99.82	99.3	99.37	2606676.0
2018-07-05 10:00:00	MSFT	Stock	99.39	99.65	99.03	99.2	2611971.0
2018-07-05 11:00:00	MSFT	Stock	99.2	99.72	99.15	99.53	2457160.0
2018-07-05 12:00:00	MSFT	Stock	99.54	99.88	99.48	99.69	1567870.0
2018-07-05 13:00:00	MSFT	Stock	99.685	99.775	99.41	99.62	1364558.0
2018-07-05 14:00:00	MSFT	Stock	99.62	99.79	99.16	99.665	1668863.0
2018-07-05 15:00:00	MSFT	Stock	99.67	99.92	99.63	99.77	2987212.0
2018-07-05 16:00:00	MSFT	Stock	99.76	99.88	99.61	99.76	1882018.0
2018-07-05 17:00:00	MSFT	Stock	99.66	99.66	99.66	99.66	2200.0
2018-07-05 18:00:00	MSFT	Stock	99.66	99.66	99.52	99.53	5542.0
2018-07-05 19:00:00	MSFT	Stock	99.52	99.55	99.3	99.51	4226.0
2018-07-05 04:00:00	NVDA	Stock	5.9425	5.9425	5.9425	5.9425	4000.0
2018-07-05 05:00:00	NVDA	Stock	5.9375	5.95	5.9375	5.95	20920.0
2018-07-05 06:00:00	NVDA	Stock	5.949	5.949	5.9468	5.9473	22560.0
2018-07-05 07:00:00	NVDA	Stock	5.939	5.9853	5.939	5.9853	192960.0
2018-07-05 08:00:00	NVDA	Stock	5.945	5.9853	5.93	5.9488	1832040.0
2018-07-05 09:00:00	NVDA	Stock	5.9488	6.0252	5.9475	5.9674	39895000.0
2018-07-05 10:00:00	NVDA	Stock	5.9702	5.997	5.9375	5.9808	54814440.0
2018-07-05 11:00:00	NVDA	Stock	5.979	6.0335	5.9725	6.017	33336040.0
2018-07-05 12:00:00	NVDA	Stock	6.0165	6.0405	6.0135	6.0326	24983120.0
2018-07-05 13:00:00	NVDA	Stock	6.0315	6.0428	6.0203	6.0273	17552040.0
2018-07-05 14:00:00	NVDA	Stock	6.0278	6.0425	6.003	6.0383	24782880.0
2018-07-05 15:00:00	NVDA	Stock	6.0375	6.0733	6.033	6.0685	50467240.0
2018-07-05 16:00:00	NVDA	Stock	6.0682	6.0715	6.0525	6.061	3790040.0
2018-07-05 17:00:00	NVDA	Stock	6.0605	6.0673	6.055	6.055	151520.0
2018-07-05 18:00:00	NVDA	Stock	6.0508	6.055	6.0318	6.0318	666720.0
2018-07-05 19:00:00	NVDA	Stock	6.0475	6.06	6.035	6.04	455160.0
2018-07-05 06:00:00	AMZN	Stock	85.5	85.5	85.5	85.5	10340.0
2018-07-05 07:00:00	AMZN	Stock	85.2905	85.495	85.2765	85.495	138860.0
2018-07-05 08:00:00	AMZN	Stock	85.45	85.5	85.25	85.325	173980.0

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

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