PREVIEW / stock_1hour / 2015-05-12

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-05-12.parquet
  size:    1.0 MB
  rows:    49,201
  symbols: 3,482

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
2015-05-12 04:00:00	AAPL	Stock	31.535	31.535	31.335	31.335	25344.0
2015-05-12 05:00:00	AAPL	Stock	31.3225	31.375	31.3	31.3	31808.0
2015-05-12 06:00:00	AAPL	Stock	31.3	31.34	31.2775	31.3375	81528.0
2015-05-12 07:00:00	AAPL	Stock	31.3275	31.4375	31.3275	31.4	219428.0
2015-05-12 08:00:00	AAPL	Stock	31.4	31.455	31.3	31.42	797024.0
2015-05-12 09:00:00	AAPL	Stock	31.4225	31.4525	31.205	31.2775	29599740.0
2015-05-12 10:00:00	AAPL	Stock	31.2775	31.505	31.2175	31.4175	31114528.0
2015-05-12 11:00:00	AAPL	Stock	31.4175	31.6225	31.4025	31.5625	22851528.0
2015-05-12 12:00:00	AAPL	Stock	31.5625	31.5975	31.4425	31.5832	15818124.0
2015-05-12 13:00:00	AAPL	Stock	31.585	31.72	31.573	31.6272	17824596.0
2015-05-12 14:00:00	AAPL	Stock	31.6275	31.6975	31.5338	31.56	14481792.0
2015-05-12 15:00:00	AAPL	Stock	31.5625	31.61	31.465	31.465	22887312.0
2015-05-12 16:00:00	AAPL	Stock	31.4662	31.5832	31.1898	31.4575	22638604.0
2015-05-12 17:00:00	AAPL	Stock	31.455	31.485	31.445	31.4725	152396.0
2015-05-12 18:00:00	AAPL	Stock	31.475	31.4925	31.475	31.4898	141160.0
2015-05-12 19:00:00	AAPL	Stock	31.49	31.5175	31.4875	31.51	79236.0
2015-05-12 04:00:00	MSFT	Stock	47.14	47.14	47.14	47.14	200.0
2015-05-12 05:00:00	MSFT	Stock	46.86	46.86	46.85	46.85	1170.0
2015-05-12 06:00:00	MSFT	Stock	46.85	46.85	46.85	46.85	100.0
2015-05-12 07:00:00	MSFT	Stock	46.91	46.92	46.84	46.86	6770.0
2015-05-12 08:00:00	MSFT	Stock	47.05	47.12	46.9	47.1	26670.0
2015-05-12 09:00:00	MSFT	Stock	47.1	47.1	46.42	46.575	4462497.0
2015-05-12 10:00:00	MSFT	Stock	46.575	47.03	46.5	46.99	4638068.0
2015-05-12 11:00:00	MSFT	Stock	46.99	47.45	46.99	47.34	2931195.0
2015-05-12 12:00:00	MSFT	Stock	47.34	47.49	47.22	47.47	2051825.0
2015-05-12 13:00:00	MSFT	Stock	47.47	47.61	47.36	47.48	2381816.0
2015-05-12 14:00:00	MSFT	Stock	47.49	47.68	47.45	47.53	2851595.0
2015-05-12 15:00:00	MSFT	Stock	47.54	47.57	47.32	47.35	4768717.0
2015-05-12 16:00:00	MSFT	Stock	47.35	47.4	46.437	47.37	4028647.0
2015-05-12 17:00:00	MSFT	Stock	47.37	47.37	47.35	47.35	2300.0
2015-05-12 18:00:00	MSFT	Stock	47.36	47.36	47.36	47.36	200.0
2015-05-12 19:00:00	MSFT	Stock	47.44	47.44	47.44	47.44	500.0
2015-05-12 08:00:00	NVDA	Stock	0.5055	0.5102	0.5055	0.5102	38960.0
2015-05-12 09:00:00	NVDA	Stock	0.5102	0.519	0.51	0.5176	40411160.0
2015-05-12 10:00:00	NVDA	Stock	0.5175	0.52	0.5142	0.5195	57725280.0
2015-05-12 11:00:00	NVDA	Stock	0.5194	0.522	0.5186	0.5202	58142800.0
2015-05-12 12:00:00	NVDA	Stock	0.52	0.525	0.52	0.5242	45636080.0
2015-05-12 13:00:00	NVDA	Stock	0.524	0.5247	0.5232	0.5242	42168720.0
2015-05-12 14:00:00	NVDA	Stock	0.5244	0.5245	0.521	0.521	38997680.0
2015-05-12 15:00:00	NVDA	Stock	0.5211	0.5225	0.5204	0.5207	62508040.0
2015-05-12 16:00:00	NVDA	Stock	0.5207	0.5218	0.5207	0.5213	31854440.0
2015-05-12 17:00:00	NVDA	Stock	0.5207	0.5207	0.5207	0.5207	140160.0
2015-05-12 18:00:00	NVDA	Stock	0.5207	0.5207	0.5207	0.5207	4000.0
2015-05-12 05:00:00	AMZN	Stock	21.3885	21.3885	21.3885	21.3885	10000.0
2015-05-12 07:00:00	AMZN	Stock	21.4225	21.458	21.4225	21.428	39800.0
2015-05-12 08:00:00	AMZN	Stock	21.47	21.625	21.4376	21.4756	74720.0
2015-05-12 09:00:00	AMZN	Stock	21.515	21.5685	21.3355	21.427	8437260.0
2015-05-12 10:00:00	AMZN	Stock	21.4265	21.5975	21.375	21.539	7564360.0
2015-05-12 11:00:00	AMZN	Stock	21.533	21.66	21.533	21.5538	4576300.0
2015-05-12 12:00:00	AMZN	Stock	21.5455	21.6375	21.504	21.5865	2889740.0

> showing 50 of 49,201 rows — these rows as CSV

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