PREVIEW / stock_1hour / 2004-09-23

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-23.parquet
  size:    489 KB
  rows:    23,342
  symbols: 1,824

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-09-23 08:00:00	AAPL	Stock	0.6591	0.6598	0.6591	0.6598	90384.0
2004-09-23 09:00:00	AAPL	Stock	0.6613	0.6652	0.6602	0.6634	65452240.0
2004-09-23 10:00:00	AAPL	Stock	0.6632	0.668	0.6595	0.6679	83351072.0
2004-09-23 11:00:00	AAPL	Stock	0.6679	0.6689	0.6643	0.6663	34690768.0
2004-09-23 12:00:00	AAPL	Stock	0.6663	0.6677	0.6618	0.665	23842560.0
2004-09-23 13:00:00	AAPL	Stock	0.665	0.6673	0.6636	0.6648	34494488.0
2004-09-23 14:00:00	AAPL	Stock	0.6648	0.667	0.6639	0.6666	33158832.0
2004-09-23 15:00:00	AAPL	Stock	0.6666	0.6696	0.6655	0.6657	89786032.0
2004-09-23 16:00:00	AAPL	Stock	0.6655	0.6664	0.665	0.6655	3297672.0
2004-09-23 17:00:00	AAPL	Stock	0.6655	0.6659	0.6655	0.6659	4709600.0
2004-09-23 08:00:00	MSFT	Stock	27.115	27.17	27.1	27.17	103500.0
2004-09-23 09:00:00	MSFT	Stock	27.15	27.28	27.15	27.24	7025238.0
2004-09-23 10:00:00	MSFT	Stock	27.24	27.37	27.2	27.36	10831118.0
2004-09-23 11:00:00	MSFT	Stock	27.36	27.37	27.3	27.31	4364359.0
2004-09-23 12:00:00	MSFT	Stock	27.31	27.34	27.23	27.26	5495477.0
2004-09-23 13:00:00	MSFT	Stock	27.26	27.31	27.23	27.26	4351189.0
2004-09-23 14:00:00	MSFT	Stock	27.26	27.35	27.25	27.3	5451193.0
2004-09-23 15:00:00	MSFT	Stock	27.31	27.39	27.27	27.35	10473165.0
2004-09-23 16:00:00	MSFT	Stock	27.35	27.42	27.2789	27.35	1863497.0
2004-09-23 17:00:00	MSFT	Stock	27.34	27.35	27.34	27.34	5400.0
2004-09-23 18:00:00	MSFT	Stock	27.35	27.35	27.34	27.34	850.0
2004-09-23 08:00:00	NVDA	Stock	0.1207	0.1207	0.1204	0.1204	324000.0
2004-09-23 09:00:00	NVDA	Stock	0.1204	0.1214	0.1182	0.1195	76331280.0
2004-09-23 10:00:00	NVDA	Stock	0.1193	0.1202	0.1184	0.1192	127488000.0
2004-09-23 11:00:00	NVDA	Stock	0.1192	0.1192	0.1183	0.1184	46259880.0
2004-09-23 12:00:00	NVDA	Stock	0.1184	0.1189	0.1178	0.118	69963840.0
2004-09-23 13:00:00	NVDA	Stock	0.118	0.12	0.1176	0.1192	69475320.0
2004-09-23 14:00:00	NVDA	Stock	0.1192	0.1212	0.1192	0.1209	84600120.0
2004-09-23 15:00:00	NVDA	Stock	0.1209	0.1212	0.1204	0.1206	82567200.0
2004-09-23 16:00:00	NVDA	Stock	0.1206	0.1209	0.1204	0.1209	10499760.0
2004-09-23 18:00:00	NVDA	Stock	0.1208	0.1208	0.1208	0.1208	60000.0
2004-09-23 08:00:00	AMZN	Stock	2.075	2.08	2.0705	2.072	105000.0
2004-09-23 09:00:00	AMZN	Stock	2.0715	2.0935	2.0555	2.0925	23115980.0
2004-09-23 10:00:00	AMZN	Stock	2.0925	2.109	2.07	2.0825	36219760.0
2004-09-23 11:00:00	AMZN	Stock	2.0815	2.0895	2.078	2.0815	10116920.0
2004-09-23 12:00:00	AMZN	Stock	2.081	2.0955	2.0795	2.0855	10013420.0
2004-09-23 13:00:00	AMZN	Stock	2.0855	2.086	2.074	2.076	12419500.0
2004-09-23 14:00:00	AMZN	Stock	2.0775	2.105	2.0755	2.0975	24471680.0
2004-09-23 15:00:00	AMZN	Stock	2.097	2.11	2.088	2.091	25139400.0
2004-09-23 16:00:00	AMZN	Stock	2.0935	2.0935	2.084	2.0915	2912460.0
2004-09-23 17:00:00	AMZN	Stock	2.0895	2.0895	2.0835	2.0835	34000.0
2004-09-23 08:00:00	CL	Stock	22.925	22.975	22.925	22.975	3000.0
2004-09-23 09:00:00	CL	Stock	23.0	23.1	22.95	23.025	2590800.0
2004-09-23 10:00:00	CL	Stock	23.02	23.175	22.975	23.125	3616400.0
2004-09-23 11:00:00	CL	Stock	23.125	23.15	23.025	23.045	2172400.0
2004-09-23 12:00:00	CL	Stock	23.04	23.045	22.93	22.95	1459800.0
2004-09-23 13:00:00	CL	Stock	22.95	23.02	22.925	22.99	1352400.0
2004-09-23 14:00:00	CL	Stock	22.99	23.02	22.97	22.99	1103800.0
2004-09-23 15:00:00	CL	Stock	22.99	23.0	22.85	22.9	2240400.0
2004-09-23 16:00:00	CL	Stock	22.875	22.925	22.875	22.925	10800.0

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

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