PREVIEW / stock_1hour / 2010-01-22

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-22.parquet
  size:    908 KB
  rows:    43,453
  symbols: 3,447

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
2010-01-22 04:00:00	AAPL	Stock	7.4554	7.4554	7.4554	7.4554	2800.0
2010-01-22 05:00:00	AAPL	Stock	7.4389	7.4389	7.4311	7.4311	5600.0
2010-01-22 06:00:00	AAPL	Stock	7.4264	7.4264	7.4021	7.4021	42448.0
2010-01-22 07:00:00	AAPL	Stock	7.395	7.41	7.39	7.3932	91700.0
2010-01-22 08:00:00	AAPL	Stock	7.4232	7.435	7.4054	7.4179	1942752.0
2010-01-22 09:00:00	AAPL	Stock	7.4121	7.4346	7.3232	7.3682	108908744.0
2010-01-22 10:00:00	AAPL	Stock	7.3641	7.3671	7.2596	7.2982	138220012.0
2010-01-22 11:00:00	AAPL	Stock	7.3	7.3368	7.2893	7.2961	66231228.0
2010-01-22 12:00:00	AAPL	Stock	7.2982	7.3157	7.2757	7.2787	49627704.0
2010-01-22 13:00:00	AAPL	Stock	7.2793	7.2857	7.25	7.2571	60658080.0
2010-01-22 14:00:00	AAPL	Stock	7.2568	7.2736	7.1496	7.1693	132208048.0
2010-01-22 15:00:00	AAPL	Stock	7.17	7.1889	7.0414	7.0629	268098404.0
2010-01-22 16:00:00	AAPL	Stock	7.0557	7.3005	7.0554	7.1196	30524424.0
2010-01-22 17:00:00	AAPL	Stock	7.1205	7.1371	7.0564	7.1146	3926608.0
2010-01-22 18:00:00	AAPL	Stock	7.1193	7.1214	7.0625	7.0936	2717736.0
2010-01-22 19:00:00	AAPL	Stock	7.0962	7.0964	7.0754	7.0857	1138172.0
2010-01-22 20:00:00	AAPL	Stock	7.3136	7.3136	7.3136	7.3136	14000.0
2010-01-22 04:00:00	MSFT	Stock	30.06	30.06	30.06	30.06	600.0
2010-01-22 05:00:00	MSFT	Stock	29.96	29.99	29.96	29.99	900.0
2010-01-22 06:00:00	MSFT	Stock	29.96	29.99	29.88	29.88	1675.0
2010-01-22 07:00:00	MSFT	Stock	29.9	29.9	29.9	29.9	4950.0
2010-01-22 08:00:00	MSFT	Stock	30.0	30.03	29.93	30.01	7794.0
2010-01-22 09:00:00	MSFT	Stock	30.01	30.2	29.91	30.01	8169453.0
2010-01-22 10:00:00	MSFT	Stock	30.012	30.03	29.73	29.9	13651865.0
2010-01-22 11:00:00	MSFT	Stock	29.909	29.99	29.74	29.86	9643332.0
2010-01-22 12:00:00	MSFT	Stock	29.865	29.94	29.79	29.85	9601398.0
2010-01-22 13:00:00	MSFT	Stock	29.85	29.88	29.58	29.6	8414557.0
2010-01-22 14:00:00	MSFT	Stock	29.6	29.78	29.18	29.2	13531318.0
2010-01-22 15:00:00	MSFT	Stock	29.2	29.27	28.84	28.96	28850665.0
2010-01-22 16:00:00	MSFT	Stock	28.95	29.773	28.91	29.03	7528748.0
2010-01-22 17:00:00	MSFT	Stock	30.04	30.04	28.95	29.1	21766.0
2010-01-22 18:00:00	MSFT	Stock	29.05	29.08	28.93	29.0	29601.0
2010-01-22 19:00:00	MSFT	Stock	29.0	29.01	29.0	29.01	13633.0
2010-01-22 20:00:00	MSFT	Stock	29.81	29.81	29.81	29.81	48500.0
2010-01-22 06:00:00	NVDA	Stock	0.42	0.42	0.42	0.42	4000.0
2010-01-22 07:00:00	NVDA	Stock	0.4162	0.4168	0.4125	0.4125	168000.0
2010-01-22 08:00:00	NVDA	Stock	0.4192	0.4235	0.417	0.4213	716400.0
2010-01-22 09:00:00	NVDA	Stock	0.422	0.422	0.4148	0.4162	95156520.0
2010-01-22 10:00:00	NVDA	Stock	0.4162	0.422	0.4093	0.418	192462120.0
2010-01-22 11:00:00	NVDA	Stock	0.418	0.429	0.4178	0.4248	135586880.0
2010-01-22 12:00:00	NVDA	Stock	0.4248	0.4275	0.4222	0.423	51992760.0
2010-01-22 13:00:00	NVDA	Stock	0.423	0.4232	0.4192	0.4208	41340320.0
2010-01-22 14:00:00	NVDA	Stock	0.421	0.4232	0.414	0.4155	243130080.0
2010-01-22 15:00:00	NVDA	Stock	0.4155	0.4172	0.409	0.412	289265960.0
2010-01-22 16:00:00	NVDA	Stock	0.412	0.4171	0.4088	0.4088	2053200.0
2010-01-22 17:00:00	NVDA	Stock	0.41	0.4115	0.4088	0.4115	139600.0
2010-01-22 18:00:00	NVDA	Stock	0.412	0.412	0.4115	0.4115	36000.0
2010-01-22 19:00:00	NVDA	Stock	0.411	0.411	0.4088	0.4088	10400.0
2010-01-22 20:00:00	NVDA	Stock	0.4242	0.4242	0.4242	0.4242	56000.0
2010-01-22 07:00:00	AMZN	Stock	6.251	6.307	6.251	6.295	12000.0

> showing 50 of 43,453 rows — these rows as CSV

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