PREVIEW / stock_1hour / 2015-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-01-27.parquet
  size:    1.0 MB
  rows:    48,700
  symbols: 3,506

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-01-27 04:00:00	AAPL	Stock	28.4	28.4625	28.4	28.4375	25912.0
2015-01-27 05:00:00	AAPL	Stock	28.445	28.445	28.375	28.42	38364.0
2015-01-27 06:00:00	AAPL	Stock	28.3925	28.43	28.3375	28.3725	39464.0
2015-01-27 07:00:00	AAPL	Stock	28.3725	28.4175	28.2	28.24	635648.0
2015-01-27 08:00:00	AAPL	Stock	28.24	28.42	28.005	28.1375	3161988.0
2015-01-27 09:00:00	AAPL	Stock	28.13	28.175	27.635	27.7752	45552828.0
2015-01-27 10:00:00	AAPL	Stock	27.775	27.835	27.4375	27.5325	45390500.0
2015-01-27 11:00:00	AAPL	Stock	27.5348	27.7325	27.5225	27.625	32168972.0
2015-01-27 12:00:00	AAPL	Stock	27.6225	27.85	27.5775	27.8025	26172688.0
2015-01-27 13:00:00	AAPL	Stock	27.8025	27.9025	27.675	27.6788	27520092.0
2015-01-27 14:00:00	AAPL	Stock	27.6775	27.85	27.67	27.745	27140448.0
2015-01-27 15:00:00	AAPL	Stock	27.75	27.8	27.2575	27.2875	67930004.0
2015-01-27 16:00:00	AAPL	Stock	27.2875	29.115	27.2775	28.66	62009844.0
2015-01-27 17:00:00	AAPL	Stock	28.655	28.7225	27.285	28.65	14449724.0
2015-01-27 18:00:00	AAPL	Stock	28.6525	28.875	28.65	28.86	5635784.0
2015-01-27 19:00:00	AAPL	Stock	28.8625	28.87	28.7825	28.85	1819984.0
2015-01-27 04:00:00	MSFT	Stock	45.01	45.48	45.0	45.24	12503.0
2015-01-27 05:00:00	MSFT	Stock	45.24	45.3	44.52	44.52	36871.0
2015-01-27 06:00:00	MSFT	Stock	44.6	44.69	43.36	43.6	191986.0
2015-01-27 07:00:00	MSFT	Stock	43.62	43.85	43.3	43.4	1411493.0
2015-01-27 08:00:00	MSFT	Stock	43.65	45.0	42.85	42.95	6316267.0
2015-01-27 09:00:00	MSFT	Stock	42.96	43.32	42.105	42.5	41181244.0
2015-01-27 10:00:00	MSFT	Stock	42.5	42.63	42.2	42.345	29945256.0
2015-01-27 11:00:00	MSFT	Stock	42.34	42.78	42.29	42.58	23016162.0
2015-01-27 12:00:00	MSFT	Stock	42.58	43.02	42.56	42.764	16406321.0
2015-01-27 13:00:00	MSFT	Stock	42.764	43.17	42.75	43.0	11314098.0
2015-01-27 14:00:00	MSFT	Stock	43.0	43.09	42.86	42.93	10661392.0
2015-01-27 15:00:00	MSFT	Stock	42.925	43.005	42.56	42.67	17729971.0
2015-01-27 16:00:00	MSFT	Stock	42.66	42.841	42.327	42.82	4244723.0
2015-01-27 17:00:00	MSFT	Stock	42.8	42.8	42.66	42.78	39324.0
2015-01-27 18:00:00	MSFT	Stock	42.8	42.81	42.75	42.75	18526.0
2015-01-27 19:00:00	MSFT	Stock	42.79	42.79	42.74	42.74	10757.0
2015-01-27 08:00:00	NVDA	Stock	0.51	0.5102	0.51	0.51	1020000.0
2015-01-27 09:00:00	NVDA	Stock	0.5085	0.5088	0.5025	0.5025	38453200.0
2015-01-27 10:00:00	NVDA	Stock	0.5025	0.5036	0.4951	0.4992	61763040.0
2015-01-27 11:00:00	NVDA	Stock	0.4992	0.5004	0.496	0.4968	30642680.0
2015-01-27 12:00:00	NVDA	Stock	0.4968	0.5003	0.496	0.4985	36534640.0
2015-01-27 13:00:00	NVDA	Stock	0.4985	0.5	0.497	0.4978	28749240.0
2015-01-27 14:00:00	NVDA	Stock	0.4978	0.5003	0.497	0.497	31366920.0
2015-01-27 15:00:00	NVDA	Stock	0.4972	0.4981	0.4898	0.4898	101428680.0
2015-01-27 16:00:00	NVDA	Stock	0.4898	0.5154	0.4898	0.5154	14822440.0
2015-01-27 17:00:00	NVDA	Stock	0.4965	0.4965	0.4965	0.4965	14000.0
2015-01-27 18:00:00	NVDA	Stock	0.4965	0.497	0.4965	0.4965	52000.0
2015-01-27 19:00:00	NVDA	Stock	0.497	0.497	0.497	0.497	8000.0
2015-01-27 07:00:00	AMZN	Stock	15.4	15.4	15.4	15.4	17380.0
2015-01-27 08:00:00	AMZN	Stock	15.3975	15.3975	15.2815	15.319	154660.0
2015-01-27 09:00:00	AMZN	Stock	15.326	15.3285	15.2005	15.225	7912600.0
2015-01-27 10:00:00	AMZN	Stock	15.23	15.269	15.1312	15.213	11454140.0
2015-01-27 11:00:00	AMZN	Stock	15.2125	15.364	15.1795	15.294	7469980.0
2015-01-27 12:00:00	AMZN	Stock	15.2875	15.3735	15.2595	15.342	4544260.0

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

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