PREVIEW / stock_1hour / 2018-01-03

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-03.parquet
  size:    1.1 MB
  rows:    49,986
  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-03 04:00:00	AAPL	Stock	43.165	43.165	43.165	43.165	2880.0
2018-01-03 05:00:00	AAPL	Stock	43.165	43.165	43.165	43.165	400.0
2018-01-03 06:00:00	AAPL	Stock	43.1975	43.1975	43.1875	43.1875	21008.0
2018-01-03 07:00:00	AAPL	Stock	43.1875	43.1875	43.125	43.1375	94112.0
2018-01-03 08:00:00	AAPL	Stock	43.1375	43.1625	43.105	43.125	203600.0
2018-01-03 09:00:00	AAPL	Stock	43.1375	43.475	43.045	43.4662	15978728.0
2018-01-03 10:00:00	AAPL	Stock	43.4725	43.6375	43.44	43.5375	17636752.0
2018-01-03 11:00:00	AAPL	Stock	43.54	43.5725	43.375	43.415	11400940.0
2018-01-03 12:00:00	AAPL	Stock	43.4175	43.4325	43.305	43.33	8223236.0
2018-01-03 13:00:00	AAPL	Stock	43.3325	43.3725	43.2325	43.243	7336372.0
2018-01-03 14:00:00	AAPL	Stock	43.245	43.2712	43.0825	43.0975	10064168.0
2018-01-03 15:00:00	AAPL	Stock	43.0962	43.1475	42.99	43.045	22320200.0
2018-01-03 16:00:00	AAPL	Stock	43.0625	43.0625	42.9775	42.9975	8968916.0
2018-01-03 17:00:00	AAPL	Stock	42.9975	43.035	42.985	43.0175	145928.0
2018-01-03 18:00:00	AAPL	Stock	43.025	43.03	42.985	43.0	113104.0
2018-01-03 19:00:00	AAPL	Stock	43.0	43.0175	42.99	43.0	73208.0
2018-01-03 04:00:00	MSFT	Stock	86.3	86.3	86.3	86.3	620.0
2018-01-03 07:00:00	MSFT	Stock	86.01	86.1	85.97	86.05	5878.0
2018-01-03 08:00:00	MSFT	Stock	86.3	86.3	85.85	86.0	16795.0
2018-01-03 09:00:00	MSFT	Stock	85.9	86.505	85.86	86.43	3292850.0
2018-01-03 10:00:00	MSFT	Stock	86.43	86.51	86.21	86.225	2653636.0
2018-01-03 11:00:00	MSFT	Stock	86.225	86.36	86.18	86.29	1802915.0
2018-01-03 12:00:00	MSFT	Stock	86.285	86.45	86.06	86.38	2267305.0
2018-01-03 13:00:00	MSFT	Stock	86.385	86.43	86.22	86.27	2130698.0
2018-01-03 14:00:00	MSFT	Stock	86.27	86.41	86.2	86.4	1834447.0
2018-01-03 15:00:00	MSFT	Stock	86.4	86.47	86.25	86.33	4249487.0
2018-01-03 16:00:00	MSFT	Stock	86.35	86.44	86.28	86.35	3456428.0
2018-01-03 17:00:00	MSFT	Stock	86.4	86.43	86.25	86.3	2142.0
2018-01-03 18:00:00	MSFT	Stock	86.35	86.44	86.35	86.44	4514.0
2018-01-03 19:00:00	MSFT	Stock	86.43	86.44	86.43	86.44	1250.0
2018-01-03 04:00:00	NVDA	Stock	5.085	5.085	5.075	5.075	8000.0
2018-01-03 06:00:00	NVDA	Stock	5.072	5.075	5.0712	5.0712	145400.0
2018-01-03 07:00:00	NVDA	Stock	5.0625	5.07	5.0355	5.064	1958480.0
2018-01-03 08:00:00	NVDA	Stock	5.0646	5.1288	5.0413	5.1193	10189200.0
2018-01-03 09:00:00	NVDA	Stock	5.1175	5.1888	5.0938	5.1822	172178560.0
2018-01-03 10:00:00	NVDA	Stock	5.1835	5.2388	5.1725	5.2376	144811560.0
2018-01-03 11:00:00	NVDA	Stock	5.2373	5.2488	5.2115	5.2283	90136760.0
2018-01-03 12:00:00	NVDA	Stock	5.2278	5.2998	5.2265	5.2798	100506600.0
2018-01-03 13:00:00	NVDA	Stock	5.2808	5.2875	5.261	5.2792	63427760.0
2018-01-03 14:00:00	NVDA	Stock	5.2795	5.3425	5.2765	5.3155	107641120.0
2018-01-03 15:00:00	NVDA	Stock	5.3161	5.3228	5.258	5.3125	146308280.0
2018-01-03 16:00:00	NVDA	Stock	5.3118	5.4718	5.2428	5.3425	11979880.0
2018-01-03 17:00:00	NVDA	Stock	5.3413	5.3623	5.3375	5.34	1596000.0
2018-01-03 18:00:00	NVDA	Stock	5.34	5.3585	5.3388	5.345	1894280.0
2018-01-03 19:00:00	NVDA	Stock	5.3388	5.3475	5.3263	5.333	1917320.0
2018-01-03 06:00:00	AMZN	Stock	59.4385	59.4385	59.4385	59.4385	3500.0
2018-01-03 07:00:00	AMZN	Stock	59.345	59.35	59.345	59.35	22360.0
2018-01-03 08:00:00	AMZN	Stock	59.35	59.4	59.35	59.375	64280.0
2018-01-03 09:00:00	AMZN	Stock	59.333	59.901	59.3325	59.895	8859180.0
2018-01-03 10:00:00	AMZN	Stock	59.872	59.962	59.7405	59.95	5613800.0

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

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