PREVIEW / stock_1hour / 2004-05-19

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-05-19.parquet
  size:    496 KB
  rows:    23,162
  symbols: 1,781

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
2004-05-19 08:00:00	AAPL	Stock	0.4832	0.4893	0.4832	0.4866	649600.0
2004-05-19 09:00:00	AAPL	Stock	0.4875	0.4911	0.4859	0.487	38929184.0
2004-05-19 10:00:00	AAPL	Stock	0.487	0.4893	0.4859	0.4868	57524544.0
2004-05-19 11:00:00	AAPL	Stock	0.4873	0.4882	0.4852	0.4866	20342952.0
2004-05-19 12:00:00	AAPL	Stock	0.4866	0.4873	0.4857	0.4864	14205240.0
2004-05-19 13:00:00	AAPL	Stock	0.4863	0.4866	0.4859	0.4864	8957256.0
2004-05-19 14:00:00	AAPL	Stock	0.4864	0.4866	0.4802	0.4809	45029600.0
2004-05-19 15:00:00	AAPL	Stock	0.4807	0.4813	0.4718	0.4729	159075224.0
2004-05-19 16:00:00	AAPL	Stock	0.4729	0.4738	0.4688	0.4696	11906664.0
2004-05-19 17:00:00	AAPL	Stock	0.4727	0.4727	0.4704	0.4705	1136800.0
2004-05-19 18:00:00	AAPL	Stock	0.4707	0.472	0.4679	0.4679	117600.0
2004-05-19 08:00:00	MSFT	Stock	26.1	26.14	26.0	26.03	137020.0
2004-05-19 09:00:00	MSFT	Stock	26.04	26.08	25.91	26.0	6324954.0
2004-05-19 10:00:00	MSFT	Stock	26.0	26.16	25.99	26.14	10080293.0
2004-05-19 11:00:00	MSFT	Stock	26.14	26.27	26.12	26.21	7556937.0
2004-05-19 12:00:00	MSFT	Stock	26.22	26.23	26.12	26.12	3934473.0
2004-05-19 13:00:00	MSFT	Stock	26.13	26.14	26.04	26.09	4908324.0
2004-05-19 14:00:00	MSFT	Stock	26.1	26.11	25.86	25.899	9491784.0
2004-05-19 15:00:00	MSFT	Stock	25.89	25.9	25.65	25.65	14514248.0
2004-05-19 16:00:00	MSFT	Stock	25.66	25.7448	25.61	25.64	1699790.0
2004-05-19 17:00:00	MSFT	Stock	25.62	25.65	25.62	25.63	45950.0
2004-05-19 18:00:00	MSFT	Stock	25.64	25.68	25.64	25.65	10800.0
2004-05-19 08:00:00	NVDA	Stock	0.18	0.1814	0.18	0.1814	240000.0
2004-05-19 09:00:00	NVDA	Stock	0.1814	0.1858	0.1814	0.1854	48916560.0
2004-05-19 10:00:00	NVDA	Stock	0.1855	0.1855	0.1823	0.1828	129110400.0
2004-05-19 11:00:00	NVDA	Stock	0.1829	0.1832	0.1809	0.1818	54520920.0
2004-05-19 12:00:00	NVDA	Stock	0.1819	0.1828	0.1812	0.1817	34892640.0
2004-05-19 13:00:00	NVDA	Stock	0.1816	0.1825	0.1812	0.1821	31761360.0
2004-05-19 14:00:00	NVDA	Stock	0.182	0.1823	0.1807	0.1815	38979480.0
2004-05-19 15:00:00	NVDA	Stock	0.1815	0.1815	0.1779	0.1784	97765080.0
2004-05-19 16:00:00	NVDA	Stock	0.1783	0.1793	0.1783	0.1788	15158640.0
2004-05-19 17:00:00	NVDA	Stock	0.1783	0.1783	0.1783	0.1783	24000.0
2004-05-19 08:00:00	AMZN	Stock	2.1	2.1225	2.1	2.1185	647760.0
2004-05-19 09:00:00	AMZN	Stock	2.12	2.1235	2.0955	2.109	15599000.0
2004-05-19 10:00:00	AMZN	Stock	2.11	2.156	2.1085	2.15	30770280.0
2004-05-19 11:00:00	AMZN	Stock	2.1505	2.1635	2.146	2.1605	24011920.0
2004-05-19 12:00:00	AMZN	Stock	2.161	2.1635	2.153	2.1565	10980420.0
2004-05-19 13:00:00	AMZN	Stock	2.1565	2.1575	2.1375	2.1475	8812660.0
2004-05-19 14:00:00	AMZN	Stock	2.148	2.15	2.112	2.117	14247860.0
2004-05-19 15:00:00	AMZN	Stock	2.1165	2.1185	2.0735	2.0805	38884440.0
2004-05-19 16:00:00	AMZN	Stock	2.081	2.0845	2.0675	2.0675	1731580.0
2004-05-19 17:00:00	AMZN	Stock	2.0845	2.0845	2.065	2.0695	213500.0
2004-05-19 18:00:00	AMZN	Stock	2.0695	2.0695	2.0695	2.0695	4000.0
2004-05-19 09:00:00	CL	Stock	28.125	28.23	28.02	28.16	322400.0
2004-05-19 10:00:00	CL	Stock	28.16	28.27	28.155	28.265	476600.0
2004-05-19 11:00:00	CL	Stock	28.245	28.27	28.22	28.26	207800.0
2004-05-19 12:00:00	CL	Stock	28.255	28.265	28.18	28.225	252400.0
2004-05-19 13:00:00	CL	Stock	28.23	28.24	28.2	28.215	200600.0
2004-05-19 14:00:00	CL	Stock	28.215	28.225	28.005	28.155	455200.0
2004-05-19 15:00:00	CL	Stock	28.17	28.17	27.96	27.975	612000.0

> showing 50 of 23,162 rows — these rows as CSV

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