PREVIEW / stock_1hour / 2012-05-07

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-07.parquet
  size:    944 KB
  rows:    44,970
  symbols: 3,527

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
2012-05-07 04:00:00	AAPL	Stock	20.0714	20.0714	20.025	20.0325	44296.0
2012-05-07 05:00:00	AAPL	Stock	20.1029	20.125	20.1029	20.125	23800.0
2012-05-07 06:00:00	AAPL	Stock	20.1075	20.1607	20.1075	20.15	36680.0
2012-05-07 07:00:00	AAPL	Stock	20.1082	20.1082	20.0214	20.0964	1075312.0
2012-05-07 08:00:00	AAPL	Stock	20.0821	20.1232	20.0107	20.1054	3392984.0
2012-05-07 09:00:00	AAPL	Stock	20.1064	20.4561	20.0439	20.2725	117745292.0
2012-05-07 10:00:00	AAPL	Stock	20.2725	20.3311	20.0639	20.2059	99919176.0
2012-05-07 11:00:00	AAPL	Stock	20.2029	20.2375	20.0796	20.1464	43867348.0
2012-05-07 12:00:00	AAPL	Stock	20.1438	20.3186	20.1264	20.2743	47305048.0
2012-05-07 13:00:00	AAPL	Stock	20.2736	20.4071	20.2554	20.3911	44479876.0
2012-05-07 14:00:00	AAPL	Stock	20.3975	20.4339	20.3396	20.4125	42516348.0
2012-05-07 15:00:00	AAPL	Stock	20.4132	20.4368	20.2925	20.3443	48692420.0
2012-05-07 16:00:00	AAPL	Stock	20.3386	20.3876	20.136	20.3446	5228300.0
2012-05-07 17:00:00	AAPL	Stock	20.3468	20.3536	20.3221	20.3221	229544.0
2012-05-07 18:00:00	AAPL	Stock	20.3229	20.3339	20.3036	20.3339	174664.0
2012-05-07 19:00:00	AAPL	Stock	20.3311	20.3554	20.3264	20.35	106372.0
2012-05-07 04:00:00	MSFT	Stock	30.66	30.66	30.66	30.66	200.0
2012-05-07 05:00:00	MSFT	Stock	30.8	30.8	30.8	30.8	100.0
2012-05-07 06:00:00	MSFT	Stock	30.64	30.64	30.64	30.64	1950.0
2012-05-07 07:00:00	MSFT	Stock	30.7	30.74	30.7	30.72	5200.0
2012-05-07 08:00:00	MSFT	Stock	30.75	30.83	30.72	30.79	29440.0
2012-05-07 09:00:00	MSFT	Stock	30.79	30.79	30.57	30.67	6282870.0
2012-05-07 10:00:00	MSFT	Stock	30.66	30.85	30.61	30.78	7371546.0
2012-05-07 11:00:00	MSFT	Stock	30.785	30.84	30.69	30.76	4498470.0
2012-05-07 12:00:00	MSFT	Stock	30.76	30.81	30.725	30.76	3048471.0
2012-05-07 13:00:00	MSFT	Stock	30.76	30.86	30.76	30.821	3548419.0
2012-05-07 14:00:00	MSFT	Stock	30.83	30.86	30.75	30.79	4341071.0
2012-05-07 15:00:00	MSFT	Stock	30.785	30.8	30.65	30.66	8200072.0
2012-05-07 16:00:00	MSFT	Stock	30.65	30.77	30.64	30.69	10740050.0
2012-05-07 17:00:00	MSFT	Stock	30.69	30.74	30.65	30.74	5836.0
2012-05-07 18:00:00	MSFT	Stock	30.69	30.69	30.69	30.69	1000.0
2012-05-07 19:00:00	MSFT	Stock	30.69	30.85	30.69	30.85	2900.0
2012-05-07 07:00:00	NVDA	Stock	0.3073	0.3073	0.3073	0.3073	80000.0
2012-05-07 08:00:00	NVDA	Stock	0.3095	0.3095	0.3062	0.3075	372000.0
2012-05-07 09:00:00	NVDA	Stock	0.3085	0.3148	0.3085	0.3144	90399680.0
2012-05-07 10:00:00	NVDA	Stock	0.3143	0.3163	0.312	0.3139	87277800.0
2012-05-07 11:00:00	NVDA	Stock	0.314	0.3163	0.3138	0.3153	58585520.0
2012-05-07 12:00:00	NVDA	Stock	0.315	0.316	0.314	0.3148	110459960.0
2012-05-07 13:00:00	NVDA	Stock	0.315	0.3173	0.3143	0.3145	56859040.0
2012-05-07 14:00:00	NVDA	Stock	0.3146	0.315	0.3128	0.3134	42418760.0
2012-05-07 15:00:00	NVDA	Stock	0.3135	0.3138	0.3105	0.3118	120076760.0
2012-05-07 16:00:00	NVDA	Stock	0.3116	0.313	0.3107	0.3118	9522760.0
2012-05-07 17:00:00	NVDA	Stock	0.3118	0.3118	0.3118	0.3118	63800.0
2012-05-07 18:00:00	NVDA	Stock	0.3118	0.3118	0.3118	0.3118	36400.0
2012-05-07 19:00:00	NVDA	Stock	0.3138	0.3138	0.3138	0.3138	20000.0
2012-05-07 04:00:00	AMZN	Stock	11.0625	11.0625	11.051	11.051	36000.0
2012-05-07 05:00:00	AMZN	Stock	11.1175	11.1175	11.1175	11.1175	13000.0
2012-05-07 06:00:00	AMZN	Stock	11.1175	11.1175	11.1175	11.1175	6000.0
2012-05-07 07:00:00	AMZN	Stock	11.0875	11.108	11.0875	11.107	54880.0
2012-05-07 08:00:00	AMZN	Stock	11.1025	11.14	11.0875	11.13	228640.0

> showing 50 of 44,970 rows — these rows as CSV

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