PREVIEW / stock_1hour / 2018-06-29

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-29.parquet
  size:    1.1 MB
  rows:    49,856
  symbols: 2,837

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-06-29 04:00:00	AAPL	Stock	46.615	46.825	46.615	46.8	34336.0
2018-06-29 05:00:00	AAPL	Stock	46.8225	46.8225	46.75	46.75	4708.0
2018-06-29 06:00:00	AAPL	Stock	46.7425	46.7475	46.595	46.6375	99968.0
2018-06-29 07:00:00	AAPL	Stock	46.6425	46.7	46.58	46.6625	113884.0
2018-06-29 08:00:00	AAPL	Stock	46.625	46.7225	46.585	46.6025	189880.0
2018-06-29 09:00:00	AAPL	Stock	46.5975	46.7975	46.5625	46.6262	9054444.0
2018-06-29 10:00:00	AAPL	Stock	46.6225	46.6925	46.5025	46.553	7788084.0
2018-06-29 11:00:00	AAPL	Stock	46.555	46.6275	46.485	46.5325	5645532.0
2018-06-29 12:00:00	AAPL	Stock	46.5325	46.6525	46.4875	46.5345	5609400.0
2018-06-29 13:00:00	AAPL	Stock	46.535	46.5975	46.5	46.5788	3795352.0
2018-06-29 14:00:00	AAPL	Stock	46.5775	46.6125	46.525	46.6	4881024.0
2018-06-29 15:00:00	AAPL	Stock	46.6025	46.6175	45.7275	45.7275	21504732.0
2018-06-29 16:00:00	AAPL	Stock	45.7275	46.569	45.7275	46.2775	18898120.0
2018-06-29 17:00:00	AAPL	Stock	46.2775	46.2975	46.2	46.275	1831860.0
2018-06-29 18:00:00	AAPL	Stock	46.25	46.275	46.25	46.275	12084.0
2018-06-29 19:00:00	AAPL	Stock	46.275	46.295	46.2525	46.275	19460.0
2018-06-29 04:00:00	MSFT	Stock	99.65	99.65	99.65	99.65	100.0
2018-06-29 05:00:00	MSFT	Stock	99.73	99.88	99.73	99.88	1188.0
2018-06-29 06:00:00	MSFT	Stock	99.39	99.45	99.15	99.23	8118.0
2018-06-29 07:00:00	MSFT	Stock	99.35	99.35	99.13	99.3	4993.0
2018-06-29 08:00:00	MSFT	Stock	99.35	99.38	99.13	99.33	27639.0
2018-06-29 09:00:00	MSFT	Stock	99.19	99.5	98.85	99.48	2367488.0
2018-06-29 10:00:00	MSFT	Stock	99.48	99.91	99.39	99.74	2775890.0
2018-06-29 11:00:00	MSFT	Stock	99.74	99.78	99.155	99.29	1661715.0
2018-06-29 12:00:00	MSFT	Stock	99.28	99.52	99.175	99.32	1588528.0
2018-06-29 13:00:00	MSFT	Stock	99.33	99.47	99.215	99.45	1197605.0
2018-06-29 14:00:00	MSFT	Stock	99.45	99.49	99.12	99.345	1231807.0
2018-06-29 15:00:00	MSFT	Stock	99.34	99.391	98.49	98.61	6570199.0
2018-06-29 16:00:00	MSFT	Stock	98.61	99.1	98.33	98.85	6807111.0
2018-06-29 17:00:00	MSFT	Stock	98.86	98.88	98.61	98.86	405581.0
2018-06-29 18:00:00	MSFT	Stock	98.86	98.9	98.85	98.86	2225.0
2018-06-29 19:00:00	MSFT	Stock	98.87	98.98	98.87	98.9	1955.0
2018-06-29 04:00:00	NVDA	Stock	6.0998	6.0998	6.0873	6.09	83920.0
2018-06-29 05:00:00	NVDA	Stock	6.0935	6.0975	6.0875	6.0875	39000.0
2018-06-29 06:00:00	NVDA	Stock	6.093	6.0975	6.054	6.0655	103560.0
2018-06-29 07:00:00	NVDA	Stock	6.0725	6.0843	6.0578	6.0843	136600.0
2018-06-29 08:00:00	NVDA	Stock	6.0875	6.0975	6.0625	6.0798	784600.0
2018-06-29 09:00:00	NVDA	Stock	6.075	6.1	6.0112	6.025	62123280.0
2018-06-29 10:00:00	NVDA	Stock	6.025	6.0425	5.9762	5.9863	54151480.0
2018-06-29 11:00:00	NVDA	Stock	5.986	5.986	5.945	5.9533	46073400.0
2018-06-29 12:00:00	NVDA	Stock	5.954	5.965	5.934	5.9395	23422640.0
2018-06-29 13:00:00	NVDA	Stock	5.9398	5.9835	5.9382	5.9765	28780120.0
2018-06-29 14:00:00	NVDA	Stock	5.9775	5.9924	5.964	5.9913	30135960.0
2018-06-29 15:00:00	NVDA	Stock	5.9906	5.9938	5.9213	5.9225	90927160.0
2018-06-29 16:00:00	NVDA	Stock	5.9225	5.935	5.9225	5.93	16966200.0
2018-06-29 17:00:00	NVDA	Stock	5.929	5.9312	5.9215	5.9215	269120.0
2018-06-29 18:00:00	NVDA	Stock	5.9292	5.9298	5.9238	5.9288	73600.0
2018-06-29 19:00:00	NVDA	Stock	5.9288	5.9288	5.9163	5.925	271760.0
2018-06-29 04:00:00	AMZN	Stock	86.05	86.05	86.0	86.025	39880.0
2018-06-29 05:00:00	AMZN	Stock	86.05	86.05	85.9625	85.9625	11320.0

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

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