PREVIEW / stock_1hour / 2019-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-03-28.parquet
  size:    1.1 MB
  rows:    50,161
  symbols: 2,639

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
2019-03-28 05:00:00	AAPL	Stock	47.1175	47.1175	47.07	47.07	4544.0
2019-03-28 06:00:00	AAPL	Stock	47.1225	47.195	47.0925	47.0925	3764.0
2019-03-28 07:00:00	AAPL	Stock	47.1575	47.1575	46.9625	47.0275	93124.0
2019-03-28 08:00:00	AAPL	Stock	47.0275	47.2375	46.915	47.07	324720.0
2019-03-28 09:00:00	AAPL	Stock	47.0825	47.3898	47.0	47.1525	10718952.0
2019-03-28 10:00:00	AAPL	Stock	47.16	47.2375	46.955	47.1275	13773040.0
2019-03-28 11:00:00	AAPL	Stock	47.1275	47.2062	46.989	47.1542	9188600.0
2019-03-28 12:00:00	AAPL	Stock	47.1525	47.2088	47.0025	47.0737	6510540.0
2019-03-28 13:00:00	AAPL	Stock	47.075	47.1238	47.0	47.03	6318784.0
2019-03-28 14:00:00	AAPL	Stock	47.03	47.0475	46.8825	46.9725	7425796.0
2019-03-28 15:00:00	AAPL	Stock	46.97	47.215	46.9525	47.1775	12210004.0
2019-03-28 16:00:00	AAPL	Stock	47.18	47.2375	47.1325	47.225	3715732.0
2019-03-28 17:00:00	AAPL	Stock	47.225	47.23	47.2	47.2	13864.0
2019-03-28 18:00:00	AAPL	Stock	47.2125	47.2525	47.2025	47.2525	25956.0
2019-03-28 19:00:00	AAPL	Stock	47.215	47.375	47.215	47.3225	116124.0
2019-03-28 04:00:00	MSFT	Stock	117.0	117.1	117.0	117.09	550.0
2019-03-28 05:00:00	MSFT	Stock	117.15	117.18	117.12	117.12	1343.0
2019-03-28 06:00:00	MSFT	Stock	117.14	117.32	117.1	117.14	6883.0
2019-03-28 07:00:00	MSFT	Stock	117.15	117.15	116.74	117.04	10652.0
2019-03-28 08:00:00	MSFT	Stock	117.14	117.36	116.8	117.2	22032.0
2019-03-28 09:00:00	MSFT	Stock	117.23	117.58	116.63	117.2	1933633.0
2019-03-28 10:00:00	MSFT	Stock	117.19	117.45	116.52	116.54	2379654.0
2019-03-28 11:00:00	MSFT	Stock	116.545	116.7	116.13	116.42	2905187.0
2019-03-28 12:00:00	MSFT	Stock	116.41	116.86	116.33	116.78	1759969.0
2019-03-28 13:00:00	MSFT	Stock	116.79	116.94	116.715	116.81	1261931.0
2019-03-28 14:00:00	MSFT	Stock	116.8	116.97	116.76	116.94	1160875.0
2019-03-28 15:00:00	MSFT	Stock	116.942	117.19	116.905	116.94	2599269.0
2019-03-28 16:00:00	MSFT	Stock	116.93	117.1	116.92	117.0	1534112.0
2019-03-28 17:00:00	MSFT	Stock	117.1	117.1	117.0	117.07	1321.0
2019-03-28 18:00:00	MSFT	Stock	117.1	117.11	117.03	117.11	1879.0
2019-03-28 19:00:00	MSFT	Stock	117.11	117.4	117.11	117.24	9610.0
2019-03-28 04:00:00	NVDA	Stock	4.4125	4.4275	4.4125	4.4275	13240.0
2019-03-28 06:00:00	NVDA	Stock	4.42	4.42	4.4165	4.4165	9600.0
2019-03-28 07:00:00	NVDA	Stock	4.4225	4.4225	4.4075	4.4125	184400.0
2019-03-28 08:00:00	NVDA	Stock	4.4138	4.432	4.4088	4.42	1066240.0
2019-03-28 09:00:00	NVDA	Stock	4.42	4.4605	4.3778	4.455	100024400.0
2019-03-28 10:00:00	NVDA	Stock	4.4553	4.4975	4.435	4.4392	96437960.0
2019-03-28 11:00:00	NVDA	Stock	4.4398	4.4405	4.385	4.4095	76147800.0
2019-03-28 12:00:00	NVDA	Stock	4.4095	4.455	4.404	4.445	46535560.0
2019-03-28 13:00:00	NVDA	Stock	4.443	4.4507	4.4308	4.4442	26804400.0
2019-03-28 14:00:00	NVDA	Stock	4.4443	4.4462	4.4245	4.432	23880240.0
2019-03-28 15:00:00	NVDA	Stock	4.4318	4.45	4.4288	4.4305	49621080.0
2019-03-28 16:00:00	NVDA	Stock	4.4312	4.44	4.4238	4.4325	1988320.0
2019-03-28 17:00:00	NVDA	Stock	4.4327	4.4373	4.4322	4.4368	118200.0
2019-03-28 18:00:00	NVDA	Stock	4.4325	4.4375	4.4325	4.4355	68320.0
2019-03-28 19:00:00	NVDA	Stock	4.4388	4.4513	4.4345	4.4475	581800.0
2019-03-28 05:00:00	AMZN	Stock	88.49	88.57	88.49	88.57	4600.0
2019-03-28 07:00:00	AMZN	Stock	88.425	88.425	88.08	88.275	129040.0
2019-03-28 08:00:00	AMZN	Stock	88.319	88.63	88.1865	88.4271	417840.0
2019-03-28 09:00:00	AMZN	Stock	88.35	88.6	87.7646	88.357	8697260.0

> showing 50 of 50,161 rows — these rows as CSV

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