PREVIEW / stock_1hour / 2006-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-03-23.parquet
  size:    584 KB
  rows:    27,702
  symbols: 2,213

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-23 04:00:00	AAPL	Stock	2.2036	2.2036	2.2036	2.2036	28000.0
2006-03-23 06:00:00	AAPL	Stock	2.1893	2.1893	2.1893	2.1893	2800.0
2006-03-23 07:00:00	AAPL	Stock	2.1929	2.1964	2.1893	2.195	82600.0
2006-03-23 08:00:00	AAPL	Stock	2.1957	2.2111	2.1921	2.2036	4199188.0
2006-03-23 09:00:00	AAPL	Stock	2.2036	2.2107	2.1721	2.1771	156035572.0
2006-03-23 10:00:00	AAPL	Stock	2.1771	2.1861	2.1636	2.1729	199439352.0
2006-03-23 11:00:00	AAPL	Stock	2.1729	2.1771	2.1469	2.1507	208898396.0
2006-03-23 12:00:00	AAPL	Stock	2.1507	2.1589	2.1361	2.1454	251181364.0
2006-03-23 13:00:00	AAPL	Stock	2.145	2.1539	2.1389	2.1467	143518004.0
2006-03-23 14:00:00	AAPL	Stock	2.1464	2.2036	2.1289	2.1318	177494520.0
2006-03-23 15:00:00	AAPL	Stock	2.1314	2.1579	2.13	2.1479	268700152.0
2006-03-23 16:00:00	AAPL	Stock	2.1475	2.1489	2.1432	2.145	3956400.0
2006-03-23 17:00:00	AAPL	Stock	2.1446	2.1518	2.1446	2.15	2269512.0
2006-03-23 18:00:00	AAPL	Stock	2.15	2.16	2.15	2.16	1889860.0
2006-03-23 04:00:00	MSFT	Stock	27.13	27.13	27.13	27.13	100.0
2006-03-23 08:00:00	MSFT	Stock	27.12	27.2	27.09	27.11	14371.0
2006-03-23 09:00:00	MSFT	Stock	27.11	27.12	27.0	27.01	5880401.0
2006-03-23 10:00:00	MSFT	Stock	27.02	27.09	26.67	26.7	22542067.0
2006-03-23 11:00:00	MSFT	Stock	26.71	26.85	26.66	26.77	11036360.0
2006-03-23 12:00:00	MSFT	Stock	26.77	27.085	26.68	26.76	6089080.0
2006-03-23 13:00:00	MSFT	Stock	26.76	26.81	26.72	26.81	5616505.0
2006-03-23 14:00:00	MSFT	Stock	26.8	26.81	26.7	26.75	6674943.0
2006-03-23 15:00:00	MSFT	Stock	26.741	26.91	26.73	26.85	13410579.0
2006-03-23 16:00:00	MSFT	Stock	26.85	26.87	26.8	26.83	173213.0
2006-03-23 17:00:00	MSFT	Stock	26.83	26.85	26.81	26.84	8923.0
2006-03-23 18:00:00	MSFT	Stock	26.87	26.87	26.85	26.85	111462.0
2006-03-23 08:00:00	NVDA	Stock	0.4157	0.4157	0.4142	0.4148	468840.0
2006-03-23 09:00:00	NVDA	Stock	0.4147	0.4164	0.4081	0.4132	97697640.0
2006-03-23 10:00:00	NVDA	Stock	0.4132	0.4145	0.4078	0.411	90424560.0
2006-03-23 11:00:00	NVDA	Stock	0.4111	0.4137	0.4096	0.4119	46869240.0
2006-03-23 12:00:00	NVDA	Stock	0.4119	0.4162	0.4113	0.4153	40110120.0
2006-03-23 13:00:00	NVDA	Stock	0.4152	0.4169	0.4122	0.4169	87585360.0
2006-03-23 14:00:00	NVDA	Stock	0.417	0.4174	0.4104	0.4122	65066760.0
2006-03-23 15:00:00	NVDA	Stock	0.4119	0.4204	0.4113	0.4185	216255840.0
2006-03-23 16:00:00	NVDA	Stock	0.4184	0.4192	0.4178	0.4187	1530240.0
2006-03-23 17:00:00	NVDA	Stock	0.4191	0.4192	0.4185	0.4185	126480.0
2006-03-23 18:00:00	NVDA	Stock	0.4192	0.4195	0.4192	0.4195	60000.0
2006-03-23 08:00:00	AMZN	Stock	1.802	1.8025	1.8	1.8025	40000.0
2006-03-23 09:00:00	AMZN	Stock	1.8	1.817	1.795	1.8035	10255160.0
2006-03-23 10:00:00	AMZN	Stock	1.8025	1.808	1.7785	1.779	15237800.0
2006-03-23 11:00:00	AMZN	Stock	1.779	1.7925	1.774	1.7895	14385060.0
2006-03-23 12:00:00	AMZN	Stock	1.79	1.803	1.7896	1.797	7164820.0
2006-03-23 13:00:00	AMZN	Stock	1.7965	1.7965	1.789	1.7945	4847600.0
2006-03-23 14:00:00	AMZN	Stock	1.795	1.7965	1.777	1.777	10713020.0
2006-03-23 15:00:00	AMZN	Stock	1.777	1.785	1.7745	1.7815	15551820.0
2006-03-23 16:00:00	AMZN	Stock	1.7825	1.7825	1.777	1.7815	275680.0
2006-03-23 17:00:00	AMZN	Stock	1.784	1.795	1.784	1.795	234000.0
2006-03-23 18:00:00	AMZN	Stock	1.795	1.8	1.795	1.795	182000.0
2006-03-23 09:00:00	CL	Stock	28.9	28.925	28.725	28.78	324400.0
2006-03-23 10:00:00	CL	Stock	28.785	28.795	28.56	28.565	485800.0

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

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