PREVIEW / stock_1hour / 2015-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-03-23.parquet
  size:    1.1 MB
  rows:    48,923
  symbols: 3,507

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
2015-03-23 04:00:00	AAPL	Stock	31.595	31.6475	31.575	31.6475	34496.0
2015-03-23 05:00:00	AAPL	Stock	31.6475	31.685	31.6325	31.685	20936.0
2015-03-23 06:00:00	AAPL	Stock	31.66	31.675	31.6275	31.6275	119824.0
2015-03-23 07:00:00	AAPL	Stock	31.64	31.71	31.625	31.7	92336.0
2015-03-23 08:00:00	AAPL	Stock	31.69	31.745	31.475	31.7425	1052288.0
2015-03-23 09:00:00	AAPL	Stock	31.7375	31.8	31.475	31.6615	23858640.0
2015-03-23 10:00:00	AAPL	Stock	31.6612	31.8625	31.6325	31.8125	22145988.0
2015-03-23 11:00:00	AAPL	Stock	31.8125	31.835	31.6775	31.815	16381128.0
2015-03-23 12:00:00	AAPL	Stock	31.815	31.8725	31.7775	31.86	11367688.0
2015-03-23 13:00:00	AAPL	Stock	31.8575	31.935	31.8375	31.905	12488592.0
2015-03-23 14:00:00	AAPL	Stock	31.9025	31.9625	31.8932	31.91	11141324.0
2015-03-23 15:00:00	AAPL	Stock	31.9125	31.925	31.7525	31.8025	23091656.0
2015-03-23 16:00:00	AAPL	Stock	31.804	31.8472	31.7625	31.7725	16611920.0
2015-03-23 17:00:00	AAPL	Stock	31.77	31.8025	31.692	31.7625	2259248.0
2015-03-23 18:00:00	AAPL	Stock	31.7625	31.8025	31.7625	31.795	109240.0
2015-03-23 19:00:00	AAPL	Stock	31.7975	31.835	31.7975	31.82	139608.0
2015-03-23 08:00:00	MSFT	Stock	42.65	42.79	42.65	42.73	1686.0
2015-03-23 09:00:00	MSFT	Stock	42.78	43.09	42.78	42.98	2897059.0
2015-03-23 10:00:00	MSFT	Stock	42.98	43.13	42.98	42.99	3070729.0
2015-03-23 11:00:00	MSFT	Stock	43.0	43.005	42.78	42.84	2625704.0
2015-03-23 12:00:00	MSFT	Stock	42.84	43.06	42.81	42.975	2071958.0
2015-03-23 13:00:00	MSFT	Stock	42.98	43.0	42.9	42.92	1995714.0
2015-03-23 14:00:00	MSFT	Stock	42.921	43.03	42.9	42.986	2333132.0
2015-03-23 15:00:00	MSFT	Stock	42.985	43.04	42.85	42.85	5644342.0
2015-03-23 16:00:00	MSFT	Stock	42.855	42.957	42.855	42.86	4576651.0
2015-03-23 17:00:00	MSFT	Stock	42.9	42.9	42.855	42.88	11407.0
2015-03-23 18:00:00	MSFT	Stock	42.88	42.88	42.87	42.87	700.0
2015-03-23 19:00:00	MSFT	Stock	42.86	42.86	42.85	42.85	800.0
2015-03-23 04:00:00	NVDA	Stock	0.5868	0.5868	0.5798	0.5798	8000.0
2015-03-23 06:00:00	NVDA	Stock	0.5728	0.5728	0.5672	0.5672	50320.0
2015-03-23 08:00:00	NVDA	Stock	0.5665	0.5725	0.5655	0.567	584800.0
2015-03-23 09:00:00	NVDA	Stock	0.5678	0.5768	0.5675	0.5682	60117480.0
2015-03-23 10:00:00	NVDA	Stock	0.5682	0.5748	0.5682	0.5738	58002040.0
2015-03-23 11:00:00	NVDA	Stock	0.5738	0.5745	0.57	0.5708	55586560.0
2015-03-23 12:00:00	NVDA	Stock	0.5708	0.5712	0.5695	0.5698	38340960.0
2015-03-23 13:00:00	NVDA	Stock	0.5698	0.572	0.5698	0.5718	30981080.0
2015-03-23 14:00:00	NVDA	Stock	0.5718	0.5722	0.5686	0.5695	38837880.0
2015-03-23 15:00:00	NVDA	Stock	0.5695	0.57	0.5675	0.5678	79772960.0
2015-03-23 16:00:00	NVDA	Stock	0.5678	0.571	0.565	0.571	9702560.0
2015-03-23 17:00:00	NVDA	Stock	0.5678	0.5725	0.5678	0.5725	261800.0
2015-03-23 18:00:00	NVDA	Stock	0.5712	0.5712	0.5702	0.5702	111200.0
2015-03-23 19:00:00	NVDA	Stock	0.5708	0.5708	0.57	0.57	24000.0
2015-03-23 08:00:00	AMZN	Stock	18.87	18.87	18.87	18.87	2720.0
2015-03-23 09:00:00	AMZN	Stock	18.8625	19.0885	18.8625	19.0125	8639700.0
2015-03-23 10:00:00	AMZN	Stock	19.0155	19.0698	18.9135	18.943	6015740.0
2015-03-23 11:00:00	AMZN	Stock	18.9391	18.978	18.9	18.977	4368120.0
2015-03-23 12:00:00	AMZN	Stock	18.9725	18.978	18.9	18.912	4074040.0
2015-03-23 13:00:00	AMZN	Stock	18.911	18.9195	18.8385	18.8768	2872560.0
2015-03-23 14:00:00	AMZN	Stock	18.875	18.913	18.851	18.855	3456280.0
2015-03-23 15:00:00	AMZN	Stock	18.852	18.8935	18.747	18.7555	8636800.0

> showing 50 of 48,923 rows — these rows as CSV

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