PREVIEW / stock_1hour / 2018-11-13

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-11-13.parquet
  size:    1.1 MB
  rows:    49,836
  symbols: 2,744

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-11-13 04:00:00	AAPL	Stock	48.795	48.795	48.45	48.45	36388.0
2018-11-13 05:00:00	AAPL	Stock	48.475	48.56	48.4125	48.5375	35600.0
2018-11-13 06:00:00	AAPL	Stock	48.56	48.6975	48.5	48.545	134176.0
2018-11-13 07:00:00	AAPL	Stock	48.545	48.58	48.225	48.2725	382020.0
2018-11-13 08:00:00	AAPL	Stock	48.5625	48.6095	47.875	48.005	1582236.0
2018-11-13 09:00:00	AAPL	Stock	47.9925	48.805	47.795	48.0445	33517848.0
2018-11-13 10:00:00	AAPL	Stock	48.035	48.97	47.8975	48.8825	32684248.0
2018-11-13 11:00:00	AAPL	Stock	48.8888	49.295	48.6308	48.68	21092864.0
2018-11-13 12:00:00	AAPL	Stock	48.6925	48.81	48.375	48.45	12295512.0
2018-11-13 13:00:00	AAPL	Stock	48.445	48.7325	48.3925	48.4705	9654524.0
2018-11-13 14:00:00	AAPL	Stock	48.4688	48.49	48.1425	48.265	11147076.0
2018-11-13 15:00:00	AAPL	Stock	48.265	48.445	47.9825	48.0575	23080628.0
2018-11-13 16:00:00	AAPL	Stock	48.0575	48.4692	48.0075	48.2	8761656.0
2018-11-13 17:00:00	AAPL	Stock	48.2375	48.2375	48.0575	48.2	86488.0
2018-11-13 18:00:00	AAPL	Stock	48.205	48.3875	48.1975	48.35	226808.0
2018-11-13 19:00:00	AAPL	Stock	48.325	48.3875	48.325	48.375	116008.0
2018-11-13 04:00:00	MSFT	Stock	107.6	107.6	107.6	107.6	867.0
2018-11-13 05:00:00	MSFT	Stock	107.33	107.6	107.33	107.6	1239.0
2018-11-13 06:00:00	MSFT	Stock	107.77	107.77	107.77	107.77	2741.0
2018-11-13 07:00:00	MSFT	Stock	107.9	107.97	107.6	107.6	14047.0
2018-11-13 08:00:00	MSFT	Stock	107.9	107.95	107.32	107.47	24625.0
2018-11-13 09:00:00	MSFT	Stock	107.49	108.57	107.32	107.77	3254593.0
2018-11-13 10:00:00	MSFT	Stock	107.77	108.33	107.05	107.93	5508866.0
2018-11-13 11:00:00	MSFT	Stock	107.92	108.74	107.89	108.065	3868506.0
2018-11-13 12:00:00	MSFT	Stock	108.08	108.28	107.33	107.67	2478217.0
2018-11-13 13:00:00	MSFT	Stock	107.678	108.03	107.425	107.59	2440625.0
2018-11-13 14:00:00	MSFT	Stock	107.59	107.66	106.88	107.1	3026354.0
2018-11-13 15:00:00	MSFT	Stock	107.1	107.54	106.64	106.94	6615766.0
2018-11-13 16:00:00	MSFT	Stock	106.94	107.2	106.77	106.94	5583103.0
2018-11-13 17:00:00	MSFT	Stock	107.26	107.295	106.94	107.295	5814.0
2018-11-13 18:00:00	MSFT	Stock	107.3	107.8	107.14	107.6	8299.0
2018-11-13 19:00:00	MSFT	Stock	107.6	107.72	107.6	107.71	4018.0
2018-11-13 04:00:00	NVDA	Stock	4.7915	4.7925	4.7915	4.7925	38800.0
2018-11-13 05:00:00	NVDA	Stock	4.7925	4.8042	4.7848	4.8042	107600.0
2018-11-13 06:00:00	NVDA	Stock	4.8168	4.8553	4.813	4.8355	162000.0
2018-11-13 07:00:00	NVDA	Stock	4.8498	4.8575	4.795	4.7975	1238800.0
2018-11-13 08:00:00	NVDA	Stock	4.8438	4.8562	4.7883	4.825	3634560.0
2018-11-13 09:00:00	NVDA	Stock	4.8263	4.965	4.8125	4.8668	105079920.0
2018-11-13 10:00:00	NVDA	Stock	4.8695	5.0118	4.8392	4.9853	129237520.0
2018-11-13 11:00:00	NVDA	Stock	4.9888	5.1053	4.9875	5.0124	105601520.0
2018-11-13 12:00:00	NVDA	Stock	5.0123	5.0612	4.9848	5.0131	46938040.0
2018-11-13 13:00:00	NVDA	Stock	5.0124	5.036	4.9758	5.0088	33977600.0
2018-11-13 14:00:00	NVDA	Stock	5.0093	5.018	4.9215	4.958	46180440.0
2018-11-13 15:00:00	NVDA	Stock	4.9575	5.0125	4.95	4.9833	79377000.0
2018-11-13 16:00:00	NVDA	Stock	4.9833	5.0063	4.975	5.0	23031760.0
2018-11-13 17:00:00	NVDA	Stock	5.0	5.0045	4.9825	5.0042	470520.0
2018-11-13 18:00:00	NVDA	Stock	5.0045	5.0995	5.0045	5.085	1874640.0
2018-11-13 19:00:00	NVDA	Stock	5.087	5.1088	5.0825	5.1088	811480.0
2018-11-13 04:00:00	AMZN	Stock	82.447	82.6	82.3605	82.3605	33520.0
2018-11-13 05:00:00	AMZN	Stock	82.295	82.35	82.295	82.35	7060.0

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

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