PREVIEW / stock_1hour / 2010-08-20

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-20.parquet
  size:    890 KB
  rows:    43,198
  symbols: 3,464

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
2010-08-20 06:00:00	AAPL	Stock	8.8929	8.8929	8.8571	8.8571	11200.0
2010-08-20 07:00:00	AAPL	Stock	8.8418	8.8768	8.8418	8.8768	54740.0
2010-08-20 08:00:00	AAPL	Stock	8.8768	8.9014	8.8704	8.8839	921144.0
2010-08-20 09:00:00	AAPL	Stock	8.8914	8.9607	8.8836	8.9404	62411776.0
2010-08-20 10:00:00	AAPL	Stock	8.94	9.0686	8.9243	8.9332	73301900.0
2010-08-20 11:00:00	AAPL	Stock	8.9321	8.9404	8.9	8.9032	41082636.0
2010-08-20 12:00:00	AAPL	Stock	8.9036	8.925	8.8982	8.9211	30806580.0
2010-08-20 13:00:00	AAPL	Stock	8.9211	8.9296	8.915	8.9218	22005312.0
2010-08-20 14:00:00	AAPL	Stock	8.9218	8.9475	8.92	8.9296	42598416.0
2010-08-20 15:00:00	AAPL	Stock	8.9296	8.9346	8.9146	8.9164	64092672.0
2010-08-20 16:00:00	AAPL	Stock	8.9164	8.9296	8.8993	8.9221	10552136.0
2010-08-20 17:00:00	AAPL	Stock	8.9243	8.9314	8.9243	8.9314	157416.0
2010-08-20 18:00:00	AAPL	Stock	8.9286	8.9304	8.9157	8.9232	106876.0
2010-08-20 19:00:00	AAPL	Stock	8.9286	8.9304	8.9254	8.9279	74256.0
2010-08-20 20:00:00	AAPL	Stock	8.9386	8.9386	8.9386	8.9386	701400.0
2010-08-20 07:00:00	MSFT	Stock	24.3	24.3	24.25	24.25	500.0
2010-08-20 08:00:00	MSFT	Stock	24.34	24.36	24.32	24.34	5950.0
2010-08-20 09:00:00	MSFT	Stock	24.34	24.39	24.24	24.34	10707730.0
2010-08-20 10:00:00	MSFT	Stock	24.338	24.4	24.27	24.36	9100253.0
2010-08-20 11:00:00	MSFT	Stock	24.36	24.38	24.2	24.21	5694225.0
2010-08-20 12:00:00	MSFT	Stock	24.21	24.27	24.2	24.21	4076410.0
2010-08-20 13:00:00	MSFT	Stock	24.215	24.25	24.2	24.22	5195195.0
2010-08-20 14:00:00	MSFT	Stock	24.22	24.32	24.215	24.29	3742846.0
2010-08-20 15:00:00	MSFT	Stock	24.285	24.31	24.23	24.23	8220746.0
2010-08-20 16:00:00	MSFT	Stock	24.24	24.303	24.03	24.2	2474117.0
2010-08-20 17:00:00	MSFT	Stock	24.2	24.277	24.2	24.25	8089.0
2010-08-20 18:00:00	MSFT	Stock	24.23	24.24	24.19	24.24	43128.0
2010-08-20 19:00:00	MSFT	Stock	24.26	24.26	24.22	24.22	2397.0
2010-08-20 07:00:00	NVDA	Stock	0.2462	0.2462	0.245	0.245	52000.0
2010-08-20 08:00:00	NVDA	Stock	0.245	0.2482	0.2428	0.2448	3442960.0
2010-08-20 09:00:00	NVDA	Stock	0.2445	0.2547	0.2442	0.2546	237810760.0
2010-08-20 10:00:00	NVDA	Stock	0.2545	0.2553	0.2505	0.251	269379840.0
2010-08-20 11:00:00	NVDA	Stock	0.2513	0.2515	0.2458	0.2472	231418760.0
2010-08-20 12:00:00	NVDA	Stock	0.2471	0.2503	0.247	0.2503	100355120.0
2010-08-20 13:00:00	NVDA	Stock	0.2503	0.2518	0.2493	0.2496	107769880.0
2010-08-20 14:00:00	NVDA	Stock	0.2496	0.2505	0.2493	0.25	92926640.0
2010-08-20 15:00:00	NVDA	Stock	0.25	0.2503	0.2493	0.2495	202216160.0
2010-08-20 16:00:00	NVDA	Stock	0.2495	0.2505	0.2475	0.25	18470360.0
2010-08-20 17:00:00	NVDA	Stock	0.2495	0.2507	0.247	0.2488	483240.0
2010-08-20 18:00:00	NVDA	Stock	0.249	0.2495	0.249	0.2493	209200.0
2010-08-20 19:00:00	NVDA	Stock	0.249	0.2493	0.2488	0.2493	253200.0
2010-08-20 06:00:00	AMZN	Stock	6.35	6.35	6.35	6.35	2080.0
2010-08-20 08:00:00	AMZN	Stock	6.347	6.3475	6.3325	6.3475	19320.0
2010-08-20 09:00:00	AMZN	Stock	6.3525	6.3885	6.3145	6.3575	17036360.0
2010-08-20 10:00:00	AMZN	Stock	6.357	6.402	6.335	6.338	15872140.0
2010-08-20 11:00:00	AMZN	Stock	6.3375	6.352	6.301	6.306	10079420.0
2010-08-20 12:00:00	AMZN	Stock	6.3075	6.3275	6.3045	6.3275	7673060.0
2010-08-20 13:00:00	AMZN	Stock	6.328	6.35	6.3215	6.329	7444480.0
2010-08-20 14:00:00	AMZN	Stock	6.329	6.394	6.3265	6.3825	9456520.0
2010-08-20 15:00:00	AMZN	Stock	6.381	6.3945	6.3675	6.388	12485620.0

> showing 50 of 43,198 rows — these rows as CSV

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