PREVIEW / stock_1hour / 2018-03-14

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-14.parquet
  size:    1.1 MB
  rows:    48,688
  symbols: 2,865

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-14 04:00:00	AAPL	Stock	45.0125	45.2175	44.875	45.0525	10372.0
2018-03-14 05:00:00	AAPL	Stock	45.2225	45.225	45.2225	45.225	12800.0
2018-03-14 06:00:00	AAPL	Stock	45.21	45.225	45.1875	45.1875	8624.0
2018-03-14 07:00:00	AAPL	Stock	45.1525	45.27	45.1525	45.2475	174392.0
2018-03-14 08:00:00	AAPL	Stock	45.2325	45.2525	45.1125	45.14	434348.0
2018-03-14 09:00:00	AAPL	Stock	45.1325	45.175	44.64	44.755	17848440.0
2018-03-14 10:00:00	AAPL	Stock	44.7575	44.95	44.5775	44.755	18616600.0
2018-03-14 11:00:00	AAPL	Stock	44.7575	44.8175	44.4525	44.58	14926108.0
2018-03-14 12:00:00	AAPL	Stock	44.5825	44.7725	44.5075	44.74	10545984.0
2018-03-14 13:00:00	AAPL	Stock	44.7388	44.9075	44.625	44.8425	8585636.0
2018-03-14 14:00:00	AAPL	Stock	44.84	44.8875	44.5465	44.6625	10098420.0
2018-03-14 15:00:00	AAPL	Stock	44.6625	44.675	44.4975	44.6213	18546952.0
2018-03-14 16:00:00	AAPL	Stock	44.61	44.6525	44.5025	44.55	6862200.0
2018-03-14 17:00:00	AAPL	Stock	44.5575	44.5875	44.525	44.5775	41408.0
2018-03-14 18:00:00	AAPL	Stock	44.5625	44.6225	44.5625	44.6225	22200.0
2018-03-14 19:00:00	AAPL	Stock	44.6225	44.65	44.6	44.65	78704.0
2018-03-14 04:00:00	MSFT	Stock	94.6	94.97	94.6	94.94	1006.0
2018-03-14 05:00:00	MSFT	Stock	95.25	95.31	95.25	95.31	5752.0
2018-03-14 06:00:00	MSFT	Stock	95.31	95.31	95.1	95.1	4753.0
2018-03-14 07:00:00	MSFT	Stock	95.06	95.2	94.98	95.05	8498.0
2018-03-14 08:00:00	MSFT	Stock	95.0	95.1	94.85	94.96	30236.0
2018-03-14 09:00:00	MSFT	Stock	95.0	95.41	94.59	94.77	3299304.0
2018-03-14 10:00:00	MSFT	Stock	94.78	95.18	94.4	94.665	3348944.0
2018-03-14 11:00:00	MSFT	Stock	94.67	94.711	93.82	93.94	3952802.0
2018-03-14 12:00:00	MSFT	Stock	93.95	94.58	93.75	94.345	2189211.0
2018-03-14 13:00:00	MSFT	Stock	94.34	94.975	94.11	94.65	2356054.0
2018-03-14 14:00:00	MSFT	Stock	94.65	94.7	93.91	94.163	2802293.0
2018-03-14 15:00:00	MSFT	Stock	94.17	94.39	93.5	93.85	5835971.0
2018-03-14 16:00:00	MSFT	Stock	93.85	93.9	93.7	93.7	5358235.0
2018-03-14 17:00:00	MSFT	Stock	93.7	93.85	93.6	93.84	148020.0
2018-03-14 18:00:00	MSFT	Stock	93.84	93.84	93.84	93.84	268.0
2018-03-14 19:00:00	MSFT	Stock	93.84	93.95	93.82	93.85	3648.0
2018-03-14 04:00:00	NVDA	Stock	6.175	6.2448	6.175	6.2448	12800.0
2018-03-14 05:00:00	NVDA	Stock	6.2468	6.2468	6.2468	6.2468	10000.0
2018-03-14 06:00:00	NVDA	Stock	6.2418	6.2475	6.2275	6.2275	43640.0
2018-03-14 07:00:00	NVDA	Stock	6.2252	6.2488	6.2145	6.2478	756160.0
2018-03-14 08:00:00	NVDA	Stock	6.2415	6.248	6.2148	6.2338	1836240.0
2018-03-14 09:00:00	NVDA	Stock	6.232	6.244	6.1562	6.1844	72448240.0
2018-03-14 10:00:00	NVDA	Stock	6.1873	6.2638	6.178	6.2552	94342800.0
2018-03-14 11:00:00	NVDA	Stock	6.2552	6.257	6.165	6.1678	66699840.0
2018-03-14 12:00:00	NVDA	Stock	6.1679	6.2138	6.1555	6.2013	60357560.0
2018-03-14 13:00:00	NVDA	Stock	6.2018	6.2335	6.1778	6.2208	38018080.0
2018-03-14 14:00:00	NVDA	Stock	6.2218	6.2355	6.1855	6.2028	27344880.0
2018-03-14 15:00:00	NVDA	Stock	6.2058	6.2188	6.173	6.2185	49908120.0
2018-03-14 16:00:00	NVDA	Stock	6.2185	6.2185	6.178	6.2095	67802400.0
2018-03-14 17:00:00	NVDA	Stock	6.2068	6.2072	6.2038	6.205	28000.0
2018-03-14 18:00:00	NVDA	Stock	6.205	6.218	6.205	6.218	390520.0
2018-03-14 19:00:00	NVDA	Stock	6.2188	6.228	6.215	6.2175	557800.0
2018-03-14 04:00:00	AMZN	Stock	79.9965	79.997	79.95	79.997	7060.0
2018-03-14 05:00:00	AMZN	Stock	80.043	80.1895	80.043	80.099	20520.0

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

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