PREVIEW / stock_1hour / 2018-01-26

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-26.parquet
  size:    1.1 MB
  rows:    50,001
  symbols: 2,903

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-01-26 04:00:00	AAPL	Stock	43.0025	43.0875	42.9875	43.0875	89812.0
2018-01-26 05:00:00	AAPL	Stock	43.075	43.125	43.075	43.125	18544.0
2018-01-26 06:00:00	AAPL	Stock	43.1175	43.175	43.1025	43.165	99392.0
2018-01-26 07:00:00	AAPL	Stock	43.1325	43.1375	43.0625	43.1175	177828.0
2018-01-26 08:00:00	AAPL	Stock	43.125	43.1825	43.005	43.05	534480.0
2018-01-26 09:00:00	AAPL	Stock	43.0625	43.0775	42.6925	42.88	20223556.0
2018-01-26 10:00:00	AAPL	Stock	42.8775	42.8925	42.575	42.825	23375000.0
2018-01-26 11:00:00	AAPL	Stock	42.8275	42.835	42.6775	42.7725	13274396.0
2018-01-26 12:00:00	AAPL	Stock	42.775	42.775	42.555	42.5625	11807680.0
2018-01-26 13:00:00	AAPL	Stock	42.5625	42.785	42.515	42.77	12834696.0
2018-01-26 14:00:00	AAPL	Stock	42.7725	42.8875	42.7	42.7625	13540692.0
2018-01-26 15:00:00	AAPL	Stock	42.765	42.875	42.7125	42.8625	27217172.0
2018-01-26 16:00:00	AAPL	Stock	42.8775	42.8775	42.75	42.85	19664212.0
2018-01-26 17:00:00	AAPL	Stock	42.85	42.8775	42.83	42.85	111840.0
2018-01-26 18:00:00	AAPL	Stock	42.8625	42.875	42.8375	42.8375	73068.0
2018-01-26 19:00:00	AAPL	Stock	42.8375	42.865	42.825	42.8475	77096.0
2018-01-26 06:00:00	MSFT	Stock	92.99	93.0	92.99	92.99	2176.0
2018-01-26 07:00:00	MSFT	Stock	92.98	92.98	92.85	92.87	4865.0
2018-01-26 08:00:00	MSFT	Stock	92.9	93.05	92.52	92.99	24145.0
2018-01-26 09:00:00	MSFT	Stock	92.96	93.12	92.58	92.93	2406349.0
2018-01-26 10:00:00	MSFT	Stock	92.94	93.1	92.72	93.07	2448686.0
2018-01-26 11:00:00	MSFT	Stock	93.075	93.3	93.01	93.21	1826040.0
2018-01-26 12:00:00	MSFT	Stock	93.22	93.46	93.21	93.25	1586509.0
2018-01-26 13:00:00	MSFT	Stock	93.255	93.6	93.25	93.495	1557826.0
2018-01-26 14:00:00	MSFT	Stock	93.495	93.57	93.36	93.385	2043885.0
2018-01-26 15:00:00	MSFT	Stock	93.39	94.06	93.363	94.04	5615701.0
2018-01-26 16:00:00	MSFT	Stock	94.06	94.3	93.121	94.21	9088524.0
2018-01-26 17:00:00	MSFT	Stock	94.22	94.33	94.22	94.3	4249.0
2018-01-26 18:00:00	MSFT	Stock	94.3	94.84	94.3	94.65	21358.0
2018-01-26 19:00:00	MSFT	Stock	94.48	94.65	94.4	94.6	14771.0
2018-01-26 04:00:00	NVDA	Stock	5.95	5.9623	5.95	5.96	26400.0
2018-01-26 05:00:00	NVDA	Stock	5.95	5.9803	5.95	5.9803	69440.0
2018-01-26 06:00:00	NVDA	Stock	5.9875	5.9875	5.95	5.9575	196920.0
2018-01-26 07:00:00	NVDA	Stock	5.9588	5.9588	5.9375	5.95	380000.0
2018-01-26 08:00:00	NVDA	Stock	5.9435	5.9595	5.9435	5.9538	1291120.0
2018-01-26 09:00:00	NVDA	Stock	5.9538	5.9875	5.94	5.9668	58847680.0
2018-01-26 10:00:00	NVDA	Stock	5.967	6.0365	5.9655	6.0298	80692480.0
2018-01-26 11:00:00	NVDA	Stock	6.0282	6.0742	6.0275	6.0405	67678480.0
2018-01-26 12:00:00	NVDA	Stock	6.0415	6.0445	6.0128	6.0185	33338440.0
2018-01-26 13:00:00	NVDA	Stock	6.0192	6.057	6.018	6.055	39793520.0
2018-01-26 14:00:00	NVDA	Stock	6.0555	6.061	6.0433	6.052	30629040.0
2018-01-26 15:00:00	NVDA	Stock	6.0523	6.0835	6.0482	6.0818	73858360.0
2018-01-26 16:00:00	NVDA	Stock	6.0833	6.0858	6.068	6.0838	46683080.0
2018-01-26 17:00:00	NVDA	Stock	6.0855	6.0878	6.0833	6.0862	600160.0
2018-01-26 18:00:00	NVDA	Stock	6.0865	6.0955	6.0862	6.0875	268920.0
2018-01-26 19:00:00	NVDA	Stock	6.0875	6.0958	6.0875	6.0958	282600.0
2018-01-26 04:00:00	AMZN	Stock	69.1	69.38	69.1	69.365	8000.0
2018-01-26 05:00:00	AMZN	Stock	69.399	69.475	69.399	69.475	14000.0
2018-01-26 06:00:00	AMZN	Stock	69.508	69.675	69.5	69.65	78200.0
2018-01-26 07:00:00	AMZN	Stock	69.644	69.644	69.3755	69.5	261200.0

> showing 50 of 50,001 rows — these rows as CSV

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