PREVIEW / stock_1hour / 2012-05-14

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-14.parquet
  size:    950 KB
  rows:    45,762
  symbols: 3,562

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-14 04:00:00	AAPL	Stock	20.1071	20.1071	20.0893	20.1071	22400.0
2012-05-14 06:00:00	AAPL	Stock	20.1346	20.1732	20.1196	20.1607	19600.0
2012-05-14 07:00:00	AAPL	Stock	20.1261	20.1875	20.0989	20.1571	191352.0
2012-05-14 08:00:00	AAPL	Stock	20.1768	20.1779	20.0893	20.1246	1436932.0
2012-05-14 09:00:00	AAPL	Stock	20.125	20.2682	20.0893	20.1621	61687752.0
2012-05-14 10:00:00	AAPL	Stock	20.163	20.1689	20.0714	20.1158	58305940.0
2012-05-14 11:00:00	AAPL	Stock	20.1171	20.1911	20.0893	20.1196	43064532.0
2012-05-14 12:00:00	AAPL	Stock	20.1211	20.1664	20.0979	20.1052	19545232.0
2012-05-14 13:00:00	AAPL	Stock	20.1057	20.1336	20.0275	20.1136	37538312.0
2012-05-14 14:00:00	AAPL	Stock	20.1111	20.1339	20.0293	20.0379	26561276.0
2012-05-14 15:00:00	AAPL	Stock	20.0429	20.0529	19.9143	19.9318	89130440.0
2012-05-14 16:00:00	AAPL	Stock	19.9354	20.0866	19.9229	19.95	9246104.0
2012-05-14 17:00:00	AAPL	Stock	19.9464	19.9589	19.9339	19.9504	623980.0
2012-05-14 18:00:00	AAPL	Stock	19.9536	19.9643	19.9486	19.9643	161728.0
2012-05-14 19:00:00	AAPL	Stock	19.9682	20.0357	19.9682	20.0357	272552.0
2012-05-14 07:00:00	MSFT	Stock	31.0	31.0	31.0	31.0	300.0
2012-05-14 08:00:00	MSFT	Stock	31.0	31.0	30.87	30.87	11547.0
2012-05-14 09:00:00	MSFT	Stock	30.91	30.92	30.7	30.8	3475713.0
2012-05-14 10:00:00	MSFT	Stock	30.81	30.83	30.65	30.76	5311935.0
2012-05-14 11:00:00	MSFT	Stock	30.76	30.93	30.715	30.91	3906059.0
2012-05-14 12:00:00	MSFT	Stock	30.905	30.98	30.79	30.81	2659654.0
2012-05-14 13:00:00	MSFT	Stock	30.82	30.99	30.76	30.95	3031082.0
2012-05-14 14:00:00	MSFT	Stock	30.95	31.04	30.71	30.727	4046946.0
2012-05-14 15:00:00	MSFT	Stock	30.73	30.82	30.64	30.67	11467069.0
2012-05-14 16:00:00	MSFT	Stock	30.67	30.78	30.665	30.69	6211107.0
2012-05-14 17:00:00	MSFT	Stock	30.7	30.72	30.68	30.72	49985.0
2012-05-14 18:00:00	MSFT	Stock	30.72	30.73	30.65	30.73	6472.0
2012-05-14 19:00:00	MSFT	Stock	30.73	30.78	30.73	30.73	10727.0
2012-05-14 04:00:00	NVDA	Stock	0.328	0.3355	0.328	0.3355	40000.0
2012-05-14 05:00:00	NVDA	Stock	0.359	0.359	0.3303	0.3303	24000.0
2012-05-14 06:00:00	NVDA	Stock	0.33	0.33	0.33	0.33	8000.0
2012-05-14 07:00:00	NVDA	Stock	0.3263	0.3263	0.3263	0.3263	16000.0
2012-05-14 08:00:00	NVDA	Stock	0.3288	0.33	0.3253	0.3288	340000.0
2012-05-14 09:00:00	NVDA	Stock	0.3288	0.329	0.3208	0.3283	76556400.0
2012-05-14 10:00:00	NVDA	Stock	0.3283	0.3333	0.3258	0.331	93096400.0
2012-05-14 11:00:00	NVDA	Stock	0.331	0.3318	0.3275	0.3298	55564720.0
2012-05-14 12:00:00	NVDA	Stock	0.3295	0.3308	0.3288	0.33	31663760.0
2012-05-14 13:00:00	NVDA	Stock	0.3301	0.331	0.328	0.3295	45685920.0
2012-05-14 14:00:00	NVDA	Stock	0.3295	0.33	0.3273	0.3278	39614000.0
2012-05-14 15:00:00	NVDA	Stock	0.3278	0.3295	0.327	0.328	80505600.0
2012-05-14 16:00:00	NVDA	Stock	0.3283	0.3285	0.3273	0.3283	12553880.0
2012-05-14 17:00:00	NVDA	Stock	0.3283	0.3283	0.3283	0.3283	444560.0
2012-05-14 18:00:00	NVDA	Stock	0.3275	0.3298	0.3275	0.3298	308000.0
2012-05-14 19:00:00	NVDA	Stock	0.328	0.328	0.328	0.328	4000.0
2012-05-14 08:00:00	AMZN	Stock	11.2975	11.36	11.274	11.2915	218660.0
2012-05-14 09:00:00	AMZN	Stock	11.2925	11.3645	11.1676	11.195	10416680.0
2012-05-14 10:00:00	AMZN	Stock	11.195	11.2605	11.1255	11.235	13543900.0
2012-05-14 11:00:00	AMZN	Stock	11.2344	11.281	11.1905	11.237	10602280.0
2012-05-14 12:00:00	AMZN	Stock	11.242	11.254	11.2155	11.231	2931420.0
2012-05-14 13:00:00	AMZN	Stock	11.231	11.2585	11.1735	11.2263	4201940.0

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

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