PREVIEW / stock_1hour / 2010-03-18

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-03-18.parquet
  size:    904 KB
  rows:    43,205
  symbols: 3,467

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-03-18 05:00:00	AAPL	Stock	7.9671	7.9911	7.9632	7.9911	11200.0
2010-03-18 07:00:00	AAPL	Stock	7.9911	8.0232	7.9911	8.0029	39900.0
2010-03-18 08:00:00	AAPL	Stock	8.0054	8.0293	7.9911	8.0207	1360324.0
2010-03-18 09:00:00	AAPL	Stock	8.02	8.0229	7.9568	7.9657	54968424.0
2010-03-18 10:00:00	AAPL	Stock	7.9657	7.9971	7.9504	7.9947	65157988.0
2010-03-18 11:00:00	AAPL	Stock	7.9946	8.0132	7.9757	7.9779	47230344.0
2010-03-18 12:00:00	AAPL	Stock	7.9771	7.9889	7.9618	7.9807	25141368.0
2010-03-18 13:00:00	AAPL	Stock	7.9818	7.9993	7.9807	7.9873	20780172.0
2010-03-18 14:00:00	AAPL	Stock	7.9879	7.9978	7.9679	7.985	25306120.0
2010-03-18 15:00:00	AAPL	Stock	7.9846	8.0357	7.9757	8.0268	91973812.0
2010-03-18 16:00:00	AAPL	Stock	8.0257	8.0364	7.9893	8.0357	5756184.0
2010-03-18 17:00:00	AAPL	Stock	8.0379	8.0414	8.0232	8.0232	595756.0
2010-03-18 18:00:00	AAPL	Stock	8.025	8.0268	7.9946	8.0061	1008168.0
2010-03-18 19:00:00	AAPL	Stock	8.0064	8.0064	7.9896	7.9932	274232.0
2010-03-18 07:00:00	MSFT	Stock	29.48	29.59	29.48	29.59	535.0
2010-03-18 08:00:00	MSFT	Stock	29.55	29.64	29.52	29.6	18708.0
2010-03-18 09:00:00	MSFT	Stock	29.61	29.72	29.51	29.64	4844898.0
2010-03-18 10:00:00	MSFT	Stock	29.64	29.662	29.55	29.61	5008635.0
2010-03-18 11:00:00	MSFT	Stock	29.61	29.7	29.57	29.595	6156014.0
2010-03-18 12:00:00	MSFT	Stock	29.592	29.69	29.53	29.625	4768514.0
2010-03-18 13:00:00	MSFT	Stock	29.63	29.68	29.56	29.62	5179653.0
2010-03-18 14:00:00	MSFT	Stock	29.62	29.63	29.5	29.565	5508958.0
2010-03-18 15:00:00	MSFT	Stock	29.563	29.63	29.51	29.61	8590697.0
2010-03-18 16:00:00	MSFT	Stock	29.59	29.62	29.507	29.62	1593707.0
2010-03-18 17:00:00	MSFT	Stock	29.63	29.63	29.56	29.57	20135.0
2010-03-18 18:00:00	MSFT	Stock	29.56	29.57	29.53	29.57	4182.0
2010-03-18 19:00:00	MSFT	Stock	29.53	29.63	29.53	29.63	18446.0
2010-03-18 07:00:00	NVDA	Stock	0.45	0.45	0.45	0.45	48000.0
2010-03-18 08:00:00	NVDA	Stock	0.455	0.4575	0.45	0.4575	230200.0
2010-03-18 09:00:00	NVDA	Stock	0.4575	0.4575	0.4378	0.4438	80958600.0
2010-03-18 10:00:00	NVDA	Stock	0.4438	0.4448	0.4375	0.4382	124464520.0
2010-03-18 11:00:00	NVDA	Stock	0.438	0.4406	0.4355	0.4365	95353000.0
2010-03-18 12:00:00	NVDA	Stock	0.4365	0.4368	0.4325	0.434	99216880.0
2010-03-18 13:00:00	NVDA	Stock	0.4342	0.4355	0.4335	0.4345	68368920.0
2010-03-18 14:00:00	NVDA	Stock	0.4342	0.4352	0.4325	0.4335	85470560.0
2010-03-18 15:00:00	NVDA	Stock	0.4335	0.438	0.4328	0.437	174849360.0
2010-03-18 16:00:00	NVDA	Stock	0.437	0.4374	0.4355	0.437	8843840.0
2010-03-18 17:00:00	NVDA	Stock	0.4525	0.4525	0.437	0.4372	104000.0
2010-03-18 18:00:00	NVDA	Stock	0.437	0.437	0.437	0.437	12000.0
2010-03-18 19:00:00	NVDA	Stock	0.437	0.437	0.4365	0.437	50000.0
2010-03-18 07:00:00	AMZN	Stock	6.5665	6.5665	6.5665	6.5665	7340.0
2010-03-18 08:00:00	AMZN	Stock	6.565	6.565	6.565	6.565	2000.0
2010-03-18 09:00:00	AMZN	Stock	6.57	6.5905	6.522	6.5805	14330640.0
2010-03-18 10:00:00	AMZN	Stock	6.5805	6.599	6.557	6.584	17353840.0
2010-03-18 11:00:00	AMZN	Stock	6.5843	6.625	6.5815	6.618	14530940.0
2010-03-18 12:00:00	AMZN	Stock	6.618	6.625	6.5985	6.6102	8193560.0
2010-03-18 13:00:00	AMZN	Stock	6.61	6.623	6.6025	6.608	8512500.0
2010-03-18 14:00:00	AMZN	Stock	6.6075	6.622	6.596	6.6195	9581040.0
2010-03-18 15:00:00	AMZN	Stock	6.6195	6.6425	6.6115	6.6345	23682920.0
2010-03-18 16:00:00	AMZN	Stock	6.6375	6.646	6.5995	6.6415	4099400.0

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

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