PREVIEW / stock_1hour / 2011-05-10

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-10.parquet
  size:    952 KB
  rows:    44,787
  symbols: 3,549

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-05-10 04:00:00	AAPL	Stock	12.4464	12.4464	12.4304	12.4425	16800.0
2011-05-10 05:00:00	AAPL	Stock	12.4393	12.4393	12.4393	12.4393	84000.0
2011-05-10 06:00:00	AAPL	Stock	12.4304	12.4304	12.4304	12.4304	5600.0
2011-05-10 07:00:00	AAPL	Stock	12.4468	12.4821	12.4357	12.4707	538188.0
2011-05-10 08:00:00	AAPL	Stock	12.4679	12.4707	12.4143	12.4536	1548204.0
2011-05-10 09:00:00	AAPL	Stock	12.4554	12.4629	12.3807	12.4232	45330292.0
2011-05-10 10:00:00	AAPL	Stock	12.4254	12.4357	12.4011	12.4117	38067596.0
2011-05-10 11:00:00	AAPL	Stock	12.4118	12.4214	12.3879	12.4096	25888296.0
2011-05-10 12:00:00	AAPL	Stock	12.4096	12.4182	12.3904	12.3916	16324392.0
2011-05-10 13:00:00	AAPL	Stock	12.3925	12.4086	12.3821	12.4064	20944420.0
2011-05-10 14:00:00	AAPL	Stock	12.4065	12.4139	12.3875	12.4089	21209132.0
2011-05-10 15:00:00	AAPL	Stock	12.4094	12.4889	12.4025	12.4804	96297936.0
2011-05-10 16:00:00	AAPL	Stock	12.4804	12.4875	12.4113	12.4714	8060220.0
2011-05-10 17:00:00	AAPL	Stock	12.4732	12.4804	12.47	12.4764	1516760.0
2011-05-10 18:00:00	AAPL	Stock	12.4768	12.4893	12.4714	12.4893	722904.0
2011-05-10 19:00:00	AAPL	Stock	12.4875	12.4954	12.4771	12.4875	425124.0
2011-05-10 04:00:00	MSFT	Stock	25.64	25.82	25.64	25.82	300.0
2011-05-10 05:00:00	MSFT	Stock	25.9	25.9	25.9	25.9	100.0
2011-05-10 06:00:00	MSFT	Stock	25.85	25.97	25.8	25.93	33016.0
2011-05-10 07:00:00	MSFT	Stock	25.91	26.0	25.56	25.56	380370.0
2011-05-10 08:00:00	MSFT	Stock	25.69	25.9	25.23	25.3	1869612.0
2011-05-10 09:00:00	MSFT	Stock	25.3	25.85	25.2	25.79	20867349.0
2011-05-10 10:00:00	MSFT	Stock	25.79	25.8	25.36	25.49	28388371.0
2011-05-10 11:00:00	MSFT	Stock	25.5	25.57	25.4	25.47	16037862.0
2011-05-10 12:00:00	MSFT	Stock	25.48	25.51	25.41	25.43	11717906.0
2011-05-10 13:00:00	MSFT	Stock	25.43	25.58	25.41	25.575	9037413.0
2011-05-10 14:00:00	MSFT	Stock	25.58	25.66	25.5	25.62	10513284.0
2011-05-10 15:00:00	MSFT	Stock	25.616	25.7	25.55	25.67	16932015.0
2011-05-10 16:00:00	MSFT	Stock	25.66	25.85	25.536	25.68	2520983.0
2011-05-10 17:00:00	MSFT	Stock	25.69	25.7	25.67	25.69	148737.0
2011-05-10 18:00:00	MSFT	Stock	25.68	25.69	25.67	25.67	34222.0
2011-05-10 19:00:00	MSFT	Stock	25.67	25.73	25.67	25.72	4371.0
2011-05-10 07:00:00	NVDA	Stock	0.4975	0.4975	0.4975	0.4975	4000.0
2011-05-10 08:00:00	NVDA	Stock	0.4975	0.5	0.4968	0.4985	927200.0
2011-05-10 09:00:00	NVDA	Stock	0.498	0.4988	0.49	0.495	99782400.0
2011-05-10 10:00:00	NVDA	Stock	0.4952	0.498	0.4941	0.495	144200360.0
2011-05-10 11:00:00	NVDA	Stock	0.495	0.4955	0.49	0.4904	76789680.0
2011-05-10 12:00:00	NVDA	Stock	0.4904	0.4925	0.49	0.4905	62250400.0
2011-05-10 13:00:00	NVDA	Stock	0.4905	0.4942	0.4895	0.4915	74419160.0
2011-05-10 14:00:00	NVDA	Stock	0.4915	0.4952	0.4898	0.4951	85364200.0
2011-05-10 15:00:00	NVDA	Stock	0.495	0.4963	0.4938	0.4948	127045720.0
2011-05-10 16:00:00	NVDA	Stock	0.4945	0.496	0.4918	0.4945	12521880.0
2011-05-10 17:00:00	NVDA	Stock	0.4945	0.4963	0.4942	0.495	584960.0
2011-05-10 18:00:00	NVDA	Stock	0.497	0.4972	0.4963	0.4972	379680.0
2011-05-10 19:00:00	NVDA	Stock	0.4972	0.4978	0.4972	0.4975	130720.0
2011-05-10 05:00:00	AMZN	Stock	10.05	10.05	10.05	10.05	4000.0
2011-05-10 06:00:00	AMZN	Stock	10.08	10.1	10.08	10.1	4000.0
2011-05-10 08:00:00	AMZN	Stock	10.093	10.093	10.04	10.0795	279940.0
2011-05-10 09:00:00	AMZN	Stock	10.0875	10.26	10.066	10.254	28788480.0
2011-05-10 10:00:00	AMZN	Stock	10.2545	10.2645	10.175	10.2023	21932860.0

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

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