PREVIEW / stock_1hour / 2012-08-27

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-08-27.parquet
  size:    911 KB
  rows:    43,048
  symbols: 3,456

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-08-27 04:00:00	AAPL	Stock	24.1425	24.2496	24.1425	24.2461	309260.0
2012-08-27 05:00:00	AAPL	Stock	24.2457	24.2575	24.2457	24.2554	191044.0
2012-08-27 06:00:00	AAPL	Stock	24.2554	24.2554	24.165	24.2054	576016.0
2012-08-27 07:00:00	AAPL	Stock	24.2143	24.39	24.1896	24.2964	4516456.0
2012-08-27 08:00:00	AAPL	Stock	24.3125	24.3964	24.25	24.2564	10247076.0
2012-08-27 09:00:00	AAPL	Stock	24.2536	24.3168	24.0714	24.0821	123036200.0
2012-08-27 10:00:00	AAPL	Stock	24.0839	24.2243	24.055	24.1783	92133356.0
2012-08-27 11:00:00	AAPL	Stock	24.1771	24.2179	24.14	24.1846	41254164.0
2012-08-27 12:00:00	AAPL	Stock	24.1836	24.1964	24.1357	24.1721	29323000.0
2012-08-27 13:00:00	AAPL	Stock	24.1679	24.2143	24.1607	24.1825	23583756.0
2012-08-27 14:00:00	AAPL	Stock	24.1829	24.1943	24.1393	24.1741	23503676.0
2012-08-27 15:00:00	AAPL	Stock	24.1732	24.1779	24.0761	24.1239	63154840.0
2012-08-27 16:00:00	AAPL	Stock	24.1361	24.1778	24.1071	24.1339	2336824.0
2012-08-27 17:00:00	AAPL	Stock	24.1318	24.1375	24.1239	24.1286	1190728.0
2012-08-27 18:00:00	AAPL	Stock	24.1271	24.1321	24.1214	24.1261	154560.0
2012-08-27 19:00:00	AAPL	Stock	24.1268	24.1429	24.1261	24.1429	293748.0
2012-08-27 04:00:00	MSFT	Stock	30.8	30.8	30.8	30.8	300.0
2012-08-27 07:00:00	MSFT	Stock	30.85	30.95	30.8	30.87	36365.0
2012-08-27 08:00:00	MSFT	Stock	30.87	31.0	30.82	30.89	218506.0
2012-08-27 09:00:00	MSFT	Stock	30.9	30.96	30.67	30.76	6386279.0
2012-08-27 10:00:00	MSFT	Stock	30.76	30.81	30.72	30.8	5571342.0
2012-08-27 11:00:00	MSFT	Stock	30.79	30.84	30.76	30.795	3484373.0
2012-08-27 12:00:00	MSFT	Stock	30.78	30.85	30.76	30.777	3449800.0
2012-08-27 13:00:00	MSFT	Stock	30.77	30.81	30.73	30.74	2412486.0
2012-08-27 14:00:00	MSFT	Stock	30.75	30.8	30.72	30.764	3139251.0
2012-08-27 15:00:00	MSFT	Stock	30.765	30.79	30.59	30.7	6016084.0
2012-08-27 16:00:00	MSFT	Stock	30.69	30.79	30.609	30.69	2792169.0
2012-08-27 17:00:00	MSFT	Stock	30.69	30.69	30.66	30.66	248215.0
2012-08-27 18:00:00	MSFT	Stock	30.7	30.7	30.7	30.7	395.0
2012-08-27 19:00:00	MSFT	Stock	30.7	30.7	30.67	30.7	1300.0
2012-08-27 07:00:00	NVDA	Stock	0.365	0.365	0.365	0.365	200000.0
2012-08-27 08:00:00	NVDA	Stock	0.3635	0.365	0.3635	0.365	497320.0
2012-08-27 09:00:00	NVDA	Stock	0.3655	0.3668	0.3605	0.361	45179720.0
2012-08-27 10:00:00	NVDA	Stock	0.361	0.3622	0.36	0.3612	77109760.0
2012-08-27 11:00:00	NVDA	Stock	0.3612	0.3638	0.3612	0.362	27557240.0
2012-08-27 12:00:00	NVDA	Stock	0.362	0.3625	0.3608	0.3612	24262520.0
2012-08-27 13:00:00	NVDA	Stock	0.3612	0.3625	0.3608	0.361	22216080.0
2012-08-27 14:00:00	NVDA	Stock	0.361	0.362	0.3602	0.3612	18710920.0
2012-08-27 15:00:00	NVDA	Stock	0.3612	0.3615	0.3585	0.359	112373280.0
2012-08-27 16:00:00	NVDA	Stock	0.359	0.3608	0.3588	0.3588	11122160.0
2012-08-27 17:00:00	NVDA	Stock	0.3588	0.3588	0.3588	0.3588	820800.0
2012-08-27 19:00:00	NVDA	Stock	0.3598	0.3598	0.3598	0.3598	4000.0
2012-08-27 07:00:00	AMZN	Stock	12.233	12.2875	12.233	12.265	22000.0
2012-08-27 08:00:00	AMZN	Stock	12.2625	12.278	12.225	12.245	300780.0
2012-08-27 09:00:00	AMZN	Stock	12.246	12.375	12.2405	12.2635	10349900.0
2012-08-27 10:00:00	AMZN	Stock	12.2585	12.32	12.18	12.1915	24476580.0
2012-08-27 11:00:00	AMZN	Stock	12.1915	12.27	12.1845	12.2415	4432700.0
2012-08-27 12:00:00	AMZN	Stock	12.241	12.2555	12.175	12.196	3875700.0
2012-08-27 13:00:00	AMZN	Stock	12.1935	12.214	12.1805	12.1805	2917360.0
2012-08-27 14:00:00	AMZN	Stock	12.1805	12.225	12.18	12.2006	3009060.0

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

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