PREVIEW / stock_1hour / 2012-04-04

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-04-04.parquet
  size:    943 KB
  rows:    44,706
  symbols: 3,510

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-04-04 04:00:00	AAPL	Stock	22.3929	22.3929	22.3732	22.3732	16800.0
2012-04-04 05:00:00	AAPL	Stock	22.3239	22.3571	22.3214	22.3411	113540.0
2012-04-04 06:00:00	AAPL	Stock	22.3304	22.3321	22.3032	22.3036	124656.0
2012-04-04 07:00:00	AAPL	Stock	22.3107	22.3214	22.255	22.3036	1398096.0
2012-04-04 08:00:00	AAPL	Stock	22.3121	22.3464	22.2357	22.2857	6201384.0
2012-04-04 09:00:00	AAPL	Stock	22.2814	22.3407	22.2004	22.3132	98308224.0
2012-04-04 10:00:00	AAPL	Stock	22.3146	22.3146	22.1171	22.1496	136481996.0
2012-04-04 11:00:00	AAPL	Stock	22.1482	22.2357	22.1457	22.2054	49117068.0
2012-04-04 12:00:00	AAPL	Stock	22.2032	22.2057	22.1429	22.1764	40759376.0
2012-04-04 13:00:00	AAPL	Stock	22.1739	22.1918	22.0929	22.1607	59327380.0
2012-04-04 14:00:00	AAPL	Stock	22.1572	22.1964	22.0993	22.1589	49453964.0
2012-04-04 15:00:00	AAPL	Stock	22.1596	22.3521	22.1357	22.2889	115083892.0
2012-04-04 16:00:00	AAPL	Stock	22.2936	22.3071	22.201	22.2957	14137340.0
2012-04-04 17:00:00	AAPL	Stock	22.1857	22.2957	22.1857	22.2761	361480.0
2012-04-04 18:00:00	AAPL	Stock	22.2754	22.2911	22.275	22.2786	223020.0
2012-04-04 19:00:00	AAPL	Stock	22.285	22.2857	22.2521	22.2521	634480.0
2012-04-04 07:00:00	MSFT	Stock	31.7	31.7	31.7	31.7	1885.0
2012-04-04 08:00:00	MSFT	Stock	31.7	31.7	31.64	31.69	54133.0
2012-04-04 09:00:00	MSFT	Stock	31.69	31.7	31.34	31.38	7120662.0
2012-04-04 10:00:00	MSFT	Stock	31.38	31.44	31.16	31.19	9884056.0
2012-04-04 11:00:00	MSFT	Stock	31.19	31.27	31.06	31.185	7686952.0
2012-04-04 12:00:00	MSFT	Stock	31.185	31.24	31.1	31.14	4409947.0
2012-04-04 13:00:00	MSFT	Stock	31.13	31.17	31.05	31.148	3945306.0
2012-04-04 14:00:00	MSFT	Stock	31.15	31.29	31.12	31.24	4222368.0
2012-04-04 15:00:00	MSFT	Stock	31.235	31.32	31.2	31.22	9794916.0
2012-04-04 16:00:00	MSFT	Stock	31.22	31.27	31.16	31.19	2009473.0
2012-04-04 17:00:00	MSFT	Stock	31.26	31.26	31.15	31.15	16588.0
2012-04-04 18:00:00	MSFT	Stock	31.19	31.39	31.19	31.33	21638.0
2012-04-04 19:00:00	MSFT	Stock	31.33	31.34	31.31	31.32	7197.0
2012-04-04 08:00:00	NVDA	Stock	0.375	0.375	0.37	0.371	264000.0
2012-04-04 09:00:00	NVDA	Stock	0.3713	0.376	0.3703	0.372	78088880.0
2012-04-04 10:00:00	NVDA	Stock	0.3718	0.3723	0.3652	0.3655	92916600.0
2012-04-04 11:00:00	NVDA	Stock	0.3655	0.3685	0.3655	0.3679	51728840.0
2012-04-04 12:00:00	NVDA	Stock	0.3678	0.369	0.3675	0.3679	26661920.0
2012-04-04 13:00:00	NVDA	Stock	0.368	0.368	0.364	0.3645	48493280.0
2012-04-04 14:00:00	NVDA	Stock	0.3648	0.3666	0.3645	0.3664	58863120.0
2012-04-04 15:00:00	NVDA	Stock	0.3665	0.3675	0.3652	0.3662	111499640.0
2012-04-04 16:00:00	NVDA	Stock	0.3662	0.3685	0.3652	0.366	7515400.0
2012-04-04 17:00:00	NVDA	Stock	0.3662	0.3662	0.3662	0.3662	531640.0
2012-04-04 18:00:00	NVDA	Stock	0.367	0.367	0.367	0.367	14000.0
2012-04-04 19:00:00	NVDA	Stock	0.3668	0.3668	0.3668	0.3668	16000.0
2012-04-04 08:00:00	AMZN	Stock	9.9235	9.939	9.816	9.835	606900.0
2012-04-04 09:00:00	AMZN	Stock	9.831	9.884	9.7805	9.8295	16571960.0
2012-04-04 10:00:00	AMZN	Stock	9.823	9.8279	9.663	9.663	28158480.0
2012-04-04 11:00:00	AMZN	Stock	9.663	9.719	9.656	9.656	14430760.0
2012-04-04 12:00:00	AMZN	Stock	9.657	9.6835	9.6305	9.6375	9201820.0
2012-04-04 13:00:00	AMZN	Stock	9.639	9.6635	9.618	9.647	8464000.0
2012-04-04 14:00:00	AMZN	Stock	9.647	9.6815	9.634	9.6695	7654660.0
2012-04-04 15:00:00	AMZN	Stock	9.6675	9.735	9.66	9.6945	20666860.0
2012-04-04 16:00:00	AMZN	Stock	9.695	9.7125	9.67	9.694	844460.0

> showing 50 of 44,706 rows — these rows as CSV

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