PREVIEW / stock_1hour / 2020-01-15

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-01-15.parquet
  size:    1.2 MB
  rows:    51,431
  symbols: 2,474

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-15 04:00:00	AAPL	Stock	77.9725	77.995	77.72	77.89	61624.0
2020-01-15 05:00:00	AAPL	Stock	77.8775	77.995	77.8	77.9725	44960.0
2020-01-15 06:00:00	AAPL	Stock	77.9725	77.9875	77.9175	77.9875	12644.0
2020-01-15 07:00:00	AAPL	Stock	77.975	78.325	77.875	78.2775	291664.0
2020-01-15 08:00:00	AAPL	Stock	78.285	78.3475	77.9175	78.025	801036.0
2020-01-15 09:00:00	AAPL	Stock	78.0025	78.8575	77.865	78.8375	18596528.0
2020-01-15 10:00:00	AAPL	Stock	78.8393	78.875	78.4525	78.625	14573324.0
2020-01-15 11:00:00	AAPL	Stock	78.623	78.6675	78.345	78.4875	10376576.0
2020-01-15 12:00:00	AAPL	Stock	78.4775	78.65	78.4225	78.4775	7272132.0
2020-01-15 13:00:00	AAPL	Stock	78.475	78.61	78.04	78.165	10320904.0
2020-01-15 14:00:00	AAPL	Stock	78.1675	78.4575	78.125	78.24	8347880.0
2020-01-15 15:00:00	AAPL	Stock	78.245	78.2525	77.3875	77.875	25547540.0
2020-01-15 16:00:00	AAPL	Stock	77.875	77.88	77.7875	77.8375	6501780.0
2020-01-15 17:00:00	AAPL	Stock	77.8375	77.9025	77.835	77.8625	416760.0
2020-01-15 18:00:00	AAPL	Stock	77.87	78.0625	77.87	78.0175	138772.0
2020-01-15 19:00:00	AAPL	Stock	78.0725	78.0725	78.0	78.05	112804.0
2020-01-15 04:00:00	MSFT	Stock	162.35	162.5	162.33	162.35	1937.0
2020-01-15 05:00:00	MSFT	Stock	162.6	162.75	162.42	162.55	2100.0
2020-01-15 06:00:00	MSFT	Stock	162.6	162.63	162.57	162.63	2006.0
2020-01-15 07:00:00	MSFT	Stock	162.55	162.65	162.35	162.65	11881.0
2020-01-15 08:00:00	MSFT	Stock	162.65	162.7	162.087	162.087	39261.0
2020-01-15 09:00:00	MSFT	Stock	162.11	163.4	162.082	163.232	2120020.0
2020-01-15 10:00:00	MSFT	Stock	163.28	163.925	163.13	163.805	2208461.0
2020-01-15 11:00:00	MSFT	Stock	163.805	163.82	163.32	163.45	1538709.0
2020-01-15 12:00:00	MSFT	Stock	163.46	163.94	163.4	163.455	1466438.0
2020-01-15 13:00:00	MSFT	Stock	163.45	163.67	163.31	163.445	1320821.0
2020-01-15 14:00:00	MSFT	Stock	163.445	163.89	163.381	163.58	1318416.0
2020-01-15 15:00:00	MSFT	Stock	163.59	163.61	162.96	163.29	3374963.0
2020-01-15 16:00:00	MSFT	Stock	163.18	163.43	163.18	163.4	3491568.0
2020-01-15 17:00:00	MSFT	Stock	163.35	163.43	163.18	163.35	130683.0
2020-01-15 18:00:00	MSFT	Stock	163.43	163.74	163.39	163.64	8849.0
2020-01-15 19:00:00	MSFT	Stock	163.62	163.7	163.52	163.53	17323.0
2020-01-15 04:00:00	NVDA	Stock	6.1875	6.1962	6.1748	6.1962	27560.0
2020-01-15 05:00:00	NVDA	Stock	6.1833	6.1833	6.1833	6.1833	5000.0
2020-01-15 06:00:00	NVDA	Stock	6.1778	6.1805	6.1763	6.1805	13160.0
2020-01-15 07:00:00	NVDA	Stock	6.1812	6.2058	6.1812	6.2055	202560.0
2020-01-15 08:00:00	NVDA	Stock	6.205	6.275	6.1825	6.199	1079080.0
2020-01-15 09:00:00	NVDA	Stock	6.1938	6.2223	6.1562	6.1953	43788040.0
2020-01-15 10:00:00	NVDA	Stock	6.194	6.2067	6.1625	6.1769	31932520.0
2020-01-15 11:00:00	NVDA	Stock	6.1771	6.1771	6.1378	6.1425	31672960.0
2020-01-15 12:00:00	NVDA	Stock	6.142	6.1491	6.1133	6.1272	23782360.0
2020-01-15 13:00:00	NVDA	Stock	6.1265	6.1465	6.1238	6.1394	16067720.0
2020-01-15 14:00:00	NVDA	Stock	6.1394	6.1631	6.1378	6.1403	21188920.0
2020-01-15 15:00:00	NVDA	Stock	6.1401	6.1453	6.1165	6.1393	36969720.0
2020-01-15 16:00:00	NVDA	Stock	6.1393	6.144	6.1302	6.144	4381240.0
2020-01-15 17:00:00	NVDA	Stock	6.1425	6.145	6.1393	6.1438	522720.0
2020-01-15 18:00:00	NVDA	Stock	6.1438	6.1622	6.1438	6.1562	144400.0
2020-01-15 19:00:00	NVDA	Stock	6.1525	6.1538	6.15	6.1538	52600.0
2020-01-15 04:00:00	AMZN	Stock	93.3	93.3	93.3	93.3	2400.0
2020-01-15 05:00:00	AMZN	Stock	93.35	93.35	93.35	93.35	4740.0

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

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