PREVIEW / stock_1hour / 2017-06-30

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-06-30.parquet
  size:    1.0 MB
  rows:    47,793
  symbols: 3,010

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-30 05:00:00	AAPL	Stock	35.9875	35.9875	35.9875	35.9875	6968.0
2017-06-30 06:00:00	AAPL	Stock	36.0475	36.09	36.0225	36.09	9352.0
2017-06-30 07:00:00	AAPL	Stock	36.0675	36.145	36.0625	36.0675	104220.0
2017-06-30 08:00:00	AAPL	Stock	36.1125	36.145	35.86	35.9	343644.0
2017-06-30 09:00:00	AAPL	Stock	35.9	36.4225	35.8775	36.1075	17588472.0
2017-06-30 10:00:00	AAPL	Stock	36.107	36.1352	35.945	36.085	11293312.0
2017-06-30 11:00:00	AAPL	Stock	36.085	36.1825	36.03	36.1675	7099880.0
2017-06-30 12:00:00	AAPL	Stock	36.1675	36.1775	36.025	36.05	5208992.0
2017-06-30 13:00:00	AAPL	Stock	36.05	36.1625	36.05	36.1312	4137420.0
2017-06-30 14:00:00	AAPL	Stock	36.13	36.185	36.08	36.1765	5690528.0
2017-06-30 15:00:00	AAPL	Stock	36.1775	36.2175	36.0	36.0075	16182728.0
2017-06-30 16:00:00	AAPL	Stock	36.0075	36.05	36.005	36.025	11539844.0
2017-06-30 17:00:00	AAPL	Stock	36.02	36.02	35.9875	36.005	70136.0
2017-06-30 18:00:00	AAPL	Stock	36.0025	36.015	35.9775	36.015	9896.0
2017-06-30 19:00:00	AAPL	Stock	36.0	36.005	35.9625	35.9625	11032.0
2017-06-30 04:00:00	MSFT	Stock	68.4	68.4	68.4	68.4	1400.0
2017-06-30 05:00:00	MSFT	Stock	68.65	68.65	68.65	68.65	100.0
2017-06-30 06:00:00	MSFT	Stock	68.69	68.8	68.69	68.79	3375.0
2017-06-30 07:00:00	MSFT	Stock	68.62	68.84	68.61	68.65	12575.0
2017-06-30 08:00:00	MSFT	Stock	68.66	68.71	68.42	68.46	21460.0
2017-06-30 09:00:00	MSFT	Stock	68.5	69.38	68.4	69.07	5351488.0
2017-06-30 10:00:00	MSFT	Stock	69.075	69.16	68.74	69.01	2458863.0
2017-06-30 11:00:00	MSFT	Stock	69.01	69.02	68.78	68.96	1976976.0
2017-06-30 12:00:00	MSFT	Stock	68.95	69.1	68.91	69.091	1321754.0
2017-06-30 13:00:00	MSFT	Stock	69.095	69.24	69.095	69.225	856814.0
2017-06-30 14:00:00	MSFT	Stock	69.23	69.35	69.21	69.27	2059649.0
2017-06-30 15:00:00	MSFT	Stock	69.27	69.3	68.91	68.94	3986787.0
2017-06-30 16:00:00	MSFT	Stock	68.93	69.05	68.92	68.93	3890745.0
2017-06-30 17:00:00	MSFT	Stock	68.93	69.01	68.93	69.01	344.0
2017-06-30 18:00:00	MSFT	Stock	69.02	69.02	68.93	68.93	680.0
2017-06-30 19:00:00	MSFT	Stock	68.94	68.97	68.94	68.96	400.0
2017-06-30 04:00:00	NVDA	Stock	3.667	3.667	3.625	3.6575	205400.0
2017-06-30 05:00:00	NVDA	Stock	3.677	3.695	3.677	3.695	49440.0
2017-06-30 06:00:00	NVDA	Stock	3.6875	3.7088	3.68	3.6925	313760.0
2017-06-30 07:00:00	NVDA	Stock	3.7	3.7	3.688	3.69	443680.0
2017-06-30 08:00:00	NVDA	Stock	3.69	3.6998	3.6562	3.6665	4351760.0
2017-06-30 09:00:00	NVDA	Stock	3.6708	3.6982	3.609	3.617	120784480.0
2017-06-30 10:00:00	NVDA	Stock	3.6172	3.669	3.5875	3.659	175924120.0
2017-06-30 11:00:00	NVDA	Stock	3.66	3.6615	3.6228	3.6472	80279840.0
2017-06-30 12:00:00	NVDA	Stock	3.646	3.6483	3.6265	3.6311	32757280.0
2017-06-30 13:00:00	NVDA	Stock	3.6312	3.6478	3.6275	3.6356	37472200.0
2017-06-30 14:00:00	NVDA	Stock	3.6355	3.66	3.631	3.655	45489400.0
2017-06-30 15:00:00	NVDA	Stock	3.6545	3.6618	3.61	3.6142	106347160.0
2017-06-30 16:00:00	NVDA	Stock	3.6148	3.6263	3.614	3.6235	51461880.0
2017-06-30 17:00:00	NVDA	Stock	3.6248	3.6263	3.622	3.625	843800.0
2017-06-30 18:00:00	NVDA	Stock	3.6228	3.6248	3.6188	3.6222	232080.0
2017-06-30 19:00:00	NVDA	Stock	3.6188	3.6225	3.6165	3.6193	478120.0
2017-06-30 04:00:00	AMZN	Stock	48.75	48.75	48.75	48.75	2000.0
2017-06-30 05:00:00	AMZN	Stock	48.9975	48.9975	48.9975	48.9975	2000.0
2017-06-30 06:00:00	AMZN	Stock	49.025	49.025	49.021	49.021	10000.0

> showing 50 of 47,793 rows — these rows as CSV

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