PREVIEW / stock_1hour / 2016-03-07

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-07.parquet
  size:    1.0 MB
  rows:    49,524
  symbols: 3,366

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
2016-03-07 04:00:00	AAPL	Stock	25.7525	25.7525	25.7525	25.7525	2000.0
2016-03-07 05:00:00	AAPL	Stock	25.6675	25.7075	25.63	25.63	35260.0
2016-03-07 06:00:00	AAPL	Stock	25.6575	25.75	25.6425	25.7275	95732.0
2016-03-07 07:00:00	AAPL	Stock	25.7275	25.795	25.725	25.795	194004.0
2016-03-07 08:00:00	AAPL	Stock	25.7725	25.795	25.7075	25.725	456244.0
2016-03-07 09:00:00	AAPL	Stock	25.73	25.73	25.505	25.5125	22093804.0
2016-03-07 10:00:00	AAPL	Stock	25.51	25.5875	25.425	25.5288	23760420.0
2016-03-07 11:00:00	AAPL	Stock	25.5275	25.5875	25.4725	25.5225	17815464.0
2016-03-07 12:00:00	AAPL	Stock	25.5245	25.5375	25.4895	25.5025	7276876.0
2016-03-07 13:00:00	AAPL	Stock	25.5025	25.5275	25.35	25.4225	13890500.0
2016-03-07 14:00:00	AAPL	Stock	25.42	25.445	25.32	25.3275	15113856.0
2016-03-07 15:00:00	AAPL	Stock	25.3275	25.48	25.24	25.4675	23900064.0
2016-03-07 16:00:00	AAPL	Stock	25.4675	25.47	25.425	25.44	5506060.0
2016-03-07 17:00:00	AAPL	Stock	25.45	25.4625	25.4225	25.4375	53492.0
2016-03-07 18:00:00	AAPL	Stock	25.425	25.445	25.425	25.4275	30800.0
2016-03-07 19:00:00	AAPL	Stock	25.4425	25.4425	25.4225	25.4225	19516.0
2016-03-07 04:00:00	MSFT	Stock	51.85	51.85	51.85	51.85	130.0
2016-03-07 06:00:00	MSFT	Stock	51.72	51.72	51.65	51.72	1225.0
2016-03-07 07:00:00	MSFT	Stock	51.75	51.79	51.7	51.79	4600.0
2016-03-07 08:00:00	MSFT	Stock	51.79	51.79	51.68	51.7	27780.0
2016-03-07 09:00:00	MSFT	Stock	51.71	51.92	51.3	51.35	3136062.0
2016-03-07 10:00:00	MSFT	Stock	51.35	51.496	51.01	51.06	4968071.0
2016-03-07 11:00:00	MSFT	Stock	51.06	51.26	50.8	51.15	5526007.0
2016-03-07 12:00:00	MSFT	Stock	51.16	51.43	51.08	51.27	2470152.0
2016-03-07 13:00:00	MSFT	Stock	51.27	51.41	50.92	50.99	3923963.0
2016-03-07 14:00:00	MSFT	Stock	50.99	51.11	50.6	50.704	5324188.0
2016-03-07 15:00:00	MSFT	Stock	50.7	51.05	50.58	51.02	7721833.0
2016-03-07 16:00:00	MSFT	Stock	51.02	51.276	50.9	51.01	2329914.0
2016-03-07 17:00:00	MSFT	Stock	51.03	51.03	50.93	50.93	200.0
2016-03-07 18:00:00	MSFT	Stock	51.0	51.0	51.0	51.0	450.0
2016-03-07 19:00:00	MSFT	Stock	51.0	51.0	51.0	51.0	1702.0
2016-03-07 04:00:00	NVDA	Stock	0.85	0.85	0.8482	0.8482	12000.0
2016-03-07 06:00:00	NVDA	Stock	0.8125	0.8125	0.811	0.811	8000.0
2016-03-07 07:00:00	NVDA	Stock	0.8095	0.8095	0.8095	0.8095	4000.0
2016-03-07 08:00:00	NVDA	Stock	0.809	0.8125	0.809	0.8125	58000.0
2016-03-07 09:00:00	NVDA	Stock	0.8085	0.8123	0.804	0.8043	20793040.0
2016-03-07 10:00:00	NVDA	Stock	0.8043	0.8088	0.802	0.8074	28436160.0
2016-03-07 11:00:00	NVDA	Stock	0.8072	0.8142	0.8062	0.8105	22312960.0
2016-03-07 12:00:00	NVDA	Stock	0.8102	0.8148	0.8094	0.8135	10451120.0
2016-03-07 13:00:00	NVDA	Stock	0.8135	0.814	0.8052	0.8059	20133120.0
2016-03-07 14:00:00	NVDA	Stock	0.8062	0.8069	0.7988	0.8	35340640.0
2016-03-07 15:00:00	NVDA	Stock	0.8002	0.8085	0.7979	0.8085	50062320.0
2016-03-07 16:00:00	NVDA	Stock	0.8085	0.8138	0.8069	0.8138	1728800.0
2016-03-07 17:00:00	NVDA	Stock	0.8075	0.8125	0.8075	0.8125	46000.0
2016-03-07 19:00:00	NVDA	Stock	0.812	0.812	0.812	0.812	4000.0
2016-03-07 04:00:00	AMZN	Stock	28.731	28.731	28.731	28.731	6400.0
2016-03-07 07:00:00	AMZN	Stock	28.6375	28.6375	28.6375	28.6375	3780.0
2016-03-07 08:00:00	AMZN	Stock	28.697	28.697	28.6005	28.6005	118760.0
2016-03-07 09:00:00	AMZN	Stock	28.5755	28.6815	28.0805	28.0822	10100980.0
2016-03-07 10:00:00	AMZN	Stock	28.083	28.1775	27.9125	27.957	19324480.0

> showing 50 of 49,524 rows — these rows as CSV

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