PREVIEW / stock_1hour / 2010-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-27.parquet
  size:    895 KB
  rows:    42,815
  symbols: 3,435

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-27 04:00:00	AAPL	Stock	7.3961	7.4054	7.3954	7.4054	39200.0
2010-01-27 05:00:00	AAPL	Stock	7.4132	7.4264	7.4132	7.4264	63952.0
2010-01-27 06:00:00	AAPL	Stock	7.4246	7.4464	7.4189	7.4321	144144.0
2010-01-27 07:00:00	AAPL	Stock	7.42	7.4386	7.3786	7.4036	2141020.0
2010-01-27 08:00:00	AAPL	Stock	7.4021	7.4089	7.355	7.3768	7567168.0
2010-01-27 09:00:00	AAPL	Stock	7.3764	7.4011	7.2768	7.3496	146049736.0
2010-01-27 10:00:00	AAPL	Stock	7.3496	7.3632	7.2071	7.2832	186770528.0
2010-01-27 11:00:00	AAPL	Stock	7.2843	7.2911	7.2246	7.2604	82301296.0
2010-01-27 12:00:00	AAPL	Stock	7.2604	7.3321	7.2357	7.3079	117338256.0
2010-01-27 13:00:00	AAPL	Stock	7.3095	7.3286	7.1261	7.2393	365034544.0
2010-01-27 14:00:00	AAPL	Stock	7.2382	7.5207	7.235	7.4882	491045380.0
2010-01-27 15:00:00	AAPL	Stock	7.4882	7.4907	7.3365	7.4275	288462216.0
2010-01-27 16:00:00	AAPL	Stock	7.4236	7.4418	7.2536	7.4171	22564024.0
2010-01-27 17:00:00	AAPL	Stock	7.4143	7.4211	7.4064	7.4107	1079428.0
2010-01-27 18:00:00	AAPL	Stock	7.4136	7.4279	7.4093	7.4125	482048.0
2010-01-27 19:00:00	AAPL	Stock	7.4111	7.4193	7.3929	7.3964	777112.0
2010-01-27 07:00:00	MSFT	Stock	29.49	29.49	29.49	29.49	1000.0
2010-01-27 08:00:00	MSFT	Stock	29.54	29.57	29.49	29.49	23457.0
2010-01-27 09:00:00	MSFT	Stock	29.53	29.72	29.28	29.57	6401936.0
2010-01-27 10:00:00	MSFT	Stock	29.56	29.59	29.02	29.395	10282683.0
2010-01-27 11:00:00	MSFT	Stock	29.39	29.52	29.35	29.455	5185522.0
2010-01-27 12:00:00	MSFT	Stock	29.45	29.53	29.43	29.438	5119712.0
2010-01-27 13:00:00	MSFT	Stock	29.44	29.49	29.4	29.45	4861069.0
2010-01-27 14:00:00	MSFT	Stock	29.45	29.73	29.29	29.6	10279932.0
2010-01-27 15:00:00	MSFT	Stock	29.6	29.82	29.38	29.67	12494449.0
2010-01-27 16:00:00	MSFT	Stock	29.68	29.71	29.496	29.65	7045963.0
2010-01-27 17:00:00	MSFT	Stock	29.65	29.72	29.63	29.72	11009.0
2010-01-27 18:00:00	MSFT	Stock	29.71	29.73	29.7	29.73	4391.0
2010-01-27 19:00:00	MSFT	Stock	29.71	29.73	29.7	29.72	7441.0
2010-01-27 08:00:00	NVDA	Stock	0.4062	0.4062	0.4062	0.4062	43040.0
2010-01-27 09:00:00	NVDA	Stock	0.4062	0.4173	0.4035	0.4062	116042800.0
2010-01-27 10:00:00	NVDA	Stock	0.4062	0.407	0.4005	0.4068	156526960.0
2010-01-27 11:00:00	NVDA	Stock	0.4065	0.4102	0.4048	0.4095	119615080.0
2010-01-27 12:00:00	NVDA	Stock	0.4095	0.4112	0.408	0.409	64883600.0
2010-01-27 13:00:00	NVDA	Stock	0.4092	0.411	0.4078	0.4104	69071200.0
2010-01-27 14:00:00	NVDA	Stock	0.4102	0.4162	0.4098	0.415	116693280.0
2010-01-27 15:00:00	NVDA	Stock	0.415	0.4178	0.4118	0.416	152082560.0
2010-01-27 16:00:00	NVDA	Stock	0.4162	0.4165	0.4099	0.4162	12983160.0
2010-01-27 17:00:00	NVDA	Stock	0.4173	0.4173	0.414	0.414	9840.0
2010-01-27 18:00:00	NVDA	Stock	0.4155	0.4155	0.4155	0.4155	20000.0
2010-01-27 19:00:00	NVDA	Stock	0.4155	0.4155	0.4155	0.4155	7200.0
2010-01-27 04:00:00	AMZN	Stock	5.975	5.975	5.975	5.975	2000.0
2010-01-27 05:00:00	AMZN	Stock	5.9605	6.05	5.9565	6.05	77540.0
2010-01-27 06:00:00	AMZN	Stock	6.05	6.088	6.05	6.0745	35740.0
2010-01-27 07:00:00	AMZN	Stock	6.075	6.0975	6.058	6.0725	203840.0
2010-01-27 08:00:00	AMZN	Stock	5.975	6.075	5.974	6.05	648000.0
2010-01-27 09:00:00	AMZN	Stock	6.0525	6.1343	6.021	6.107	40083320.0
2010-01-27 10:00:00	AMZN	Stock	6.102	6.145	6.0606	6.1385	45817540.0
2010-01-27 11:00:00	AMZN	Stock	6.141	6.1645	6.117	6.135	23785900.0
2010-01-27 12:00:00	AMZN	Stock	6.136	6.1395	6.0905	6.095	14573700.0

> showing 50 of 42,815 rows — these rows as CSV

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