PREVIEW / stock_1hour / 2013-03-01

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-03-01.parquet
  size:    963 KB
  rows:    45,051
  symbols: 3,460

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
2013-03-01 04:00:00	AAPL	Stock	15.8371	15.8371	15.8371	15.8371	2800.0
2013-03-01 05:00:00	AAPL	Stock	15.7911	15.7911	15.7589	15.7589	11200.0
2013-03-01 06:00:00	AAPL	Stock	15.7232	15.7232	15.7143	15.7143	18676.0
2013-03-01 07:00:00	AAPL	Stock	15.7143	15.7179	15.6554	15.6554	211372.0
2013-03-01 08:00:00	AAPL	Stock	15.6675	15.7679	15.6175	15.6321	4286912.0
2013-03-01 09:00:00	AAPL	Stock	15.6329	15.6554	15.4446	15.4932	115926440.0
2013-03-01 10:00:00	AAPL	Stock	15.4929	15.5596	15.4243	15.5271	102201680.0
2013-03-01 11:00:00	AAPL	Stock	15.5311	15.597	15.4593	15.5069	66292352.0
2013-03-01 12:00:00	AAPL	Stock	15.5071	15.5707	15.4986	15.5263	38098816.0
2013-03-01 13:00:00	AAPL	Stock	15.5314	15.539	15.4029	15.4442	47697552.0
2013-03-01 14:00:00	AAPL	Stock	15.4439	15.4714	15.3846	15.4014	54827332.0
2013-03-01 15:00:00	AAPL	Stock	15.3993	15.4386	15.3564	15.3724	97669012.0
2013-03-01 16:00:00	AAPL	Stock	15.3754	15.498	15.3546	15.3557	14898996.0
2013-03-01 17:00:00	AAPL	Stock	15.3557	15.3786	15.3557	15.375	1461628.0
2013-03-01 18:00:00	AAPL	Stock	15.375	15.375	15.3693	15.3714	172620.0
2013-03-01 19:00:00	AAPL	Stock	15.375	15.375	15.3571	15.3646	678384.0
2013-03-01 04:00:00	MSFT	Stock	27.73	27.73	27.73	27.73	400.0
2013-03-01 05:00:00	MSFT	Stock	27.72	27.72	27.72	27.72	100.0
2013-03-01 06:00:00	MSFT	Stock	27.72	27.72	27.72	27.72	400.0
2013-03-01 07:00:00	MSFT	Stock	27.71	27.71	27.65	27.65	718.0
2013-03-01 08:00:00	MSFT	Stock	27.7	27.77	27.63	27.7	16178.0
2013-03-01 09:00:00	MSFT	Stock	27.8	27.8	27.52	27.56	4420117.0
2013-03-01 10:00:00	MSFT	Stock	27.56	27.91	27.56	27.9	5815052.0
2013-03-01 11:00:00	MSFT	Stock	27.905	27.965	27.7	27.75	3506963.0
2013-03-01 12:00:00	MSFT	Stock	27.75	27.95	27.75	27.93	3451672.0
2013-03-01 13:00:00	MSFT	Stock	27.93	27.97	27.88	27.92	2404195.0
2013-03-01 14:00:00	MSFT	Stock	27.92	27.94	27.85	27.9	2870121.0
2013-03-01 15:00:00	MSFT	Stock	27.895	27.98	27.88	27.94	9154461.0
2013-03-01 16:00:00	MSFT	Stock	27.95	27.95	27.8	27.92	2412065.0
2013-03-01 17:00:00	MSFT	Stock	27.88	27.95	27.88	27.88	26850.0
2013-03-01 18:00:00	MSFT	Stock	27.92	27.92	27.9	27.9	800.0
2013-03-01 19:00:00	MSFT	Stock	27.9	27.92	27.9	27.92	1791.0
2013-03-01 08:00:00	NVDA	Stock	0.315	0.315	0.3133	0.3143	394000.0
2013-03-01 09:00:00	NVDA	Stock	0.3143	0.315	0.3114	0.3138	50752280.0
2013-03-01 10:00:00	NVDA	Stock	0.3136	0.3163	0.3131	0.3163	73486160.0
2013-03-01 11:00:00	NVDA	Stock	0.3163	0.3178	0.3148	0.3163	57173440.0
2013-03-01 12:00:00	NVDA	Stock	0.316	0.3184	0.316	0.3178	44853120.0
2013-03-01 13:00:00	NVDA	Stock	0.3178	0.3188	0.3163	0.3174	40876800.0
2013-03-01 14:00:00	NVDA	Stock	0.3175	0.3183	0.3165	0.3171	33584280.0
2013-03-01 15:00:00	NVDA	Stock	0.3173	0.318	0.3163	0.318	77104080.0
2013-03-01 16:00:00	NVDA	Stock	0.3178	0.3178	0.3164	0.3178	11128800.0
2013-03-01 04:00:00	AMZN	Stock	13.162	13.162	13.162	13.162	2000.0
2013-03-01 05:00:00	AMZN	Stock	13.1595	13.184	13.134	13.134	8000.0
2013-03-01 06:00:00	AMZN	Stock	13.1295	13.1295	13.113	13.113	10000.0
2013-03-01 07:00:00	AMZN	Stock	13.11	13.125	13.0865	13.1035	20400.0
2013-03-01 08:00:00	AMZN	Stock	13.117	13.2135	13.113	13.175	240440.0
2013-03-01 09:00:00	AMZN	Stock	13.1345	13.2	13.052	13.108	9037900.0
2013-03-01 10:00:00	AMZN	Stock	13.109	13.2435	13.1061	13.237	10724520.0
2013-03-01 11:00:00	AMZN	Stock	13.238	13.268	13.0755	13.1505	9190360.0
2013-03-01 12:00:00	AMZN	Stock	13.1525	13.2555	13.1498	13.246	5009980.0

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

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