PREVIEW / stock_1hour / 2010-05-20

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-20.parquet
  size:    971 KB
  rows:    46,456
  symbols: 3,513

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-05-20 04:00:00	AAPL	Stock	8.8571	8.8607	8.8571	8.8607	19600.0
2010-05-20 05:00:00	AAPL	Stock	8.8804	8.8804	8.8536	8.8536	28000.0
2010-05-20 06:00:00	AAPL	Stock	8.8411	8.8411	8.8411	8.8411	3108.0
2010-05-20 07:00:00	AAPL	Stock	8.8036	8.8304	8.6993	8.7143	985684.0
2010-05-20 08:00:00	AAPL	Stock	8.71	8.7375	8.6154	8.6536	9254980.0
2010-05-20 09:00:00	AAPL	Stock	8.6536	8.6921	8.5893	8.6404	152703936.0
2010-05-20 10:00:00	AAPL	Stock	8.6393	8.6739	8.5018	8.5541	243743276.0
2010-05-20 11:00:00	AAPL	Stock	8.5536	8.6412	8.5493	8.5939	138549768.0
2010-05-20 12:00:00	AAPL	Stock	8.5914	8.6071	8.4364	8.4439	125169828.0
2010-05-20 13:00:00	AAPL	Stock	8.4407	8.6121	8.4361	8.5629	168886872.0
2010-05-20 14:00:00	AAPL	Stock	8.5618	8.7089	8.5143	8.6339	206381616.0
2010-05-20 15:00:00	AAPL	Stock	8.6368	8.6582	8.4704	8.4846	206877216.0
2010-05-20 16:00:00	AAPL	Stock	8.4821	8.5899	8.4357	8.4732	17285772.0
2010-05-20 17:00:00	AAPL	Stock	8.4739	8.4821	8.4146	8.4207	2577764.0
2010-05-20 18:00:00	AAPL	Stock	8.4164	8.4914	8.3679	8.3839	2253020.0
2010-05-20 19:00:00	AAPL	Stock	8.3929	8.4018	8.3679	8.3929	1232616.0
2010-05-20 06:00:00	MSFT	Stock	27.85	27.85	27.85	27.85	2000.0
2010-05-20 07:00:00	MSFT	Stock	27.91	28.04	27.81	27.81	12739.0
2010-05-20 08:00:00	MSFT	Stock	27.9	28.288	27.62	27.69	52333.0
2010-05-20 09:00:00	MSFT	Stock	27.68	27.85	27.42	27.74	6046294.0
2010-05-20 10:00:00	MSFT	Stock	27.74	27.82	27.27	27.29	15917651.0
2010-05-20 11:00:00	MSFT	Stock	27.28	27.69	27.18	27.51	13548282.0
2010-05-20 12:00:00	MSFT	Stock	27.51	27.56	27.19	27.2	6677725.0
2010-05-20 13:00:00	MSFT	Stock	27.2	27.6	27.04	27.48	9626346.0
2010-05-20 14:00:00	MSFT	Stock	27.48	27.69	27.25	27.444	11835699.0
2010-05-20 15:00:00	MSFT	Stock	27.45	27.56	27.11	27.11	17413498.0
2010-05-20 16:00:00	MSFT	Stock	27.12	28.255	27.0	27.08	4427974.0
2010-05-20 17:00:00	MSFT	Stock	27.09	27.09	26.92	26.95	15996.0
2010-05-20 18:00:00	MSFT	Stock	26.95	27.11	26.84	26.9	60944.0
2010-05-20 19:00:00	MSFT	Stock	26.9	26.95	26.83	26.85	15221.0
2010-05-20 20:00:00	MSFT	Stock	27.48	27.48	27.48	27.48	900.0
2010-05-20 08:00:00	NVDA	Stock	0.3188	0.3188	0.3052	0.31	361200.0
2010-05-20 09:00:00	NVDA	Stock	0.31	0.3113	0.3035	0.3035	106548840.0
2010-05-20 10:00:00	NVDA	Stock	0.3036	0.308	0.3002	0.3075	223605200.0
2010-05-20 11:00:00	NVDA	Stock	0.3075	0.3113	0.3042	0.3098	136940760.0
2010-05-20 12:00:00	NVDA	Stock	0.3098	0.3103	0.3038	0.304	67953960.0
2010-05-20 13:00:00	NVDA	Stock	0.3038	0.3133	0.3038	0.3118	137016360.0
2010-05-20 14:00:00	NVDA	Stock	0.3118	0.319	0.3103	0.3163	178161960.0
2010-05-20 15:00:00	NVDA	Stock	0.3163	0.3178	0.3108	0.3108	250990480.0
2010-05-20 16:00:00	NVDA	Stock	0.3108	0.3194	0.3093	0.3095	20339760.0
2010-05-20 17:00:00	NVDA	Stock	0.3095	0.3138	0.3095	0.3095	105280.0
2010-05-20 18:00:00	NVDA	Stock	0.3088	0.3088	0.3038	0.3039	279240.0
2010-05-20 19:00:00	NVDA	Stock	0.3045	0.305	0.3035	0.3042	352000.0
2010-05-20 07:00:00	AMZN	Stock	6.136	6.136	6.135	6.135	10000.0
2010-05-20 08:00:00	AMZN	Stock	6.161	6.1875	6.071	6.073	290900.0
2010-05-20 09:00:00	AMZN	Stock	6.088	6.25	6.0705	6.1835	17835400.0
2010-05-20 10:00:00	AMZN	Stock	6.1835	6.205	6.0845	6.141	37024480.0
2010-05-20 11:00:00	AMZN	Stock	6.1412	6.161	6.097	6.1015	20580220.0
2010-05-20 12:00:00	AMZN	Stock	6.103	6.126	5.9465	5.9475	21009880.0
2010-05-20 13:00:00	AMZN	Stock	5.9475	6.0845	5.939	6.0195	20529880.0

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

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