PREVIEW / stock_1hour / 2009-07-01

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-07-01.parquet
  size:    852 KB
  rows:    41,297
  symbols: 3,306

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
2009-07-01 07:00:00	AAPL	Stock	5.1071	5.1161	5.1071	5.1161	35000.0
2009-07-01 08:00:00	AAPL	Stock	5.1086	5.1161	5.0868	5.1029	1680476.0
2009-07-01 09:00:00	AAPL	Stock	5.1046	5.1489	5.0989	5.1475	78046836.0
2009-07-01 10:00:00	AAPL	Stock	5.1464	5.1664	5.1318	5.1518	93664872.0
2009-07-01 11:00:00	AAPL	Stock	5.1516	5.1571	5.1321	5.1464	44786952.0
2009-07-01 12:00:00	AAPL	Stock	5.1464	5.1504	5.135	5.1357	25614120.0
2009-07-01 13:00:00	AAPL	Stock	5.1361	5.1418	5.1304	5.1329	28349048.0
2009-07-01 14:00:00	AAPL	Stock	5.1336	5.1354	5.1021	5.1068	52873968.0
2009-07-01 15:00:00	AAPL	Stock	5.1061	5.1179	5.09	5.1011	73075044.0
2009-07-01 16:00:00	AAPL	Stock	5.1011	5.1489	5.0946	5.1018	10253712.0
2009-07-01 17:00:00	AAPL	Stock	5.1018	5.1111	5.1018	5.1043	120148.0
2009-07-01 18:00:00	AAPL	Stock	5.1011	5.1136	5.1011	5.1096	195496.0
2009-07-01 19:00:00	AAPL	Stock	5.1121	5.1125	5.1054	5.11	61908.0
2009-07-01 07:00:00	MSFT	Stock	23.9	23.95	23.9	23.91	4400.0
2009-07-01 08:00:00	MSFT	Stock	23.92	23.95	23.77	23.92	27139.0
2009-07-01 09:00:00	MSFT	Stock	23.93	24.22	23.93	24.151	7098453.0
2009-07-01 10:00:00	MSFT	Stock	24.15	24.3	24.0	24.19	11095851.0
2009-07-01 11:00:00	MSFT	Stock	24.195	24.21	24.09	24.111	7070647.0
2009-07-01 12:00:00	MSFT	Stock	24.12	24.15	23.99	23.992	4625646.0
2009-07-01 13:00:00	MSFT	Stock	24.0	24.1	23.96	24.08	4029557.0
2009-07-01 14:00:00	MSFT	Stock	24.07	24.16	24.02	24.11	6773863.0
2009-07-01 15:00:00	MSFT	Stock	24.11	24.15	23.99	24.03	9830789.0
2009-07-01 16:00:00	MSFT	Stock	24.03	24.104	24.0	24.01	2970512.0
2009-07-01 17:00:00	MSFT	Stock	24.03	24.05	23.77	24.03	17989.0
2009-07-01 18:00:00	MSFT	Stock	24.04	24.04	24.03	24.04	32575.0
2009-07-01 19:00:00	MSFT	Stock	24.05	24.1	23.99	24.1	4150.0
2009-07-01 08:00:00	NVDA	Stock	0.2838	0.2838	0.2838	0.2838	4000.0
2009-07-01 09:00:00	NVDA	Stock	0.287	0.287	0.2812	0.2842	83457400.0
2009-07-01 10:00:00	NVDA	Stock	0.2842	0.2842	0.2788	0.2798	249147720.0
2009-07-01 11:00:00	NVDA	Stock	0.28	0.2852	0.2798	0.2848	87825880.0
2009-07-01 12:00:00	NVDA	Stock	0.2848	0.2868	0.283	0.2855	99770320.0
2009-07-01 13:00:00	NVDA	Stock	0.2855	0.2872	0.2848	0.2848	55548160.0
2009-07-01 14:00:00	NVDA	Stock	0.2849	0.2855	0.2838	0.2844	32564520.0
2009-07-01 15:00:00	NVDA	Stock	0.2843	0.2858	0.2828	0.283	65272000.0
2009-07-01 16:00:00	NVDA	Stock	0.2832	0.2835	0.2829	0.2835	5824480.0
2009-07-01 17:00:00	NVDA	Stock	0.2835	0.2835	0.2822	0.2822	556000.0
2009-07-01 18:00:00	NVDA	Stock	0.2822	0.2822	0.2822	0.2822	20000.0
2009-07-01 07:00:00	AMZN	Stock	4.2	4.2	4.2	4.2	2000.0
2009-07-01 08:00:00	AMZN	Stock	4.195	4.2025	4.183	4.1925	263140.0
2009-07-01 09:00:00	AMZN	Stock	4.215	4.221	4.1725	4.2138	14188880.0
2009-07-01 10:00:00	AMZN	Stock	4.214	4.225	4.189	4.2095	22615360.0
2009-07-01 11:00:00	AMZN	Stock	4.2095	4.2115	4.165	4.1848	11859520.0
2009-07-01 12:00:00	AMZN	Stock	4.1845	4.1855	4.135	4.136	11952680.0
2009-07-01 13:00:00	AMZN	Stock	4.1355	4.153	4.1184	4.121	13287900.0
2009-07-01 14:00:00	AMZN	Stock	4.1215	4.1235	4.0705	4.072	22410700.0
2009-07-01 15:00:00	AMZN	Stock	4.0715	4.0885	4.0685	4.0795	36270760.0
2009-07-01 16:00:00	AMZN	Stock	4.0745	4.1392	4.0725	4.0775	3130140.0
2009-07-01 17:00:00	AMZN	Stock	4.0775	4.0775	4.0775	4.0775	7000.0
2009-07-01 18:00:00	AMZN	Stock	4.0835	4.0835	4.0835	4.0835	5000.0
2009-07-01 19:00:00	AMZN	Stock	4.084	4.084	4.078	4.079	17500.0

> showing 50 of 41,297 rows — these rows as CSV

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