PREVIEW / stock_1hour / 2018-05-25

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-05-25.parquet
  size:    1.1 MB
  rows:    48,436
  symbols: 2,822

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-05-25 04:00:00	AAPL	Stock	47.195	47.2625	47.195	47.2225	4264.0
2018-05-25 06:00:00	AAPL	Stock	47.165	47.165	47.165	47.165	400.0
2018-05-25 07:00:00	AAPL	Stock	47.21	47.215	47.0375	47.075	96336.0
2018-05-25 08:00:00	AAPL	Stock	47.125	47.2198	47.0175	47.0275	133336.0
2018-05-25 09:00:00	AAPL	Stock	47.0375	47.185	46.9125	47.1135	7931684.0
2018-05-25 10:00:00	AAPL	Stock	47.1128	47.3725	47.085	47.335	14362604.0
2018-05-25 11:00:00	AAPL	Stock	47.3325	47.4125	47.2675	47.3475	7226656.0
2018-05-25 12:00:00	AAPL	Stock	47.3475	47.3975	47.27	47.3635	5609184.0
2018-05-25 13:00:00	AAPL	Stock	47.361	47.405	47.195	47.215	5141352.0
2018-05-25 14:00:00	AAPL	Stock	47.2125	47.2475	47.085	47.1548	5092020.0
2018-05-25 15:00:00	AAPL	Stock	47.155	47.19	47.08	47.145	9561264.0
2018-05-25 16:00:00	AAPL	Stock	47.145	47.16	47.011	47.15	6617812.0
2018-05-25 17:00:00	AAPL	Stock	47.1725	47.175	47.145	47.155	25380.0
2018-05-25 18:00:00	AAPL	Stock	47.1575	47.175	47.1575	47.175	23940.0
2018-05-25 19:00:00	AAPL	Stock	47.1825	47.1825	47.1675	47.1825	10512.0
2018-05-25 04:00:00	MSFT	Stock	98.7	98.88	98.7	98.88	868.0
2018-05-25 06:00:00	MSFT	Stock	98.82	98.88	98.79	98.79	650.0
2018-05-25 07:00:00	MSFT	Stock	98.65	98.75	98.41	98.45	15941.0
2018-05-25 08:00:00	MSFT	Stock	98.68	98.68	98.15	98.2	26173.0
2018-05-25 09:00:00	MSFT	Stock	98.17	98.645	97.86	98.23	1893681.0
2018-05-25 10:00:00	MSFT	Stock	98.22	98.88	98.12	98.69	2911706.0
2018-05-25 11:00:00	MSFT	Stock	98.7	98.98	98.54	98.79	1844146.0
2018-05-25 12:00:00	MSFT	Stock	98.78	98.84	98.44	98.515	1578680.0
2018-05-25 13:00:00	MSFT	Stock	98.51	98.626	98.3	98.36	1061541.0
2018-05-25 14:00:00	MSFT	Stock	98.354	98.6	98.29	98.32	1361196.0
2018-05-25 15:00:00	MSFT	Stock	98.315	98.46	98.21	98.38	3464208.0
2018-05-25 16:00:00	MSFT	Stock	98.38	98.38	98.13	98.36	2121539.0
2018-05-25 17:00:00	MSFT	Stock	98.36	98.36	98.36	98.36	1083.0
2018-05-25 18:00:00	MSFT	Stock	98.36	98.36	98.36	98.36	100.0
2018-05-25 19:00:00	MSFT	Stock	98.35	98.39	98.35	98.39	358.0
2018-05-25 04:00:00	NVDA	Stock	6.2248	6.2248	6.2248	6.2248	8000.0
2018-05-25 05:00:00	NVDA	Stock	6.2215	6.2215	6.2215	6.2215	4000.0
2018-05-25 06:00:00	NVDA	Stock	6.2238	6.2323	6.2238	6.225	190600.0
2018-05-25 07:00:00	NVDA	Stock	6.2188	6.22	6.1858	6.19	331520.0
2018-05-25 08:00:00	NVDA	Stock	6.2135	6.217	6.1862	6.1888	1045520.0
2018-05-25 09:00:00	NVDA	Stock	6.188	6.2288	6.169	6.22	44900320.0
2018-05-25 10:00:00	NVDA	Stock	6.2195	6.2485	6.1998	6.2153	46962760.0
2018-05-25 11:00:00	NVDA	Stock	6.2159	6.227	6.2075	6.2133	21411480.0
2018-05-25 12:00:00	NVDA	Stock	6.2142	6.2378	6.208	6.2348	25167760.0
2018-05-25 13:00:00	NVDA	Stock	6.2353	6.2462	6.22	6.222	25354000.0
2018-05-25 14:00:00	NVDA	Stock	6.2205	6.227	6.2063	6.2133	18485680.0
2018-05-25 15:00:00	NVDA	Stock	6.2135	6.2355	6.2053	6.2323	50094120.0
2018-05-25 16:00:00	NVDA	Stock	6.232	6.232	6.2252	6.2275	20397800.0
2018-05-25 17:00:00	NVDA	Stock	6.225	6.2318	6.225	6.2262	101360.0
2018-05-25 18:00:00	NVDA	Stock	6.2318	6.2318	6.2265	6.2265	30320.0
2018-05-25 19:00:00	NVDA	Stock	6.232	6.232	6.225	6.226	56920.0
2018-05-25 04:00:00	AMZN	Stock	80.25	80.25	80.25	80.25	2000.0
2018-05-25 05:00:00	AMZN	Stock	80.4375	80.4375	80.4375	80.4375	2000.0
2018-05-25 07:00:00	AMZN	Stock	80.3995	80.4	80.089	80.125	100140.0
2018-05-25 08:00:00	AMZN	Stock	80.4	80.4	80.0555	80.0635	125320.0

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

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