PREVIEW / stock_1hour / 2011-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-04.parquet
  size:    950 KB
  rows:    44,755
  symbols: 3,550

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-04 04:00:00	AAPL	Stock	12.4393	12.4393	12.4393	12.4393	2800.0
2011-05-04 05:00:00	AAPL	Stock	12.4464	12.4464	12.4464	12.4464	2800.0
2011-05-04 06:00:00	AAPL	Stock	12.4579	12.4579	12.4107	12.4107	5600.0
2011-05-04 07:00:00	AAPL	Stock	12.4214	12.4279	12.4214	12.4279	8400.0
2011-05-04 08:00:00	AAPL	Stock	12.4214	12.4589	12.4214	12.4518	661892.0
2011-05-04 09:00:00	AAPL	Stock	12.4554	12.5654	12.3886	12.4979	76104112.0
2011-05-04 10:00:00	AAPL	Stock	12.4975	12.5357	12.4464	12.4979	77114520.0
2011-05-04 11:00:00	AAPL	Stock	12.4993	12.5082	12.4143	12.4225	46999316.0
2011-05-04 12:00:00	AAPL	Stock	12.4248	12.4525	12.4	12.4179	32930408.0
2011-05-04 13:00:00	AAPL	Stock	12.4162	12.4789	12.4139	12.4746	31335444.0
2011-05-04 14:00:00	AAPL	Stock	12.4746	12.5171	12.4507	12.4868	43333360.0
2011-05-04 15:00:00	AAPL	Stock	12.4846	12.5204	12.4671	12.4971	59840424.0
2011-05-04 16:00:00	AAPL	Stock	12.4961	12.5118	12.4643	12.4771	11654552.0
2011-05-04 17:00:00	AAPL	Stock	12.4807	12.4961	12.4786	12.4868	283164.0
2011-05-04 18:00:00	AAPL	Stock	12.4868	12.4964	12.4846	12.4961	191576.0
2011-05-04 19:00:00	AAPL	Stock	12.4939	12.4946	12.485	12.4946	114744.0
2011-05-04 04:00:00	MSFT	Stock	25.94	25.94	25.94	25.94	800.0
2011-05-04 05:00:00	MSFT	Stock	25.94	25.94	25.94	25.94	300.0
2011-05-04 06:00:00	MSFT	Stock	25.9	25.9	25.9	25.9	300.0
2011-05-04 07:00:00	MSFT	Stock	25.79	25.82	25.76	25.77	3300.0
2011-05-04 08:00:00	MSFT	Stock	25.8	25.84	25.8	25.82	43826.0
2011-05-04 09:00:00	MSFT	Stock	25.82	25.95	25.78	25.9	6485879.0
2011-05-04 10:00:00	MSFT	Stock	25.89	25.99	25.83	25.988	11514770.0
2011-05-04 11:00:00	MSFT	Stock	25.985	26.12	25.92	26.11	13426041.0
2011-05-04 12:00:00	MSFT	Stock	26.105	26.11	25.95	26.04	10081051.0
2011-05-04 13:00:00	MSFT	Stock	26.04	26.12	26.03	26.1	6910350.0
2011-05-04 14:00:00	MSFT	Stock	26.09	26.25	26.08	26.19	8442151.0
2011-05-04 15:00:00	MSFT	Stock	26.181	26.2	26.03	26.04	11801673.0
2011-05-04 16:00:00	MSFT	Stock	26.04	26.161	25.99	26.03	2526341.0
2011-05-04 17:00:00	MSFT	Stock	26.04	26.04	26.03	26.03	58968.0
2011-05-04 18:00:00	MSFT	Stock	26.06	26.06	26.01	26.01	13481.0
2011-05-04 19:00:00	MSFT	Stock	26.01	26.02	26.0	26.02	10850.0
2011-05-04 08:00:00	NVDA	Stock	0.4748	0.4763	0.4705	0.4753	1823440.0
2011-05-04 09:00:00	NVDA	Stock	0.4742	0.477	0.4645	0.467	144262680.0
2011-05-04 10:00:00	NVDA	Stock	0.4668	0.467	0.4605	0.462	122019360.0
2011-05-04 11:00:00	NVDA	Stock	0.462	0.4628	0.4575	0.4593	78606840.0
2011-05-04 12:00:00	NVDA	Stock	0.4593	0.4605	0.4575	0.4605	73437720.0
2011-05-04 13:00:00	NVDA	Stock	0.4605	0.4655	0.4603	0.465	59505760.0
2011-05-04 14:00:00	NVDA	Stock	0.465	0.4688	0.4645	0.4673	60771880.0
2011-05-04 15:00:00	NVDA	Stock	0.4673	0.469	0.4652	0.4665	80537920.0
2011-05-04 16:00:00	NVDA	Stock	0.4668	0.4688	0.4638	0.4665	1361040.0
2011-05-04 17:00:00	NVDA	Stock	0.4643	0.4673	0.4643	0.4673	377680.0
2011-05-04 18:00:00	NVDA	Stock	0.4673	0.4675	0.4673	0.4675	40000.0
2011-05-04 19:00:00	NVDA	Stock	0.4648	0.4673	0.4648	0.465	20000.0
2011-05-04 08:00:00	AMZN	Stock	9.9555	9.9555	9.9105	9.9105	10000.0
2011-05-04 09:00:00	AMZN	Stock	9.9145	9.986	9.86	9.922	13483820.0
2011-05-04 10:00:00	AMZN	Stock	9.9235	9.9745	9.8643	9.87	18886160.0
2011-05-04 11:00:00	AMZN	Stock	9.8725	9.874	9.7685	9.8298	12511080.0
2011-05-04 12:00:00	AMZN	Stock	9.8305	9.9062	9.819	9.8455	13624040.0
2011-05-04 13:00:00	AMZN	Stock	9.844	9.965	9.8345	9.955	15256980.0

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

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