PREVIEW / stock_1hour / 2020-01-13

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-13.parquet
  size:    1.2 MB
  rows:    51,900
  symbols: 2,468

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
2020-01-13 04:00:00	AAPL	Stock	77.8825	77.9875	77.875	77.975	54956.0
2020-01-13 05:00:00	AAPL	Stock	77.975	78.0	77.9125	78.0	50960.0
2020-01-13 06:00:00	AAPL	Stock	77.9875	78.125	77.9125	77.915	99612.0
2020-01-13 07:00:00	AAPL	Stock	77.925	78.0375	77.8425	77.8875	290816.0
2020-01-13 08:00:00	AAPL	Stock	77.9875	78.0477	77.85	77.853	599136.0
2020-01-13 09:00:00	AAPL	Stock	77.8525	78.345	77.8375	78.23	19098688.0
2020-01-13 10:00:00	AAPL	Stock	78.235	78.2575	77.7875	78.0208	15711440.0
2020-01-13 11:00:00	AAPL	Stock	78.0225	78.34	77.85	78.1975	11862964.0
2020-01-13 12:00:00	AAPL	Stock	78.195	78.33	78.1125	78.2825	9251284.0
2020-01-13 13:00:00	AAPL	Stock	78.2825	78.4475	78.215	78.405	7981236.0
2020-01-13 14:00:00	AAPL	Stock	78.3905	78.745	78.3275	78.7325	12086760.0
2020-01-13 15:00:00	AAPL	Stock	78.7325	79.2675	78.6575	79.2425	19601640.0
2020-01-13 16:00:00	AAPL	Stock	79.24	79.3725	79.2375	79.315	7742588.0
2020-01-13 17:00:00	AAPL	Stock	79.3125	79.3975	79.24	79.385	169252.0
2020-01-13 18:00:00	AAPL	Stock	79.375	79.5575	79.375	79.5	151432.0
2020-01-13 19:00:00	AAPL	Stock	79.5375	79.7	79.5075	79.695	353100.0
2020-01-13 04:00:00	MSFT	Stock	161.98	162.5	161.98	162.5	11727.0
2020-01-13 05:00:00	MSFT	Stock	162.5	162.57	162.37	162.37	4242.0
2020-01-13 06:00:00	MSFT	Stock	162.47	162.51	162.15	162.2	3543.0
2020-01-13 07:00:00	MSFT	Stock	162.19	162.33	162.04	162.2	21794.0
2020-01-13 08:00:00	MSFT	Stock	162.2	162.4	162.039	162.27	36213.0
2020-01-13 09:00:00	MSFT	Stock	162.22	162.3	161.49	161.93	2417840.0
2020-01-13 10:00:00	MSFT	Stock	161.93	162.015	161.26	161.54	2044616.0
2020-01-13 11:00:00	MSFT	Stock	161.55	162.18	161.479	162.175	1974346.0
2020-01-13 12:00:00	MSFT	Stock	162.19	162.58	162.15	162.55	1357426.0
2020-01-13 13:00:00	MSFT	Stock	162.556	162.87	162.48	162.73	1165460.0
2020-01-13 14:00:00	MSFT	Stock	162.735	163.06	162.69	162.88	1230802.0
2020-01-13 15:00:00	MSFT	Stock	162.89	163.31	162.8	163.28	2670826.0
2020-01-13 16:00:00	MSFT	Stock	163.28	163.4	163.2	163.39	4049128.0
2020-01-13 17:00:00	MSFT	Stock	163.31	163.55	163.1	163.33	20380.0
2020-01-13 18:00:00	MSFT	Stock	163.28	163.44	163.26	163.34	2867.0
2020-01-13 19:00:00	MSFT	Stock	163.44	163.8	163.44	163.7	4294.0
2020-01-13 04:00:00	NVDA	Stock	6.1722	6.1738	6.1518	6.1518	26000.0
2020-01-13 05:00:00	NVDA	Stock	6.1663	6.1873	6.1625	6.1873	99120.0
2020-01-13 06:00:00	NVDA	Stock	6.185	6.185	6.1663	6.1663	101760.0
2020-01-13 07:00:00	NVDA	Stock	6.1618	6.2025	6.1548	6.1925	1273880.0
2020-01-13 08:00:00	NVDA	Stock	6.1625	6.2058	6.1525	6.185	1212840.0
2020-01-13 09:00:00	NVDA	Stock	6.1928	6.2453	6.1688	6.2392	51017560.0
2020-01-13 10:00:00	NVDA	Stock	6.2382	6.2656	6.2268	6.2531	55461800.0
2020-01-13 11:00:00	NVDA	Stock	6.2533	6.2804	6.248	6.2803	25224680.0
2020-01-13 12:00:00	NVDA	Stock	6.28	6.2853	6.2688	6.275	21773560.0
2020-01-13 13:00:00	NVDA	Stock	6.2747	6.3055	6.2738	6.3025	25846400.0
2020-01-13 14:00:00	NVDA	Stock	6.304	6.3247	6.295	6.3118	24990840.0
2020-01-13 15:00:00	NVDA	Stock	6.311	6.3203	6.2855	6.2995	50105000.0
2020-01-13 16:00:00	NVDA	Stock	6.2995	6.3038	6.294	6.3	22914680.0
2020-01-13 17:00:00	NVDA	Stock	6.2971	6.312	6.297	6.3085	415200.0
2020-01-13 18:00:00	NVDA	Stock	6.3088	6.3125	6.2995	6.31	8264640.0
2020-01-13 19:00:00	NVDA	Stock	6.31	6.3223	6.31	6.32	350960.0
2020-01-13 04:00:00	AMZN	Stock	94.478	94.478	94.478	94.478	7540.0
2020-01-13 05:00:00	AMZN	Stock	94.467	94.467	94.467	94.467	5780.0

> showing 50 of 51,900 rows — these rows as CSV

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