PREVIEW / stock_1hour / 2013-12-23

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-12-23.parquet
  size:    1.0 MB
  rows:    48,893
  symbols: 3,543

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
2013-12-23 04:00:00	AAPL	Stock	19.7861	20.3446	19.7861	20.1846	760088.0
2013-12-23 05:00:00	AAPL	Stock	20.2118	20.3036	20.2118	20.3036	198548.0
2013-12-23 06:00:00	AAPL	Stock	20.3304	20.3482	20.2954	20.2975	566888.0
2013-12-23 07:00:00	AAPL	Stock	20.2911	20.4654	20.2107	20.2521	5145420.0
2013-12-23 08:00:00	AAPL	Stock	20.2729	20.4643	20.1786	20.2804	7307776.0
2013-12-23 09:00:00	AAPL	Stock	20.2836	20.2971	20.0986	20.2432	115607072.0
2013-12-23 10:00:00	AAPL	Stock	20.2429	20.25	20.1275	20.2122	73629864.0
2013-12-23 11:00:00	AAPL	Stock	20.2121	20.2407	20.1814	20.2112	33206320.0
2013-12-23 12:00:00	AAPL	Stock	20.2125	20.2831	20.1946	20.2483	34918380.0
2013-12-23 13:00:00	AAPL	Stock	20.2479	20.2882	20.2321	20.2421	28060368.0
2013-12-23 14:00:00	AAPL	Stock	20.2439	20.3571	20.2032	20.3406	51257360.0
2013-12-23 15:00:00	AAPL	Stock	20.3379	20.3829	20.3139	20.3654	68911192.0
2013-12-23 16:00:00	AAPL	Stock	20.3604	20.3714	20.1988	20.3511	12744284.0
2013-12-23 17:00:00	AAPL	Stock	20.3518	20.3671	20.35	20.3571	570388.0
2013-12-23 18:00:00	AAPL	Stock	20.3596	20.3657	20.3536	20.3571	281428.0
2013-12-23 19:00:00	AAPL	Stock	20.35	20.3661	20.3482	20.3625	392420.0
2013-12-23 04:00:00	MSFT	Stock	37.0	37.12	37.0	37.12	585.0
2013-12-23 05:00:00	MSFT	Stock	37.08	37.08	36.83	36.83	500.0
2013-12-23 07:00:00	MSFT	Stock	36.91	36.91	36.91	36.91	431.0
2013-12-23 08:00:00	MSFT	Stock	36.98	37.03	36.9	37.0	14639.0
2013-12-23 09:00:00	MSFT	Stock	37.0	37.02	36.62	36.65	2927635.0
2013-12-23 10:00:00	MSFT	Stock	36.65	36.67	36.565	36.66	3321548.0
2013-12-23 11:00:00	MSFT	Stock	36.655	36.69	36.6	36.644	3601696.0
2013-12-23 12:00:00	MSFT	Stock	36.65	36.75	36.61	36.7	2583153.0
2013-12-23 13:00:00	MSFT	Stock	36.7	36.71	36.56	36.576	1979500.0
2013-12-23 14:00:00	MSFT	Stock	36.57	36.67	36.55	36.61	1995855.0
2013-12-23 15:00:00	MSFT	Stock	36.616	36.64	36.55	36.63	5038029.0
2013-12-23 16:00:00	MSFT	Stock	36.63	36.832	36.57	36.6	3001060.0
2013-12-23 17:00:00	MSFT	Stock	36.6	36.6	36.55	36.55	1717.0
2013-12-23 18:00:00	MSFT	Stock	36.6	36.62	36.6	36.6	11458.0
2013-12-23 19:00:00	MSFT	Stock	36.62	36.65	36.54	36.54	16728.0
2013-12-23 08:00:00	NVDA	Stock	0.3928	0.3928	0.3928	0.3928	12000.0
2013-12-23 09:00:00	NVDA	Stock	0.3945	0.3978	0.3925	0.3955	24013520.0
2013-12-23 10:00:00	NVDA	Stock	0.3953	0.396	0.3942	0.3953	26518360.0
2013-12-23 11:00:00	NVDA	Stock	0.3953	0.396	0.3941	0.3942	13931480.0
2013-12-23 12:00:00	NVDA	Stock	0.3942	0.3942	0.392	0.3925	14303480.0
2013-12-23 13:00:00	NVDA	Stock	0.3925	0.3928	0.3913	0.392	9928840.0
2013-12-23 14:00:00	NVDA	Stock	0.392	0.3938	0.3918	0.3938	11618120.0
2013-12-23 15:00:00	NVDA	Stock	0.3938	0.3948	0.393	0.3948	49389840.0
2013-12-23 16:00:00	NVDA	Stock	0.3945	0.3945	0.394	0.394	11557400.0
2013-12-23 19:00:00	NVDA	Stock	0.3945	0.397	0.3945	0.397	738000.0
2013-12-23 04:00:00	AMZN	Stock	20.15	20.245	20.15	20.245	10360.0
2013-12-23 05:00:00	AMZN	Stock	20.245	20.249	20.231	20.231	8000.0
2013-12-23 06:00:00	AMZN	Stock	20.2845	20.2845	20.2415	20.2415	5000.0
2013-12-23 07:00:00	AMZN	Stock	20.2435	20.2875	20.2435	20.255	51400.0
2013-12-23 08:00:00	AMZN	Stock	20.255	20.26	20.101	20.138	690300.0
2013-12-23 09:00:00	AMZN	Stock	20.139	20.1845	20.013	20.039	8287380.0
2013-12-23 10:00:00	AMZN	Stock	20.03	20.1105	19.96	20.11	12359640.0
2013-12-23 11:00:00	AMZN	Stock	20.11	20.25	20.1	20.21	8758080.0
2013-12-23 12:00:00	AMZN	Stock	20.21	20.2425	20.1755	20.195	3296100.0

> showing 50 of 48,893 rows — these rows as CSV

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