PREVIEW / stock_1hour / 2010-10-20

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-10-20.parquet
  size:    911 KB
  rows:    43,507
  symbols: 3,493

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
2010-10-20 04:00:00	AAPL	Stock	11.0318	11.0571	11.0318	11.0321	22400.0
2010-10-20 05:00:00	AAPL	Stock	11.0446	11.0489	11.0346	11.0346	36652.0
2010-10-20 06:00:00	AAPL	Stock	11.0446	11.0536	11.0179	11.0357	99036.0
2010-10-20 07:00:00	AAPL	Stock	11.0268	11.0639	11.0232	11.0536	782656.0
2010-10-20 08:00:00	AAPL	Stock	11.05	11.0686	11.0	11.0279	6487208.0
2010-10-20 09:00:00	AAPL	Stock	11.0275	11.1	10.9968	11.0314	99887116.0
2010-10-20 10:00:00	AAPL	Stock	11.0321	11.0775	10.9596	11.0582	124793676.0
2010-10-20 11:00:00	AAPL	Stock	11.06	11.1964	11.0411	11.1604	113155504.0
2010-10-20 12:00:00	AAPL	Stock	11.1593	11.2232	11.1571	11.1721	74037544.0
2010-10-20 13:00:00	AAPL	Stock	11.1721	11.1943	11.1446	11.1525	56033684.0
2010-10-20 14:00:00	AAPL	Stock	11.1532	11.1839	11.1143	11.1521	100759400.0
2010-10-20 15:00:00	AAPL	Stock	11.1521	11.1757	11.0686	11.0904	118929356.0
2010-10-20 16:00:00	AAPL	Stock	11.0879	11.1717	11.0768	11.1104	9764804.0
2010-10-20 17:00:00	AAPL	Stock	11.1075	11.1107	11.0832	11.0882	1600004.0
2010-10-20 18:00:00	AAPL	Stock	11.0929	11.1	11.0682	11.0682	1317652.0
2010-10-20 19:00:00	AAPL	Stock	11.0732	11.0882	11.07	11.0857	870828.0
2010-10-20 20:00:00	AAPL	Stock	11.1714	11.1714	11.1714	11.1714	1181600.0
2010-10-20 04:00:00	MSFT	Stock	25.17	25.17	25.17	25.17	300.0
2010-10-20 07:00:00	MSFT	Stock	25.3	25.3	25.17	25.25	41400.0
2010-10-20 08:00:00	MSFT	Stock	25.2	25.23	25.13	25.13	339257.0
2010-10-20 09:00:00	MSFT	Stock	25.15	25.3	25.12	25.26	4509085.0
2010-10-20 10:00:00	MSFT	Stock	25.26	25.31	25.1	25.28	8389306.0
2010-10-20 11:00:00	MSFT	Stock	25.28	25.28	25.19	25.21	5026397.0
2010-10-20 12:00:00	MSFT	Stock	25.21	25.34	25.2	25.22	4743020.0
2010-10-20 13:00:00	MSFT	Stock	25.224	25.26	25.18	25.2	3502768.0
2010-10-20 14:00:00	MSFT	Stock	25.2	25.26	25.15	25.22	6918946.0
2010-10-20 15:00:00	MSFT	Stock	25.215	25.4	25.205	25.3	19471425.0
2010-10-20 16:00:00	MSFT	Stock	25.29	25.37	25.021	25.33	2216608.0
2010-10-20 17:00:00	MSFT	Stock	25.33	25.33	25.3	25.3	177596.0
2010-10-20 18:00:00	MSFT	Stock	25.31	25.33	25.31	25.32	93873.0
2010-10-20 19:00:00	MSFT	Stock	25.31	25.33	25.31	25.33	4596.0
2010-10-20 06:00:00	NVDA	Stock	0.2855	0.2855	0.2855	0.2855	26160.0
2010-10-20 07:00:00	NVDA	Stock	0.286	0.286	0.286	0.286	6000.0
2010-10-20 08:00:00	NVDA	Stock	0.2862	0.2862	0.285	0.285	129600.0
2010-10-20 09:00:00	NVDA	Stock	0.2828	0.2848	0.2798	0.28	71493560.0
2010-10-20 10:00:00	NVDA	Stock	0.28	0.2828	0.2775	0.2818	83706360.0
2010-10-20 11:00:00	NVDA	Stock	0.2815	0.2872	0.2805	0.286	94872640.0
2010-10-20 12:00:00	NVDA	Stock	0.2861	0.2872	0.2838	0.2838	62119880.0
2010-10-20 13:00:00	NVDA	Stock	0.2838	0.2856	0.2838	0.2845	37200520.0
2010-10-20 14:00:00	NVDA	Stock	0.2845	0.29	0.284	0.2855	261275600.0
2010-10-20 15:00:00	NVDA	Stock	0.2854	0.2858	0.282	0.2822	145735280.0
2010-10-20 16:00:00	NVDA	Stock	0.2822	0.2844	0.282	0.2822	1945080.0
2010-10-20 17:00:00	NVDA	Stock	0.2822	0.2822	0.2815	0.2815	523320.0
2010-10-20 18:00:00	NVDA	Stock	0.2832	0.2832	0.28	0.2803	56000.0
2010-10-20 08:00:00	AMZN	Stock	7.987	7.99	7.95	7.9645	136980.0
2010-10-20 09:00:00	AMZN	Stock	7.96	7.975	7.85	7.867	16121840.0
2010-10-20 10:00:00	AMZN	Stock	7.869	7.917	7.8285	7.8925	23010580.0
2010-10-20 11:00:00	AMZN	Stock	7.896	7.918	7.8625	7.8635	15073120.0
2010-10-20 12:00:00	AMZN	Stock	7.8635	7.897	7.86	7.871	13301280.0
2010-10-20 13:00:00	AMZN	Stock	7.872	7.953	7.869	7.9415	13037320.0

> showing 50 of 43,507 rows — these rows as CSV

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