PREVIEW / stock_1hour / 2010-12-01

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-01.parquet
  size:    966 KB
  rows:    46,356
  symbols: 3,531

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-12-01 04:00:00	AAPL	Stock	11.1786	11.1786	11.1786	11.1786	11200.0
2010-12-01 05:00:00	AAPL	Stock	11.1982	11.2196	11.1982	11.2196	9800.0
2010-12-01 06:00:00	AAPL	Stock	11.2196	11.2411	11.1957	11.2411	48300.0
2010-12-01 07:00:00	AAPL	Stock	11.2393	11.2482	11.2004	11.2182	1474564.0
2010-12-01 08:00:00	AAPL	Stock	11.2186	11.2411	11.2075	11.2361	6191752.0
2010-12-01 09:00:00	AAPL	Stock	11.2361	11.3032	11.2357	11.2986	85223264.0
2010-12-01 10:00:00	AAPL	Stock	11.2996	11.3139	11.2646	11.3029	73579688.0
2010-12-01 11:00:00	AAPL	Stock	11.3032	11.3318	11.2882	11.3286	50565956.0
2010-12-01 12:00:00	AAPL	Stock	11.3296	11.3368	11.3143	11.3304	45247244.0
2010-12-01 13:00:00	AAPL	Stock	11.3305	11.3482	11.3032	11.3264	50058176.0
2010-12-01 14:00:00	AAPL	Stock	11.3261	11.3425	11.3111	11.3279	37690212.0
2010-12-01 15:00:00	AAPL	Stock	11.3269	11.3272	11.2936	11.3114	68553772.0
2010-12-01 16:00:00	AAPL	Stock	11.3114	11.3214	11.2929	11.2932	36717156.0
2010-12-01 17:00:00	AAPL	Stock	11.3218	11.3218	11.2929	11.2989	1090824.0
2010-12-01 18:00:00	AAPL	Stock	11.2993	11.3036	11.2929	11.2964	944048.0
2010-12-01 19:00:00	AAPL	Stock	11.2946	11.2946	11.2568	11.2579	1400840.0
2010-12-01 06:00:00	MSFT	Stock	25.46	25.47	25.46	25.47	200.0
2010-12-01 07:00:00	MSFT	Stock	25.45	25.45	25.34	25.41	13732.0
2010-12-01 08:00:00	MSFT	Stock	25.41	25.49	25.36	25.48	94599.0
2010-12-01 09:00:00	MSFT	Stock	25.49	25.91	25.47	25.88	10672142.0
2010-12-01 10:00:00	MSFT	Stock	25.88	25.97	25.85	25.87	15311973.0
2010-12-01 11:00:00	MSFT	Stock	25.87	26.0	25.82	25.98	8572681.0
2010-12-01 12:00:00	MSFT	Stock	25.985	26.15	25.98	26.13	6820791.0
2010-12-01 13:00:00	MSFT	Stock	26.131	26.23	26.1	26.162	8657552.0
2010-12-01 14:00:00	MSFT	Stock	26.17	26.25	26.13	26.24	6165666.0
2010-12-01 15:00:00	MSFT	Stock	26.25	26.25	26.03	26.05	11006609.0
2010-12-01 16:00:00	MSFT	Stock	26.04	26.18	25.983	26.0	3964868.0
2010-12-01 17:00:00	MSFT	Stock	26.015	26.05	26.0	26.01	81538.0
2010-12-01 18:00:00	MSFT	Stock	26.02	26.04	26.0	26.03	86101.0
2010-12-01 19:00:00	MSFT	Stock	26.0	26.03	26.0	26.02	1035.0
2010-12-01 08:00:00	NVDA	Stock	0.3448	0.345	0.3448	0.3448	129200.0
2010-12-01 09:00:00	NVDA	Stock	0.3445	0.355	0.3445	0.354	106321840.0
2010-12-01 10:00:00	NVDA	Stock	0.354	0.3574	0.3525	0.3554	152054160.0
2010-12-01 11:00:00	NVDA	Stock	0.3555	0.356	0.3542	0.3555	69932640.0
2010-12-01 12:00:00	NVDA	Stock	0.3555	0.3564	0.3542	0.3552	66915600.0
2010-12-01 13:00:00	NVDA	Stock	0.3553	0.3562	0.3551	0.3556	47460280.0
2010-12-01 14:00:00	NVDA	Stock	0.3558	0.3568	0.355	0.3564	49827240.0
2010-12-01 15:00:00	NVDA	Stock	0.3562	0.3565	0.3545	0.3548	109396760.0
2010-12-01 16:00:00	NVDA	Stock	0.3545	0.3555	0.3396	0.3548	4649800.0
2010-12-01 17:00:00	NVDA	Stock	0.355	0.3553	0.3548	0.3548	503520.0
2010-12-01 18:00:00	NVDA	Stock	0.355	0.355	0.355	0.355	12000.0
2010-12-01 04:00:00	AMZN	Stock	8.76	8.76	8.76	8.76	2000.0
2010-12-01 05:00:00	AMZN	Stock	8.8605	8.8605	8.8605	8.8605	2000.0
2010-12-01 06:00:00	AMZN	Stock	8.902	8.9025	8.902	8.9025	4000.0
2010-12-01 07:00:00	AMZN	Stock	8.938	8.938	8.875	8.8805	34000.0
2010-12-01 08:00:00	AMZN	Stock	8.902	8.9745	8.77	8.9405	1085840.0
2010-12-01 09:00:00	AMZN	Stock	8.9445	8.977	8.883	8.9252	21134380.0
2010-12-01 10:00:00	AMZN	Stock	8.9275	8.936	8.878	8.931	18304300.0
2010-12-01 11:00:00	AMZN	Stock	8.928	8.9545	8.922	8.945	12073500.0
2010-12-01 12:00:00	AMZN	Stock	8.943	8.952	8.88	8.8995	10900360.0

> showing 50 of 46,356 rows — these rows as CSV

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