PREVIEW / stock_1hour / 2018-06-27

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-06-27.parquet
  size:    1.1 MB
  rows:    49,961
  symbols: 2,815

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-27 04:00:00	AAPL	Stock	45.9725	45.9725	45.625	45.625	50200.0
2018-06-27 05:00:00	AAPL	Stock	45.7	45.92	45.7	45.92	20476.0
2018-06-27 06:00:00	AAPL	Stock	45.85	45.925	45.85	45.875	32536.0
2018-06-27 07:00:00	AAPL	Stock	45.9125	46.28	45.8	46.1975	256928.0
2018-06-27 08:00:00	AAPL	Stock	46.22	46.48	45.8	46.205	500660.0
2018-06-27 09:00:00	AAPL	Stock	46.2275	46.61	46.2275	46.59	9410692.0
2018-06-27 10:00:00	AAPL	Stock	46.585	46.82	46.505	46.6675	11212056.0
2018-06-27 11:00:00	AAPL	Stock	46.6725	46.78	46.5525	46.6975	10978116.0
2018-06-27 12:00:00	AAPL	Stock	46.69	46.735	46.31	46.3125	8498816.0
2018-06-27 13:00:00	AAPL	Stock	46.3175	46.3725	46.09	46.255	11251980.0
2018-06-27 14:00:00	AAPL	Stock	46.25	46.395	46.1625	46.23	8317760.0
2018-06-27 15:00:00	AAPL	Stock	46.235	46.36	46.0075	46.0412	19581772.0
2018-06-27 16:00:00	AAPL	Stock	46.04	46.928	46.015	46.928	9095140.0
2018-06-27 17:00:00	AAPL	Stock	46.045	46.0975	46.025	46.0925	22788.0
2018-06-27 18:00:00	AAPL	Stock	46.075	46.1325	46.04	46.065	57100.0
2018-06-27 19:00:00	AAPL	Stock	46.0975	46.16	46.075	46.16	38776.0
2018-06-27 04:00:00	MSFT	Stock	99.0	99.0	98.3	98.3	2034.0
2018-06-27 05:00:00	MSFT	Stock	97.81	97.81	97.7	97.7	301.0
2018-06-27 07:00:00	MSFT	Stock	98.58	99.46	98.31	99.1	19494.0
2018-06-27 08:00:00	MSFT	Stock	98.5	99.57	98.45	99.15	26051.0
2018-06-27 09:00:00	MSFT	Stock	99.22	99.94	99.22	99.61	2676802.0
2018-06-27 10:00:00	MSFT	Stock	99.6	99.89	99.15	99.61	3139545.0
2018-06-27 11:00:00	MSFT	Stock	99.62	100.02	99.28	99.406	3378730.0
2018-06-27 12:00:00	MSFT	Stock	99.41	99.55	98.8	98.801	1826342.0
2018-06-27 13:00:00	MSFT	Stock	98.807	98.99	98.03	98.25	2637351.0
2018-06-27 14:00:00	MSFT	Stock	98.25	98.575	98.02	98.1	2210656.0
2018-06-27 15:00:00	MSFT	Stock	98.11	98.155	97.4	97.54	6978312.0
2018-06-27 16:00:00	MSFT	Stock	97.54	97.73	97.5	97.65	3063733.0
2018-06-27 17:00:00	MSFT	Stock	97.61	97.75	97.6	97.6	2359.0
2018-06-27 18:00:00	MSFT	Stock	97.72	97.8	97.71	97.8	1190.0
2018-06-27 19:00:00	MSFT	Stock	97.8	97.97	97.8	97.95	2146.0
2018-06-27 04:00:00	NVDA	Stock	6.003	6.003	5.956	5.956	40480.0
2018-06-27 05:00:00	NVDA	Stock	5.95	5.995	5.95	5.995	121880.0
2018-06-27 06:00:00	NVDA	Stock	5.99	5.993	5.9878	5.9878	26400.0
2018-06-27 07:00:00	NVDA	Stock	5.9975	6.075	5.9968	6.0372	660080.0
2018-06-27 08:00:00	NVDA	Stock	6.0125	6.1062	5.9938	6.0875	2515040.0
2018-06-27 09:00:00	NVDA	Stock	6.0875	6.1608	6.085	6.1145	73153960.0
2018-06-27 10:00:00	NVDA	Stock	6.1142	6.1185	6.0618	6.0625	57897200.0
2018-06-27 11:00:00	NVDA	Stock	6.0625	6.0678	6.0205	6.0452	47685920.0
2018-06-27 12:00:00	NVDA	Stock	6.0446	6.0482	5.993	5.9965	29595560.0
2018-06-27 13:00:00	NVDA	Stock	5.9983	6.0088	5.936	5.9639	52376400.0
2018-06-27 14:00:00	NVDA	Stock	5.964	5.9812	5.927	5.932	40641160.0
2018-06-27 15:00:00	NVDA	Stock	5.9318	5.9545	5.8875	5.8898	81182800.0
2018-06-27 16:00:00	NVDA	Stock	5.891	5.905	5.8875	5.8943	16225160.0
2018-06-27 17:00:00	NVDA	Stock	5.895	5.9	5.89	5.8962	314560.0
2018-06-27 18:00:00	NVDA	Stock	5.8995	5.9188	5.8962	5.9088	337720.0
2018-06-27 19:00:00	NVDA	Stock	5.91	5.918	5.9062	5.9075	139040.0
2018-06-27 04:00:00	AMZN	Stock	83.7105	83.7105	83.7	83.7	12000.0
2018-06-27 05:00:00	AMZN	Stock	83.8895	83.9445	83.76	83.9445	33320.0
2018-06-27 06:00:00	AMZN	Stock	84.0015	84.0545	83.9755	84.0545	11060.0

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

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