PREVIEW / stock_1hour / 2020-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-27.parquet
  size:    1.2 MB
  rows:    53,178
  symbols: 2,459

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-27 04:00:00	AAPL	Stock	78.475	78.475	77.8975	78.0225	179296.0
2020-01-27 05:00:00	AAPL	Stock	78.0225	78.025	77.375	77.375	236492.0
2020-01-27 06:00:00	AAPL	Stock	77.3175	77.6875	77.1475	77.575	328880.0
2020-01-27 07:00:00	AAPL	Stock	77.6375	78.0975	77.5375	77.8125	692232.0
2020-01-27 08:00:00	AAPL	Stock	77.8	78.1	77.655	77.8125	1266076.0
2020-01-27 09:00:00	AAPL	Stock	77.805	77.9425	76.4725	77.8575	34280088.0
2020-01-27 10:00:00	AAPL	Stock	77.875	77.94	77.215	77.36	21244852.0
2020-01-27 11:00:00	AAPL	Stock	77.355	77.5125	76.8825	77.345	15488516.0
2020-01-27 12:00:00	AAPL	Stock	77.3425	77.8975	77.2775	77.795	11375732.0
2020-01-27 13:00:00	AAPL	Stock	77.795	77.9	77.525	77.5695	7412080.0
2020-01-27 14:00:00	AAPL	Stock	77.575	77.8	77.23	77.379	9887396.0
2020-01-27 15:00:00	AAPL	Stock	77.3725	77.4525	76.22	77.24	18069164.0
2020-01-27 16:00:00	AAPL	Stock	77.2425	77.26	77.1375	77.18	12191952.0
2020-01-27 17:00:00	AAPL	Stock	77.1775	77.3225	77.15	77.275	1568192.0
2020-01-27 18:00:00	AAPL	Stock	77.25	77.53	77.25	77.4425	229472.0
2020-01-27 19:00:00	AAPL	Stock	77.45	77.5	77.275	77.3125	178684.0
2020-01-27 04:00:00	MSFT	Stock	163.39	163.39	161.73	162.1	31549.0
2020-01-27 05:00:00	MSFT	Stock	161.94	161.94	161.11	161.13	20490.0
2020-01-27 06:00:00	MSFT	Stock	161.15	161.98	161.1	161.76	25629.0
2020-01-27 07:00:00	MSFT	Stock	161.72	162.17	161.51	161.85	63662.0
2020-01-27 08:00:00	MSFT	Stock	161.515	162.19	161.515	162.0	112170.0
2020-01-27 09:00:00	MSFT	Stock	162.15	162.37	160.2	162.04	4432249.0
2020-01-27 10:00:00	MSFT	Stock	162.05	162.71	161.735	162.265	3319963.0
2020-01-27 11:00:00	MSFT	Stock	162.269	163.075	162.16	162.875	2537983.0
2020-01-27 12:00:00	MSFT	Stock	162.87	163.375	162.61	162.971	1730997.0
2020-01-27 13:00:00	MSFT	Stock	162.97	163.22	162.74	162.97	1506072.0
2020-01-27 14:00:00	MSFT	Stock	162.98	163.085	162.21	162.51	1697091.0
2020-01-27 15:00:00	MSFT	Stock	162.5	162.77	162.01	162.26	3477996.0
2020-01-27 16:00:00	MSFT	Stock	162.28	162.28	162.03	162.15	7549549.0
2020-01-27 17:00:00	MSFT	Stock	162.22	162.28	162.13	162.25	604897.0
2020-01-27 18:00:00	MSFT	Stock	162.23	162.62	162.23	162.36	14442.0
2020-01-27 19:00:00	MSFT	Stock	162.5	162.67	162.34	162.43	20429.0
2020-01-27 04:00:00	NVDA	Stock	6.143	6.143	6.0458	6.046	158320.0
2020-01-27 05:00:00	NVDA	Stock	6.0388	6.0388	5.9	5.9403	793720.0
2020-01-27 06:00:00	NVDA	Stock	5.9375	5.9875	5.9208	5.9473	248720.0
2020-01-27 07:00:00	NVDA	Stock	5.968	6.0698	5.94	6.0225	2013040.0
2020-01-27 08:00:00	NVDA	Stock	6.0448	6.063	5.95	6.0333	1907400.0
2020-01-27 09:00:00	NVDA	Stock	6.0375	6.0375	5.8058	5.9883	100006160.0
2020-01-27 10:00:00	NVDA	Stock	5.993	6.015	5.9465	5.9748	74348360.0
2020-01-27 11:00:00	NVDA	Stock	5.9745	6.0038	5.9385	5.996	40390680.0
2020-01-27 12:00:00	NVDA	Stock	5.996	6.0438	5.9868	6.031	38153680.0
2020-01-27 13:00:00	NVDA	Stock	6.0303	6.0562	6.025	6.04	23787400.0
2020-01-27 14:00:00	NVDA	Stock	6.04	6.0488	5.9943	6.0081	32531440.0
2020-01-27 15:00:00	NVDA	Stock	6.009	6.0186	5.993	6.0045	57048600.0
2020-01-27 16:00:00	NVDA	Stock	6.005	6.005	5.995	5.9953	37166960.0
2020-01-27 17:00:00	NVDA	Stock	5.9998	6.005	5.9775	5.9862	786520.0
2020-01-27 18:00:00	NVDA	Stock	5.9972	5.9988	5.9775	5.9875	372440.0
2020-01-27 19:00:00	NVDA	Stock	5.9913	6.0138	5.9875	6.0	352800.0
2020-01-27 04:00:00	AMZN	Stock	92.25	92.25	91.7355	91.7355	11780.0
2020-01-27 05:00:00	AMZN	Stock	91.504	91.504	91.006	91.0515	16000.0

> showing 50 of 53,178 rows — these rows as CSV

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