PREVIEW / stock_1hour / 2011-11-25

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-25.parquet
  size:    598 KB
  rows:    26,241
  symbols: 3,359

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-11-25 04:00:00	AAPL	Stock	13.0571	13.0571	12.9964	12.9964	34972.0
2011-11-25 06:00:00	AAPL	Stock	13.0179	13.0179	13.0179	13.0179	12740.0
2011-11-25 07:00:00	AAPL	Stock	13.0554	13.0604	13.0357	13.0554	33320.0
2011-11-25 08:00:00	AAPL	Stock	13.0707	13.1893	13.0493	13.1821	2347324.0
2011-11-25 09:00:00	AAPL	Stock	13.1757	13.2554	13.1468	13.1746	49015036.0
2011-11-25 10:00:00	AAPL	Stock	13.1718	13.2096	13.0986	13.1021	49422408.0
2011-11-25 11:00:00	AAPL	Stock	13.1018	13.1214	12.9757	13.0332	66861676.0
2011-11-25 12:00:00	AAPL	Stock	13.0332	13.0736	12.9839	12.9854	60166232.0
2011-11-25 13:00:00	AAPL	Stock	12.9911	13.1161	12.9821	13.0429	11646516.0
2011-11-25 14:00:00	AAPL	Stock	13.0414	13.0446	13.0357	13.0446	543340.0
2011-11-25 15:00:00	AAPL	Stock	13.0429	13.0436	13.0321	13.0321	303996.0
2011-11-25 16:00:00	AAPL	Stock	13.0261	13.0432	13.025	13.0432	173264.0
2011-11-25 04:00:00	MSFT	Stock	24.44	24.44	24.25	24.25	900.0
2011-11-25 06:00:00	MSFT	Stock	24.37	24.37	24.37	24.37	150.0
2011-11-25 07:00:00	MSFT	Stock	24.32	24.33	24.29	24.3	3763.0
2011-11-25 08:00:00	MSFT	Stock	24.32	24.44	24.29	24.4	30535.0
2011-11-25 09:00:00	MSFT	Stock	24.37	24.67	24.32	24.515	4709514.0
2011-11-25 10:00:00	MSFT	Stock	24.515	24.605	24.47	24.508	5959638.0
2011-11-25 11:00:00	MSFT	Stock	24.508	24.54	24.37	24.39	4310994.0
2011-11-25 12:00:00	MSFT	Stock	24.385	24.45	24.3	24.3	7318058.0
2011-11-25 13:00:00	MSFT	Stock	24.3	24.472	24.27	24.3	1630202.0
2011-11-25 14:00:00	MSFT	Stock	24.34	24.35	24.33	24.33	3100.0
2011-11-25 15:00:00	MSFT	Stock	24.35	24.35	24.3	24.3	3080.0
2011-11-25 16:00:00	MSFT	Stock	24.29	24.29	24.27	24.27	1600.0
2011-11-25 04:00:00	NVDA	Stock	0.3605	0.3605	0.3605	0.3605	8000.0
2011-11-25 08:00:00	NVDA	Stock	0.36	0.361	0.36	0.361	117560.0
2011-11-25 09:00:00	NVDA	Stock	0.3612	0.3632	0.3542	0.3588	94465480.0
2011-11-25 10:00:00	NVDA	Stock	0.3589	0.3645	0.358	0.358	123594840.0
2011-11-25 11:00:00	NVDA	Stock	0.358	0.3605	0.3515	0.3526	85969920.0
2011-11-25 12:00:00	NVDA	Stock	0.3528	0.3544	0.35	0.351	95579400.0
2011-11-25 13:00:00	NVDA	Stock	0.3522	0.361	0.351	0.352	774080.0
2011-11-25 14:00:00	NVDA	Stock	0.3518	0.3542	0.3513	0.3513	244840.0
2011-11-25 15:00:00	NVDA	Stock	0.3515	0.3515	0.3515	0.3515	8000.0
2011-11-25 04:00:00	AMZN	Stock	9.375	9.375	9.35	9.35	8000.0
2011-11-25 06:00:00	AMZN	Stock	9.325	9.325	9.325	9.325	4000.0
2011-11-25 07:00:00	AMZN	Stock	9.4	9.4	9.4	9.4	2000.0
2011-11-25 08:00:00	AMZN	Stock	9.4	9.5	9.4	9.5	279040.0
2011-11-25 09:00:00	AMZN	Stock	9.505	9.5415	9.3785	9.384	17281020.0
2011-11-25 10:00:00	AMZN	Stock	9.385	9.4135	9.32	9.3378	24460260.0
2011-11-25 11:00:00	AMZN	Stock	9.337	9.3505	9.1125	9.1332	27023580.0
2011-11-25 12:00:00	AMZN	Stock	9.134	9.1972	9.0755	9.117	26906360.0
2011-11-25 13:00:00	AMZN	Stock	9.12	9.4495	9.1	9.1525	749580.0
2011-11-25 14:00:00	AMZN	Stock	9.153	9.1675	9.15	9.1525	66000.0
2011-11-25 15:00:00	AMZN	Stock	9.166	9.1665	9.1505	9.1525	15000.0
2011-11-25 08:00:00	TSLA	Stock	2.092	2.092	2.092	2.092	1500.0
2011-11-25 09:00:00	TSLA	Stock	2.1033	2.1607	2.088	2.088	1347375.0
2011-11-25 10:00:00	TSLA	Stock	2.0893	2.1233	2.072	2.1147	1020900.0
2011-11-25 11:00:00	TSLA	Stock	2.1153	2.1187	2.0887	2.0967	585855.0
2011-11-25 12:00:00	TSLA	Stock	2.0967	2.1187	2.096	2.1107	507075.0
2011-11-25 14:00:00	TSLA	Stock	2.1187	2.1333	2.1187	2.1333	6000.0

> showing 50 of 26,241 rows — these rows as CSV

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