PREVIEW / stock_1hour / 2011-12-20

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-12-20.parquet
  size:    949 KB
  rows:    45,295
  symbols: 3,591

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
2011-12-20 07:00:00	AAPL	Stock	13.7589	13.8068	13.75	13.7857	404824.0
2011-12-20 08:00:00	AAPL	Stock	13.7718	13.7964	13.7561	13.7907	1174404.0
2011-12-20 09:00:00	AAPL	Stock	13.7893	13.9125	13.7879	13.8871	56484764.0
2011-12-20 10:00:00	AAPL	Stock	13.8839	14.0157	13.8836	14.0136	51679796.0
2011-12-20 11:00:00	AAPL	Stock	14.0139	14.0846	14.0114	14.0593	54090652.0
2011-12-20 12:00:00	AAPL	Stock	14.06	14.0725	14.0414	14.0704	20731340.0
2011-12-20 13:00:00	AAPL	Stock	14.0704	14.1054	14.0704	14.0825	28351456.0
2011-12-20 14:00:00	AAPL	Stock	14.0825	14.1043	14.0579	14.0993	26934404.0
2011-12-20 15:00:00	AAPL	Stock	14.0975	14.1464	14.0821	14.1464	68514768.0
2011-12-20 16:00:00	AAPL	Stock	14.1432	14.1492	13.9981	14.1143	24339420.0
2011-12-20 17:00:00	AAPL	Stock	14.1143	14.1164	14.1029	14.1132	510356.0
2011-12-20 18:00:00	AAPL	Stock	14.115	14.1411	14.1146	14.1221	434560.0
2011-12-20 19:00:00	AAPL	Stock	14.1279	14.1318	14.1196	14.1318	154140.0
2011-12-20 04:00:00	MSFT	Stock	25.62	25.62	25.62	25.62	3410.0
2011-12-20 07:00:00	MSFT	Stock	25.72	25.86	25.7	25.8	17656.0
2011-12-20 08:00:00	MSFT	Stock	25.8	25.84	25.75	25.82	64840.0
2011-12-20 09:00:00	MSFT	Stock	25.82	26.0	25.8	25.9	9471418.0
2011-12-20 10:00:00	MSFT	Stock	25.9	26.05	25.88	25.99	8420632.0
2011-12-20 11:00:00	MSFT	Stock	25.99	26.1	25.925	26.002	6095556.0
2011-12-20 12:00:00	MSFT	Stock	26.0	26.04	25.97	25.995	3930008.0
2011-12-20 13:00:00	MSFT	Stock	25.995	26.085	25.99	26.043	5710562.0
2011-12-20 14:00:00	MSFT	Stock	26.042	26.06	25.98	26.0	5501377.0
2011-12-20 15:00:00	MSFT	Stock	25.995	26.05	25.97	26.04	12352200.0
2011-12-20 16:00:00	MSFT	Stock	26.03	26.055	25.8	25.9	8268096.0
2011-12-20 17:00:00	MSFT	Stock	25.91	25.92	25.88	25.89	3900.0
2011-12-20 18:00:00	MSFT	Stock	25.9	26.02	25.89	25.93	19204.0
2011-12-20 19:00:00	MSFT	Stock	25.93	25.95	25.88	25.88	16128.0
2011-12-20 07:00:00	NVDA	Stock	0.337	0.337	0.337	0.337	20000.0
2011-12-20 08:00:00	NVDA	Stock	0.337	0.337	0.3353	0.3353	44000.0
2011-12-20 09:00:00	NVDA	Stock	0.337	0.3422	0.3362	0.3408	44826000.0
2011-12-20 10:00:00	NVDA	Stock	0.3409	0.3462	0.3405	0.345	63910360.0
2011-12-20 11:00:00	NVDA	Stock	0.3448	0.3488	0.3448	0.348	53461560.0
2011-12-20 12:00:00	NVDA	Stock	0.3481	0.3484	0.3465	0.3468	44548000.0
2011-12-20 13:00:00	NVDA	Stock	0.3468	0.3484	0.3468	0.347	30448160.0
2011-12-20 14:00:00	NVDA	Stock	0.347	0.3475	0.3453	0.347	34498000.0
2011-12-20 15:00:00	NVDA	Stock	0.3469	0.348	0.3465	0.3475	84536200.0
2011-12-20 16:00:00	NVDA	Stock	0.3475	0.352	0.3458	0.349	2895560.0
2011-12-20 17:00:00	NVDA	Stock	0.3478	0.3478	0.3475	0.3475	74000.0
2011-12-20 18:00:00	NVDA	Stock	0.3475	0.3482	0.347	0.3482	37762160.0
2011-12-20 19:00:00	NVDA	Stock	0.3475	0.3482	0.3462	0.3482	276000.0
2011-12-20 07:00:00	AMZN	Stock	9.055	9.0885	9.05	9.0615	45800.0
2011-12-20 08:00:00	AMZN	Stock	9.085	9.102	9.038	9.094	273240.0
2011-12-20 09:00:00	AMZN	Stock	9.0915	9.1605	9.0785	9.1	15431100.0
2011-12-20 10:00:00	AMZN	Stock	9.1	9.115	9.027	9.0335	16702600.0
2011-12-20 11:00:00	AMZN	Stock	9.036	9.1125	9.0315	9.0945	12808220.0
2011-12-20 12:00:00	AMZN	Stock	9.1	9.1435	9.0865	9.1315	7278780.0
2011-12-20 13:00:00	AMZN	Stock	9.132	9.1585	9.092	9.1085	8451760.0
2011-12-20 14:00:00	AMZN	Stock	9.1085	9.129	9.1022	9.1225	6608380.0
2011-12-20 15:00:00	AMZN	Stock	9.1215	9.1345	9.0925	9.128	18446000.0
2011-12-20 16:00:00	AMZN	Stock	9.1215	9.138	9.0525	9.1305	4299760.0

> showing 50 of 45,295 rows — these rows as CSV

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