PREVIEW / stock_1hour / 2007-11-23

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-23.parquet
  size:    544 KB
  rows:    24,736
  symbols: 3,064

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-11-23 05:00:00	AAPL	Stock	6.0764	6.0764	6.0764	6.0764	2800.0
2007-11-23 06:00:00	AAPL	Stock	6.09	6.1429	6.09	6.1375	144032.0
2007-11-23 07:00:00	AAPL	Stock	6.1639	6.1639	6.0957	6.1071	605892.0
2007-11-23 08:00:00	AAPL	Stock	6.1136	6.1518	6.0164	6.1218	31203872.0
2007-11-23 09:00:00	AAPL	Stock	6.1225	6.1446	6.0771	6.1118	114508184.0
2007-11-23 10:00:00	AAPL	Stock	6.1118	6.1218	6.0714	6.0886	101885924.0
2007-11-23 11:00:00	AAPL	Stock	6.0889	6.1179	6.0625	6.0935	98022232.0
2007-11-23 12:00:00	AAPL	Stock	6.0925	6.1339	6.0868	6.1243	104076308.0
2007-11-23 13:00:00	AAPL	Stock	6.1268	6.1364	6.0999	6.1304	14905352.0
2007-11-23 14:00:00	AAPL	Stock	6.1304	6.1339	6.1264	6.1307	320796.0
2007-11-23 15:00:00	AAPL	Stock	6.1279	6.1307	6.1275	6.1293	117040.0
2007-11-23 16:00:00	AAPL	Stock	6.1293	6.1357	6.1286	6.1286	268772.0
2007-11-23 07:00:00	MSFT	Stock	34.35	34.35	34.35	34.35	1000.0
2007-11-23 08:00:00	MSFT	Stock	34.34	34.44	34.0	34.42	527512.0
2007-11-23 09:00:00	MSFT	Stock	34.42	34.44	33.86	33.95	4815465.0
2007-11-23 10:00:00	MSFT	Stock	33.95	34.0	33.86	33.882	5647365.0
2007-11-23 11:00:00	MSFT	Stock	33.88	33.94	33.71	33.73	8629872.0
2007-11-23 12:00:00	MSFT	Stock	33.72	34.11	33.71	34.08	11883823.0
2007-11-23 13:00:00	MSFT	Stock	34.11	34.15	33.863	34.11	1947810.0
2007-11-23 14:00:00	MSFT	Stock	34.11	34.11	34.04	34.04	14265.0
2007-11-23 15:00:00	MSFT	Stock	34.04	34.04	34.04	34.04	1000.0
2007-11-23 08:00:00	NVDA	Stock	0.75	0.7625	0.75	0.7578	74120.0
2007-11-23 09:00:00	NVDA	Stock	0.7578	0.7578	0.741	0.744	31096520.0
2007-11-23 10:00:00	NVDA	Stock	0.7445	0.7445	0.7385	0.7425	35721840.0
2007-11-23 11:00:00	NVDA	Stock	0.7425	0.7495	0.7423	0.7488	24644960.0
2007-11-23 12:00:00	NVDA	Stock	0.7488	0.7588	0.7452	0.7543	41100560.0
2007-11-23 13:00:00	NVDA	Stock	0.7543	0.7555	0.7443	0.7555	9314800.0
2007-11-23 15:00:00	NVDA	Stock	0.755	0.755	0.755	0.755	4000.0
2007-11-23 08:00:00	AMZN	Stock	3.988	4.0405	3.988	4.0295	351060.0
2007-11-23 09:00:00	AMZN	Stock	4.036	4.05	3.949	3.97	10843260.0
2007-11-23 10:00:00	AMZN	Stock	3.9685	3.9995	3.96	3.997	9582680.0
2007-11-23 11:00:00	AMZN	Stock	3.998	4.056	3.9955	4.04	12348480.0
2007-11-23 12:00:00	AMZN	Stock	4.0425	4.0725	4.036	4.061	19755460.0
2007-11-23 13:00:00	AMZN	Stock	4.0715	4.0715	4.0009	4.07	2725620.0
2007-11-23 14:00:00	AMZN	Stock	4.06	4.06	4.0535	4.0535	4000.0
2007-11-23 15:00:00	AMZN	Stock	4.0535	4.055	4.05	4.05	48000.0
2007-11-23 16:00:00	AMZN	Stock	4.05	4.0625	4.05	4.0625	6000.0
2007-11-23 08:00:00	TLT	Stock	93.22	93.31	93.22	93.31	3100.0
2007-11-23 09:00:00	TLT	Stock	93.24	93.51	93.24	93.47	114127.0
2007-11-23 10:00:00	TLT	Stock	93.47	93.54	93.37	93.54	70100.0
2007-11-23 11:00:00	TLT	Stock	93.54	93.7	93.52	93.53	117200.0
2007-11-23 12:00:00	TLT	Stock	93.54	93.8	93.5	93.77	131200.0
2007-11-23 13:00:00	TLT	Stock	93.77	93.78	93.73	93.73	1600.0
2007-11-23 09:00:00	CL	Stock	39.195	39.51	39.195	39.475	385728.0
2007-11-23 10:00:00	CL	Stock	39.48	39.625	39.375	39.41	613200.0
2007-11-23 11:00:00	CL	Stock	39.415	39.63	39.41	39.5	570600.0
2007-11-23 12:00:00	CL	Stock	39.495	39.53	39.405	39.5	961800.0
2007-11-23 13:00:00	CL	Stock	39.5	39.575	39.485	39.485	180960.0

> showing 48 of 24,736 rows — these rows as CSV

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