PREVIEW / stock_1hour / 2010-02-04

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-02-04.parquet
  size:    898 KB
  rows:    43,331
  symbols: 3,441

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
2010-02-04 04:00:00	AAPL	Stock	7.1325	7.1325	7.1325	7.1325	3640.0
2010-02-04 05:00:00	AAPL	Stock	7.1089	7.1214	7.0929	7.0929	40992.0
2010-02-04 06:00:00	AAPL	Stock	7.0929	7.0929	7.0871	7.0875	15400.0
2010-02-04 07:00:00	AAPL	Stock	7.1143	7.1143	7.0643	7.07	488124.0
2010-02-04 08:00:00	AAPL	Stock	7.0718	7.0821	7.0293	7.0443	4358452.0
2010-02-04 09:00:00	AAPL	Stock	7.0439	7.0846	6.9714	6.9839	110272820.0
2010-02-04 10:00:00	AAPL	Stock	6.9839	7.0046	6.9429	6.9525	120863960.0
2010-02-04 11:00:00	AAPL	Stock	6.9504	6.9729	6.8721	6.8939	103676440.0
2010-02-04 12:00:00	AAPL	Stock	6.8932	6.9246	6.8764	6.9121	80181164.0
2010-02-04 13:00:00	AAPL	Stock	6.9121	6.9389	6.8986	6.9061	55482672.0
2010-02-04 14:00:00	AAPL	Stock	6.9061	6.9321	6.8879	6.9167	73748780.0
2010-02-04 15:00:00	AAPL	Stock	6.9171	6.9207	6.8418	6.8571	183272096.0
2010-02-04 16:00:00	AAPL	Stock	6.8571	6.9342	6.8536	6.8586	12851468.0
2010-02-04 17:00:00	AAPL	Stock	6.8586	6.8607	6.8493	6.8529	893648.0
2010-02-04 18:00:00	AAPL	Stock	6.8568	6.86	6.8532	6.8536	550900.0
2010-02-04 19:00:00	AAPL	Stock	6.8521	6.8557	6.8482	6.8532	549220.0
2010-02-04 04:00:00	MSFT	Stock	28.65	28.65	28.65	28.65	100.0
2010-02-04 07:00:00	MSFT	Stock	28.61	28.61	28.55	28.55	4500.0
2010-02-04 08:00:00	MSFT	Stock	28.55	28.55	28.45	28.47	16920.0
2010-02-04 09:00:00	MSFT	Stock	28.47	28.54	28.12	28.149	7156903.0
2010-02-04 10:00:00	MSFT	Stock	28.14	28.26	27.9	27.902	14739134.0
2010-02-04 11:00:00	MSFT	Stock	27.9	28.15	27.86	28.013	9238030.0
2010-02-04 12:00:00	MSFT	Stock	28.01	28.08	27.88	28.01	6741658.0
2010-02-04 13:00:00	MSFT	Stock	28.0	28.14	27.965	28.05	6128031.0
2010-02-04 14:00:00	MSFT	Stock	28.05	28.11	27.98	28.04	6836254.0
2010-02-04 15:00:00	MSFT	Stock	28.04	28.06	27.81	27.81	20366816.0
2010-02-04 16:00:00	MSFT	Stock	27.82	28.04	27.81	27.9	3673538.0
2010-02-04 17:00:00	MSFT	Stock	27.9	27.92	27.81	27.9	13104.0
2010-02-04 18:00:00	MSFT	Stock	27.86	27.86	27.82	27.85	28834.0
2010-02-04 19:00:00	MSFT	Stock	27.86	27.86	27.81	27.83	3400.0
2010-02-04 20:00:00	MSFT	Stock	27.97	27.97	27.97	27.97	13900.0
2010-02-04 08:00:00	NVDA	Stock	0.42	0.42	0.4175	0.4175	500000.0
2010-02-04 09:00:00	NVDA	Stock	0.4175	0.4182	0.4032	0.404	80031880.0
2010-02-04 10:00:00	NVDA	Stock	0.4038	0.4155	0.3982	0.4013	146977320.0
2010-02-04 11:00:00	NVDA	Stock	0.4013	0.4022	0.3978	0.3978	99423200.0
2010-02-04 12:00:00	NVDA	Stock	0.3978	0.399	0.3938	0.3953	84409040.0
2010-02-04 13:00:00	NVDA	Stock	0.3955	0.3965	0.393	0.3935	68778320.0
2010-02-04 14:00:00	NVDA	Stock	0.3933	0.4005	0.393	0.3996	96919560.0
2010-02-04 15:00:00	NVDA	Stock	0.3998	0.4005	0.3962	0.397	143424280.0
2010-02-04 16:00:00	NVDA	Stock	0.397	0.3995	0.396	0.397	33641880.0
2010-02-04 17:00:00	NVDA	Stock	0.422	0.422	0.397	0.397	139760.0
2010-02-04 18:00:00	NVDA	Stock	0.397	0.397	0.397	0.397	9423880.0
2010-02-04 04:00:00	AMZN	Stock	5.95	5.95	5.95	5.95	2000.0
2010-02-04 07:00:00	AMZN	Stock	5.945	5.9455	5.9305	5.945	39000.0
2010-02-04 08:00:00	AMZN	Stock	5.944	5.946	5.9075	5.9185	713840.0
2010-02-04 09:00:00	AMZN	Stock	5.92	6.0165	5.8595	5.874	50696380.0
2010-02-04 10:00:00	AMZN	Stock	5.8735	5.889	5.839	5.8675	49076480.0
2010-02-04 11:00:00	AMZN	Stock	5.8675	5.8865	5.8035	5.815	30117860.0
2010-02-04 12:00:00	AMZN	Stock	5.8153	5.8475	5.8	5.823	15996280.0
2010-02-04 13:00:00	AMZN	Stock	5.8235	5.852	5.8155	5.8165	22167160.0

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

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