PREVIEW / stock_1hour / 2012-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-03-23.parquet
  size:    926 KB
  rows:    43,635
  symbols: 3,500

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-03-23 04:00:00	AAPL	Stock	21.4643	21.4643	21.4189	21.4286	292460.0
2012-03-23 05:00:00	AAPL	Stock	21.4286	21.4643	21.3571	21.3571	76160.0
2012-03-23 06:00:00	AAPL	Stock	21.3561	21.375	21.3561	21.375	33544.0
2012-03-23 07:00:00	AAPL	Stock	21.375	21.4107	21.3679	21.3707	486108.0
2012-03-23 08:00:00	AAPL	Stock	21.3782	21.4232	21.3393	21.4214	1993964.0
2012-03-23 09:00:00	AAPL	Stock	21.4221	21.4929	21.3714	21.4032	66960544.0
2012-03-23 10:00:00	AAPL	Stock	21.4007	21.4021	21.3119	21.3654	68101208.0
2012-03-23 11:00:00	AAPL	Stock	21.3611	21.3854	21.3357	21.3743	34092744.0
2012-03-23 12:00:00	AAPL	Stock	21.3743	21.3768	21.2286	21.2783	73971380.0
2012-03-23 13:00:00	AAPL	Stock	21.278	21.3518	21.2714	21.3221	42165508.0
2012-03-23 14:00:00	AAPL	Stock	21.3211	21.3786	21.3036	21.3582	38316404.0
2012-03-23 15:00:00	AAPL	Stock	21.3593	21.3643	21.2575	21.2929	82476016.0
2012-03-23 16:00:00	AAPL	Stock	21.2789	21.4004	21.2679	21.2857	11833136.0
2012-03-23 17:00:00	AAPL	Stock	21.3708	21.3708	21.2714	21.3	1333388.0
2012-03-23 18:00:00	AAPL	Stock	21.2971	21.2971	21.2786	21.2804	100632.0
2012-03-23 19:00:00	AAPL	Stock	21.2804	21.2886	21.2589	21.2814	324968.0
2012-03-23 08:00:00	MSFT	Stock	32.0	32.0	31.99	32.0	2958.0
2012-03-23 09:00:00	MSFT	Stock	32.0	32.12	31.89	31.949	4197218.0
2012-03-23 10:00:00	MSFT	Stock	31.94	31.945	31.72	31.816	4757078.0
2012-03-23 11:00:00	MSFT	Stock	31.82	31.89	31.74	31.845	3826211.0
2012-03-23 12:00:00	MSFT	Stock	31.85	31.87	31.79	31.845	2637048.0
2012-03-23 13:00:00	MSFT	Stock	31.85	31.98	31.8	31.89	4519909.0
2012-03-23 14:00:00	MSFT	Stock	31.88	32.0	31.86	31.93	3922745.0
2012-03-23 15:00:00	MSFT	Stock	31.93	32.05	31.91	31.97	7072783.0
2012-03-23 16:00:00	MSFT	Stock	31.98	32.05	31.906	31.97	3471162.0
2012-03-23 17:00:00	MSFT	Stock	31.99	31.99	31.99	31.99	1250.0
2012-03-23 18:00:00	MSFT	Stock	32.0	32.03	32.0	32.03	525.0
2012-03-23 19:00:00	MSFT	Stock	32.04	32.04	32.04	32.04	747.0
2012-03-23 09:00:00	NVDA	Stock	0.3608	0.3612	0.3575	0.3605	31633000.0
2012-03-23 10:00:00	NVDA	Stock	0.3605	0.3625	0.3584	0.362	47949480.0
2012-03-23 11:00:00	NVDA	Stock	0.3621	0.363	0.3612	0.3625	33653600.0
2012-03-23 12:00:00	NVDA	Stock	0.3622	0.3628	0.3608	0.3621	32349800.0
2012-03-23 13:00:00	NVDA	Stock	0.362	0.3625	0.3618	0.362	16834200.0
2012-03-23 14:00:00	NVDA	Stock	0.3622	0.3634	0.3621	0.3628	42308640.0
2012-03-23 15:00:00	NVDA	Stock	0.3626	0.3648	0.3625	0.3635	96886520.0
2012-03-23 16:00:00	NVDA	Stock	0.3638	0.364	0.3618	0.364	9053160.0
2012-03-23 17:00:00	NVDA	Stock	0.364	0.364	0.364	0.364	4000.0
2012-03-23 19:00:00	NVDA	Stock	0.364	0.3642	0.364	0.3642	8000.0
2012-03-23 05:00:00	AMZN	Stock	9.64	9.64	9.64	9.64	2000.0
2012-03-23 08:00:00	AMZN	Stock	9.6605	9.6605	9.5925	9.6	181380.0
2012-03-23 09:00:00	AMZN	Stock	9.6025	9.7819	9.589	9.7626	23761380.0
2012-03-23 10:00:00	AMZN	Stock	9.7605	9.81	9.666	9.797	29082660.0
2012-03-23 11:00:00	AMZN	Stock	9.797	9.81	9.755	9.7775	15213340.0
2012-03-23 12:00:00	AMZN	Stock	9.774	9.7825	9.7425	9.765	9805940.0
2012-03-23 13:00:00	AMZN	Stock	9.7646	9.775	9.7315	9.7415	8702560.0
2012-03-23 14:00:00	AMZN	Stock	9.742	9.795	9.734	9.7675	11330080.0
2012-03-23 15:00:00	AMZN	Stock	9.7665	9.779	9.7465	9.7525	16778700.0
2012-03-23 16:00:00	AMZN	Stock	9.7555	9.7735	9.5964	9.7525	4043260.0
2012-03-23 17:00:00	AMZN	Stock	9.754	9.754	9.754	9.754	24000.0
2012-03-23 18:00:00	AMZN	Stock	9.7675	9.7675	9.7535	9.7535	6560.0

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

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