PREVIEW / stock_1hour / 2006-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-27.parquet
  size:    587 KB
  rows:    27,885
  symbols: 2,223

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
2006-03-27 06:00:00	AAPL	Stock	2.1446	2.1464	2.1446	2.1464	5600.0
2006-03-27 07:00:00	AAPL	Stock	2.1446	2.1493	2.1432	2.1475	190400.0
2006-03-27 08:00:00	AAPL	Stock	2.15	2.1529	2.1464	2.1489	2982868.0
2006-03-27 09:00:00	AAPL	Stock	2.1507	2.1921	2.1446	2.1886	195574540.0
2006-03-27 10:00:00	AAPL	Stock	2.1886	2.1893	2.1661	2.1661	184850232.0
2006-03-27 11:00:00	AAPL	Stock	2.1661	2.1771	2.1518	2.1554	138816552.0
2006-03-27 12:00:00	AAPL	Stock	2.155	2.17	2.1479	2.1639	99867404.0
2006-03-27 13:00:00	AAPL	Stock	2.1643	2.1693	2.1493	2.1625	80893876.0
2006-03-27 14:00:00	AAPL	Stock	2.1618	2.1643	2.1518	2.1557	90061776.0
2006-03-27 15:00:00	AAPL	Stock	2.1561	2.1561	2.1214	2.1261	298640440.0
2006-03-27 16:00:00	AAPL	Stock	2.1257	2.1286	2.1214	2.1271	5306728.0
2006-03-27 17:00:00	AAPL	Stock	2.1271	2.1275	2.1246	2.1254	712040.0
2006-03-27 18:00:00	AAPL	Stock	2.1254	2.1268	2.1239	2.1246	433832.0
2006-03-27 07:00:00	MSFT	Stock	27.0	27.0	27.0	27.0	400.0
2006-03-27 08:00:00	MSFT	Stock	27.0	27.06	27.0	27.06	16307.0
2006-03-27 09:00:00	MSFT	Stock	27.05	27.2	27.0	27.17	5976921.0
2006-03-27 10:00:00	MSFT	Stock	27.16	27.22	27.13	27.142	9401088.0
2006-03-27 11:00:00	MSFT	Stock	27.15	27.17	27.07	27.131	8773040.0
2006-03-27 12:00:00	MSFT	Stock	27.13	27.26	27.13	27.2	7124533.0
2006-03-27 13:00:00	MSFT	Stock	27.2	27.3	27.18	27.22	6350376.0
2006-03-27 14:00:00	MSFT	Stock	27.22	27.28	27.11	27.12	4550417.0
2006-03-27 15:00:00	MSFT	Stock	27.12	27.16	27.01	27.02	13928524.0
2006-03-27 16:00:00	MSFT	Stock	27.01	27.04	27.01	27.03	90440.0
2006-03-27 17:00:00	MSFT	Stock	27.02	27.02	27.01	27.02	500200.0
2006-03-27 18:00:00	MSFT	Stock	27.02	27.03	27.02	27.03	1985.0
2006-03-27 08:00:00	NVDA	Stock	0.4371	0.4371	0.4331	0.4333	528000.0
2006-03-27 09:00:00	NVDA	Stock	0.4333	0.4422	0.4318	0.4397	127738080.0
2006-03-27 10:00:00	NVDA	Stock	0.4397	0.4402	0.4362	0.4371	88786680.0
2006-03-27 11:00:00	NVDA	Stock	0.4372	0.4427	0.4361	0.4402	85737720.0
2006-03-27 12:00:00	NVDA	Stock	0.4402	0.4423	0.4383	0.4413	61696800.0
2006-03-27 13:00:00	NVDA	Stock	0.4413	0.4431	0.4413	0.4421	47920200.0
2006-03-27 14:00:00	NVDA	Stock	0.4422	0.4443	0.4407	0.4443	68286720.0
2006-03-27 15:00:00	NVDA	Stock	0.4442	0.4449	0.4432	0.4448	135911040.0
2006-03-27 16:00:00	NVDA	Stock	0.4446	0.4448	0.4443	0.4444	5529840.0
2006-03-27 17:00:00	NVDA	Stock	0.4444	0.4444	0.4444	0.4444	72000.0
2006-03-27 18:00:00	NVDA	Stock	0.4448	0.4448	0.4448	0.4448	72000.0
2006-03-27 08:00:00	AMZN	Stock	1.782	1.782	1.7805	1.7805	6000.0
2006-03-27 09:00:00	AMZN	Stock	1.774	1.783	1.7665	1.7725	6416380.0
2006-03-27 10:00:00	AMZN	Stock	1.7725	1.773	1.7625	1.7655	7570640.0
2006-03-27 11:00:00	AMZN	Stock	1.7655	1.766	1.76	1.7635	11888380.0
2006-03-27 12:00:00	AMZN	Stock	1.7635	1.7735	1.7615	1.7625	5815600.0
2006-03-27 13:00:00	AMZN	Stock	1.763	1.77	1.7615	1.769	8298360.0
2006-03-27 14:00:00	AMZN	Stock	1.769	1.77	1.7585	1.762	13351160.0
2006-03-27 15:00:00	AMZN	Stock	1.7625	1.7629	1.757	1.7625	17998800.0
2006-03-27 16:00:00	AMZN	Stock	1.7625	1.763	1.7625	1.763	200120.0
2006-03-27 18:00:00	AMZN	Stock	1.7585	1.7635	1.7575	1.7635	22000.0
2006-03-27 09:00:00	CL	Stock	28.935	29.05	28.915	29.0	285800.0
2006-03-27 10:00:00	CL	Stock	29.0	29.01	28.87	28.88	336800.0
2006-03-27 11:00:00	CL	Stock	28.88	28.92	28.83	28.855	254000.0
2006-03-27 12:00:00	CL	Stock	28.855	28.915	28.85	28.86	312800.0

> showing 50 of 27,885 rows — these rows as CSV

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