PREVIEW / stock_1hour / 2018-01-12

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-12.parquet
  size:    1.1 MB
  rows:    49,788
  symbols: 2,902

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-12 04:00:00	AAPL	Stock	43.925	43.925	43.85	43.85	10920.0
2018-01-12 05:00:00	AAPL	Stock	43.85	43.85	43.85	43.85	800.0
2018-01-12 06:00:00	AAPL	Stock	43.935	43.935	43.9125	43.9125	3844.0
2018-01-12 07:00:00	AAPL	Stock	43.8875	43.985	43.86	43.9775	124936.0
2018-01-12 08:00:00	AAPL	Stock	43.875	44.15	43.875	43.9125	939212.0
2018-01-12 09:00:00	AAPL	Stock	43.92	44.0825	43.905	43.9925	12877460.0
2018-01-12 10:00:00	AAPL	Stock	43.9925	44.265	43.986	44.2025	13943400.0
2018-01-12 11:00:00	AAPL	Stock	44.205	44.24	44.07	44.1975	9690452.0
2018-01-12 12:00:00	AAPL	Stock	44.2025	44.245	44.155	44.24	5600056.0
2018-01-12 13:00:00	AAPL	Stock	44.24	44.275	44.1925	44.2525	5560632.0
2018-01-12 14:00:00	AAPL	Stock	44.251	44.3375	44.2338	44.2555	8189920.0
2018-01-12 15:00:00	AAPL	Stock	44.2575	44.34	44.1975	44.25	16200512.0
2018-01-12 16:00:00	AAPL	Stock	44.2725	44.345	44.23	44.3225	8050980.0
2018-01-12 17:00:00	AAPL	Stock	44.31	44.3375	44.2725	44.32	491452.0
2018-01-12 18:00:00	AAPL	Stock	44.3025	44.325	44.2875	44.2925	37632.0
2018-01-12 19:00:00	AAPL	Stock	44.305	44.3375	44.3	44.3375	45976.0
2018-01-12 04:00:00	MSFT	Stock	88.52	88.52	88.52	88.52	204.0
2018-01-12 06:00:00	MSFT	Stock	88.65	88.84	88.52	88.52	600.0
2018-01-12 07:00:00	MSFT	Stock	88.52	88.78	88.5	88.78	20768.0
2018-01-12 08:00:00	MSFT	Stock	88.5	88.8	88.31	88.41	38840.0
2018-01-12 09:00:00	MSFT	Stock	88.33	89.026	88.3	88.94	2713326.0
2018-01-12 10:00:00	MSFT	Stock	88.935	89.39	88.75	89.29	2976500.0
2018-01-12 11:00:00	MSFT	Stock	89.28	89.415	89.01	89.07	2069982.0
2018-01-12 12:00:00	MSFT	Stock	89.07	89.43	88.89	89.425	1945875.0
2018-01-12 13:00:00	MSFT	Stock	89.43	89.5	89.34	89.47	1828315.0
2018-01-12 14:00:00	MSFT	Stock	89.476	89.62	89.375	89.44	2176086.0
2018-01-12 15:00:00	MSFT	Stock	89.433	89.78	89.23	89.59	4992442.0
2018-01-12 16:00:00	MSFT	Stock	89.6	89.6	89.41	89.57	3553638.0
2018-01-12 17:00:00	MSFT	Stock	89.56	89.6	89.48	89.5	3565.0
2018-01-12 18:00:00	MSFT	Stock	89.5	89.5	89.5	89.5	973.0
2018-01-12 19:00:00	MSFT	Stock	89.47	89.5	89.47	89.5	1319.0
2018-01-12 05:00:00	NVDA	Stock	5.6088	5.6088	5.605	5.605	33520.0
2018-01-12 06:00:00	NVDA	Stock	5.605	5.6138	5.6	5.6138	81360.0
2018-01-12 07:00:00	NVDA	Stock	5.6188	5.6188	5.6002	5.6065	394160.0
2018-01-12 08:00:00	NVDA	Stock	5.6	5.6178	5.5628	5.5628	2414760.0
2018-01-12 09:00:00	NVDA	Stock	5.5625	5.6	5.5335	5.5605	71438040.0
2018-01-12 10:00:00	NVDA	Stock	5.561	5.62	5.5438	5.6188	69656320.0
2018-01-12 11:00:00	NVDA	Stock	5.62	5.6248	5.6	5.6135	41279280.0
2018-01-12 12:00:00	NVDA	Stock	5.6138	5.6145	5.5888	5.603	25387880.0
2018-01-12 13:00:00	NVDA	Stock	5.603	5.6068	5.5808	5.5922	20471840.0
2018-01-12 14:00:00	NVDA	Stock	5.5922	5.6058	5.585	5.5977	23342560.0
2018-01-12 15:00:00	NVDA	Stock	5.5975	5.6023	5.561	5.5673	61840960.0
2018-01-12 16:00:00	NVDA	Stock	5.5745	5.5898	5.5625	5.5723	19891880.0
2018-01-12 17:00:00	NVDA	Stock	5.567	5.5745	5.565	5.5688	392440.0
2018-01-12 18:00:00	NVDA	Stock	5.5715	5.572	5.5662	5.5678	110240.0
2018-01-12 19:00:00	NVDA	Stock	5.5688	5.5718	5.5678	5.5678	126560.0
2018-01-12 05:00:00	AMZN	Stock	64.1	64.1	64.0	64.03	35300.0
2018-01-12 06:00:00	AMZN	Stock	64.041	64.05	64.041	64.05	13640.0
2018-01-12 07:00:00	AMZN	Stock	64.05	64.1775	64.0	64.1	164880.0
2018-01-12 08:00:00	AMZN	Stock	64.11	64.174	63.65	63.658	1431880.0

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

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