PREVIEW / stock_1hour / 2007-01-25

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-25.parquet
  size:    647 KB
  rows:    30,765
  symbols: 2,499

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
2007-01-25 05:00:00	AAPL	Stock	3.1071	3.1071	3.1071	3.1071	11200.0
2007-01-25 06:00:00	AAPL	Stock	3.1004	3.1071	3.1	3.1071	61600.0
2007-01-25 07:00:00	AAPL	Stock	3.1071	3.1111	3.1071	3.1107	209104.0
2007-01-25 08:00:00	AAPL	Stock	3.1011	3.1071	3.0961	3.1018	1649256.0
2007-01-25 09:00:00	AAPL	Stock	3.1014	3.1607	3.1004	3.1464	185713920.0
2007-01-25 10:00:00	AAPL	Stock	3.1464	3.1536	3.1139	3.125	198839704.0
2007-01-25 11:00:00	AAPL	Stock	3.1254	3.1296	3.1096	3.1161	96485928.0
2007-01-25 12:00:00	AAPL	Stock	3.1164	3.1186	3.0921	3.1068	103723396.0
2007-01-25 13:00:00	AAPL	Stock	3.1068	3.1179	3.0911	3.0918	76757800.0
2007-01-25 14:00:00	AAPL	Stock	3.0918	3.1021	3.0893	3.0921	97798260.0
2007-01-25 15:00:00	AAPL	Stock	3.0925	3.0925	3.0725	3.0804	137890732.0
2007-01-25 16:00:00	AAPL	Stock	3.0804	3.0904	3.0804	3.0857	1784636.0
2007-01-25 17:00:00	AAPL	Stock	3.0857	3.0893	3.0821	3.0875	566412.0
2007-01-25 18:00:00	AAPL	Stock	3.0804	3.0893	3.0804	3.0879	467516.0
2007-01-25 19:00:00	AAPL	Stock	3.0893	3.1036	3.0886	3.0893	373492.0
2007-01-25 04:00:00	MSFT	Stock	31.12	31.2	31.12	31.2	700.0
2007-01-25 06:00:00	MSFT	Stock	31.17	31.18	31.12	31.12	4100.0
2007-01-25 07:00:00	MSFT	Stock	31.16	31.16	31.11	31.11	800.0
2007-01-25 08:00:00	MSFT	Stock	31.15	31.22	31.1	31.18	201022.0
2007-01-25 09:00:00	MSFT	Stock	31.2	31.45	31.0	31.37	11123900.0
2007-01-25 10:00:00	MSFT	Stock	31.38	31.48	31.03	31.11	11818894.0
2007-01-25 11:00:00	MSFT	Stock	31.12	31.32	31.11	31.17	6087539.0
2007-01-25 12:00:00	MSFT	Stock	31.16	31.19	30.83	30.878	9544259.0
2007-01-25 13:00:00	MSFT	Stock	30.88	30.96	30.7	30.72	9936087.0
2007-01-25 14:00:00	MSFT	Stock	30.71	30.83	30.47	30.63	15119660.0
2007-01-25 15:00:00	MSFT	Stock	30.63	30.75	30.46	30.46	17956508.0
2007-01-25 16:00:00	MSFT	Stock	30.49	31.6	30.07	31.15	11010336.0
2007-01-25 17:00:00	MSFT	Stock	31.13	31.25	30.4	31.09	3703533.0
2007-01-25 18:00:00	MSFT	Stock	31.09	31.1	30.45	30.97	1351391.0
2007-01-25 19:00:00	MSFT	Stock	30.98	31.02	30.9	31.0	77080.0
2007-01-25 08:00:00	NVDA	Stock	0.5578	0.5583	0.553	0.5558	321480.0
2007-01-25 09:00:00	NVDA	Stock	0.5517	0.5553	0.5417	0.5535	63287220.0
2007-01-25 10:00:00	NVDA	Stock	0.5537	0.5545	0.5432	0.545	75590460.0
2007-01-25 11:00:00	NVDA	Stock	0.545	0.547	0.5432	0.5432	39545460.0
2007-01-25 12:00:00	NVDA	Stock	0.5432	0.5437	0.5398	0.5413	59378340.0
2007-01-25 13:00:00	NVDA	Stock	0.5417	0.5417	0.5347	0.5355	70236240.0
2007-01-25 14:00:00	NVDA	Stock	0.5353	0.5367	0.5313	0.5332	108004380.0
2007-01-25 15:00:00	NVDA	Stock	0.533	0.5332	0.5262	0.5285	150811860.0
2007-01-25 16:00:00	NVDA	Stock	0.5283	0.5333	0.5273	0.5317	1104600.0
2007-01-25 17:00:00	NVDA	Stock	0.5302	0.5302	0.5292	0.53	184200.0
2007-01-25 18:00:00	NVDA	Stock	0.5288	0.5288	0.528	0.528	48360.0
2007-01-25 19:00:00	NVDA	Stock	0.5295	0.5295	0.5292	0.5292	78000.0
2007-01-25 08:00:00	AMZN	Stock	1.8975	1.91	1.863	1.8945	322520.0
2007-01-25 09:00:00	AMZN	Stock	1.897	1.9115	1.863	1.87	24063500.0
2007-01-25 10:00:00	AMZN	Stock	1.869	1.875	1.859	1.867	27082260.0
2007-01-25 11:00:00	AMZN	Stock	1.8665	1.873	1.85	1.8505	12927920.0
2007-01-25 12:00:00	AMZN	Stock	1.851	1.8525	1.839	1.851	11058100.0
2007-01-25 13:00:00	AMZN	Stock	1.851	1.8665	1.851	1.8575	22270720.0
2007-01-25 14:00:00	AMZN	Stock	1.8575	1.861	1.8455	1.8605	16262560.0
2007-01-25 15:00:00	AMZN	Stock	1.8605	1.8605	1.852	1.854	18801120.0

> showing 50 of 30,765 rows — these rows as CSV

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