PREVIEW / stock_1hour / 2017-06-01

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-01.parquet
  size:    1.1 MB
  rows:    49,012
  symbols: 3,042

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
2017-06-01 04:00:00	AAPL	Stock	38.25	38.425	38.25	38.425	14000.0
2017-06-01 05:00:00	AAPL	Stock	38.35	38.35	38.35	38.35	5380.0
2017-06-01 07:00:00	AAPL	Stock	38.345	38.345	38.2875	38.2875	14988.0
2017-06-01 08:00:00	AAPL	Stock	38.3225	38.3475	38.19	38.2675	272924.0
2017-06-01 09:00:00	AAPL	Stock	38.315	38.3325	38.19	38.21	7978308.0
2017-06-01 10:00:00	AAPL	Stock	38.21	38.25	38.055	38.1488	10295868.0
2017-06-01 11:00:00	AAPL	Stock	38.1525	38.235	38.1425	38.2262	6281996.0
2017-06-01 12:00:00	AAPL	Stock	38.226	38.275	38.1875	38.2375	4619608.0
2017-06-01 13:00:00	AAPL	Stock	38.2375	38.2875	38.22	38.2425	5670340.0
2017-06-01 14:00:00	AAPL	Stock	38.2425	38.2585	38.1725	38.1925	5378532.0
2017-06-01 15:00:00	AAPL	Stock	38.1875	38.3025	38.175	38.295	11656048.0
2017-06-01 16:00:00	AAPL	Stock	38.2975	38.31	38.23	38.275	4575604.0
2017-06-01 17:00:00	AAPL	Stock	38.2775	38.295	38.2375	38.2925	178904.0
2017-06-01 18:00:00	AAPL	Stock	38.28	38.295	38.2675	38.2875	26444.0
2017-06-01 19:00:00	AAPL	Stock	38.2875	38.295	38.2875	38.295	13052.0
2017-06-01 04:00:00	MSFT	Stock	70.1	70.3	70.1	70.3	1508.0
2017-06-01 05:00:00	MSFT	Stock	70.3	70.3	70.3	70.3	2501.0
2017-06-01 06:00:00	MSFT	Stock	70.11	70.11	70.11	70.11	550.0
2017-06-01 08:00:00	MSFT	Stock	69.84	70.24	69.84	70.15	37948.0
2017-06-01 09:00:00	MSFT	Stock	70.16	70.61	69.8	69.86	3522913.0
2017-06-01 10:00:00	MSFT	Stock	69.86	69.93	69.451	69.57	3832942.0
2017-06-01 11:00:00	MSFT	Stock	69.57	69.815	69.55	69.81	1684346.0
2017-06-01 12:00:00	MSFT	Stock	69.81	69.87	69.72	69.84	1859420.0
2017-06-01 13:00:00	MSFT	Stock	69.84	69.89	69.65	69.705	1592212.0
2017-06-01 14:00:00	MSFT	Stock	69.7	69.879	69.695	69.71	1495395.0
2017-06-01 15:00:00	MSFT	Stock	69.71	70.15	69.71	70.12	3533416.0
2017-06-01 16:00:00	MSFT	Stock	70.11	70.13	69.97	69.99	2056047.0
2017-06-01 17:00:00	MSFT	Stock	70.1	70.1	70.1	70.1	36694.0
2017-06-01 18:00:00	MSFT	Stock	70.1	70.1	70.0	70.0	1440.0
2017-06-01 19:00:00	MSFT	Stock	70.14	70.14	70.14	70.14	600.0
2017-06-01 04:00:00	NVDA	Stock	3.6225	3.6265	3.6225	3.6265	58000.0
2017-06-01 05:00:00	NVDA	Stock	3.6263	3.6325	3.6263	3.6325	8000.0
2017-06-01 06:00:00	NVDA	Stock	3.6325	3.6485	3.6275	3.6298	142840.0
2017-06-01 07:00:00	NVDA	Stock	3.6335	3.635	3.6188	3.6188	210520.0
2017-06-01 08:00:00	NVDA	Stock	3.635	3.6438	3.6125	3.6225	1881320.0
2017-06-01 09:00:00	NVDA	Stock	3.6225	3.6258	3.5775	3.5782	91107800.0
2017-06-01 10:00:00	NVDA	Stock	3.58	3.59	3.563	3.5847	107302440.0
2017-06-01 11:00:00	NVDA	Stock	3.5852	3.6062	3.5817	3.6029	58991480.0
2017-06-01 12:00:00	NVDA	Stock	3.603	3.6092	3.5943	3.5948	34750680.0
2017-06-01 13:00:00	NVDA	Stock	3.5943	3.6005	3.5918	3.5988	23903520.0
2017-06-01 14:00:00	NVDA	Stock	3.5986	3.6078	3.5894	3.593	43199480.0
2017-06-01 15:00:00	NVDA	Stock	3.593	3.6088	3.5924	3.6088	81626240.0
2017-06-01 16:00:00	NVDA	Stock	3.609	3.618	3.6075	3.615	19952080.0
2017-06-01 17:00:00	NVDA	Stock	3.6168	3.6182	3.613	3.6163	548160.0
2017-06-01 18:00:00	NVDA	Stock	3.618	3.6225	3.615	3.6225	2307960.0
2017-06-01 19:00:00	NVDA	Stock	3.6175	3.6212	3.6095	3.6125	382880.0
2017-06-01 04:00:00	AMZN	Stock	49.925	49.925	49.925	49.925	4000.0
2017-06-01 07:00:00	AMZN	Stock	49.8945	49.8945	49.85	49.8555	30740.0
2017-06-01 08:00:00	AMZN	Stock	49.78	49.897	49.731	49.731	145940.0
2017-06-01 09:00:00	AMZN	Stock	49.85	49.95	49.6285	49.7464	6849880.0

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

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