PREVIEW / stock_1hour / 2018-03-15

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-15.parquet
  size:    1.1 MB
  rows:    48,912
  symbols: 2,867

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-03-15 04:00:00	AAPL	Stock	44.6075	44.7175	44.6075	44.7175	11032.0
2018-03-15 05:00:00	AAPL	Stock	44.7175	44.7175	44.7	44.7	5316.0
2018-03-15 06:00:00	AAPL	Stock	44.65	44.65	44.55	44.55	6000.0
2018-03-15 07:00:00	AAPL	Stock	44.595	44.61	44.535	44.58	106984.0
2018-03-15 08:00:00	AAPL	Stock	44.59	44.6575	44.535	44.6275	337360.0
2018-03-15 09:00:00	AAPL	Stock	44.625	44.71	44.5675	44.6622	11022652.0
2018-03-15 10:00:00	AAPL	Stock	44.66	44.935	44.66	44.8725	14176456.0
2018-03-15 11:00:00	AAPL	Stock	44.8725	45.06	44.8625	44.9475	11619140.0
2018-03-15 12:00:00	AAPL	Stock	44.9475	44.9675	44.7875	44.8825	6663968.0
2018-03-15 13:00:00	AAPL	Stock	44.88	44.905	44.525	44.545	8951672.0
2018-03-15 14:00:00	AAPL	Stock	44.5425	44.74	44.5175	44.738	7627188.0
2018-03-15 15:00:00	AAPL	Stock	44.7375	44.815	44.6525	44.6625	14556248.0
2018-03-15 16:00:00	AAPL	Stock	44.6625	44.7425	44.6625	44.7425	6583816.0
2018-03-15 17:00:00	AAPL	Stock	44.735	44.735	44.6875	44.7175	33908.0
2018-03-15 18:00:00	AAPL	Stock	44.7225	44.75	44.7	44.7475	18180.0
2018-03-15 19:00:00	AAPL	Stock	44.7475	44.75	44.7475	44.75	15888.0
2018-03-15 04:00:00	MSFT	Stock	94.08	94.08	94.08	94.08	300.0
2018-03-15 05:00:00	MSFT	Stock	94.29	94.29	94.29	94.29	600.0
2018-03-15 06:00:00	MSFT	Stock	94.22	94.22	93.84	93.84	300.0
2018-03-15 07:00:00	MSFT	Stock	93.84	93.84	93.34	93.45	15138.0
2018-03-15 08:00:00	MSFT	Stock	93.84	93.84	93.37	93.65	19185.0
2018-03-15 09:00:00	MSFT	Stock	93.66	93.829	92.83	93.77	3705252.0
2018-03-15 10:00:00	MSFT	Stock	93.78	94.18	93.73	94.105	3412757.0
2018-03-15 11:00:00	MSFT	Stock	94.105	94.58	94.105	94.385	2978604.0
2018-03-15 12:00:00	MSFT	Stock	94.39	94.505	94.15	94.39	1589170.0
2018-03-15 13:00:00	MSFT	Stock	94.38	94.5	93.88	93.88	1876836.0
2018-03-15 14:00:00	MSFT	Stock	93.89	94.24	93.82	94.2	2183776.0
2018-03-15 15:00:00	MSFT	Stock	94.19	94.33	93.9	94.18	6117051.0
2018-03-15 16:00:00	MSFT	Stock	94.18	94.49	94.15	94.47	2217780.0
2018-03-15 17:00:00	MSFT	Stock	94.18	94.46	94.18	94.46	869335.0
2018-03-15 18:00:00	MSFT	Stock	94.45	94.45	94.36	94.36	250.0
2018-03-15 19:00:00	MSFT	Stock	94.45	94.46	94.45	94.46	928.0
2018-03-15 04:00:00	NVDA	Stock	6.2375	6.2375	6.2375	6.2375	40000.0
2018-03-15 06:00:00	NVDA	Stock	6.2375	6.2375	6.2275	6.2275	67200.0
2018-03-15 07:00:00	NVDA	Stock	6.2188	6.2188	6.1882	6.2038	230000.0
2018-03-15 08:00:00	NVDA	Stock	6.2003	6.2455	6.1988	6.2338	723480.0
2018-03-15 09:00:00	NVDA	Stock	6.2338	6.2775	6.2063	6.2698	64934600.0
2018-03-15 10:00:00	NVDA	Stock	6.271	6.3155	6.2478	6.2625	89270440.0
2018-03-15 11:00:00	NVDA	Stock	6.2623	6.2845	6.2318	6.2528	43584080.0
2018-03-15 12:00:00	NVDA	Stock	6.253	6.2563	6.2032	6.23	33958800.0
2018-03-15 13:00:00	NVDA	Stock	6.2303	6.2458	6.1988	6.1988	24738360.0
2018-03-15 14:00:00	NVDA	Stock	6.1975	6.251	6.191	6.2498	23135000.0
2018-03-15 15:00:00	NVDA	Stock	6.249	6.251	6.2266	6.2338	34355040.0
2018-03-15 16:00:00	NVDA	Stock	6.2335	6.2535	6.2275	6.2535	8733520.0
2018-03-15 17:00:00	NVDA	Stock	6.2513	6.2548	6.2438	6.2438	119800.0
2018-03-15 18:00:00	NVDA	Stock	6.2483	6.2483	6.24	6.24	277720.0
2018-03-15 19:00:00	NVDA	Stock	6.2403	6.2483	6.2403	6.2483	108800.0
2018-03-15 04:00:00	AMZN	Stock	79.9	79.984	79.9	79.984	10000.0
2018-03-15 05:00:00	AMZN	Stock	80.0	80.0	80.0	80.0	2000.0
2018-03-15 06:00:00	AMZN	Stock	79.856	79.856	79.856	79.856	2000.0

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

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