PREVIEW / stock_1hour / 2017-10-17

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-17.parquet
  size:    1.1 MB
  rows:    48,213
  symbols: 2,950

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
2017-10-17 04:00:00	AAPL	Stock	39.99	39.99	39.9075	39.9075	2264.0
2017-10-17 05:00:00	AAPL	Stock	39.9025	39.9025	39.89	39.89	4512.0
2017-10-17 06:00:00	AAPL	Stock	39.9125	39.9525	39.91	39.95	18692.0
2017-10-17 07:00:00	AAPL	Stock	39.95	39.95	39.8875	39.9325	38372.0
2017-10-17 08:00:00	AAPL	Stock	39.95	40.06	39.89	39.94	126964.0
2017-10-17 09:00:00	AAPL	Stock	39.94	40.05	39.8075	39.895	12286492.0
2017-10-17 10:00:00	AAPL	Stock	39.8925	39.9852	39.8325	39.965	9384180.0
2017-10-17 11:00:00	AAPL	Stock	39.9625	40.2175	39.935	39.9745	16907340.0
2017-10-17 12:00:00	AAPL	Stock	39.975	40.005	39.9175	39.94	5340648.0
2017-10-17 13:00:00	AAPL	Stock	39.9405	40.125	39.93	40.0088	6661368.0
2017-10-17 14:00:00	AAPL	Stock	40.0088	40.0875	40.0025	40.0522	4555520.0
2017-10-17 15:00:00	AAPL	Stock	40.0525	40.135	40.0275	40.1175	9274916.0
2017-10-17 16:00:00	AAPL	Stock	40.1175	40.1475	40.0925	40.1175	4550852.0
2017-10-17 17:00:00	AAPL	Stock	40.1	40.1325	40.095	40.1325	37092.0
2017-10-17 18:00:00	AAPL	Stock	40.125	40.135	40.1	40.1175	21756.0
2017-10-17 19:00:00	AAPL	Stock	40.13	40.13	40.1075	40.12	39520.0
2017-10-17 05:00:00	MSFT	Stock	77.22	77.22	77.0	77.11	976.0
2017-10-17 06:00:00	MSFT	Stock	77.56	77.56	77.56	77.56	118.0
2017-10-17 07:00:00	MSFT	Stock	77.38	77.56	77.38	77.56	424.0
2017-10-17 08:00:00	MSFT	Stock	77.55	77.64	77.48	77.48	2340.0
2017-10-17 09:00:00	MSFT	Stock	77.49	77.59	77.3	77.395	1412532.0
2017-10-17 10:00:00	MSFT	Stock	77.4	77.45	77.25	77.41	1918300.0
2017-10-17 11:00:00	MSFT	Stock	77.405	77.54	77.39	77.46	1579554.0
2017-10-17 12:00:00	MSFT	Stock	77.46	77.51	77.38	77.38	1512246.0
2017-10-17 13:00:00	MSFT	Stock	77.38	77.43	77.325	77.36	1349968.0
2017-10-17 14:00:00	MSFT	Stock	77.37	77.43	77.33	77.374	1008051.0
2017-10-17 15:00:00	MSFT	Stock	77.375	77.62	77.32	77.57	2475445.0
2017-10-17 16:00:00	MSFT	Stock	77.59	77.64	77.53	77.59	1984935.0
2017-10-17 17:00:00	MSFT	Stock	77.63	77.67	77.62	77.63	5173.0
2017-10-17 18:00:00	MSFT	Stock	77.6	77.6	77.52	77.52	554.0
2017-10-17 19:00:00	MSFT	Stock	77.62	77.62	77.62	77.62	100.0
2017-10-17 04:00:00	NVDA	Stock	4.9642	4.9642	4.9642	4.9642	4000.0
2017-10-17 06:00:00	NVDA	Stock	4.955	4.955	4.9415	4.9415	46000.0
2017-10-17 07:00:00	NVDA	Stock	4.9415	4.9453	4.9268	4.93	445400.0
2017-10-17 08:00:00	NVDA	Stock	4.9412	4.9475	4.9275	4.9312	1479000.0
2017-10-17 09:00:00	NVDA	Stock	4.9312	4.964	4.9088	4.9572	80647000.0
2017-10-17 10:00:00	NVDA	Stock	4.9578	4.9725	4.9264	4.948	102926520.0
2017-10-17 11:00:00	NVDA	Stock	4.9475	4.9524	4.93	4.9379	43127320.0
2017-10-17 12:00:00	NVDA	Stock	4.9385	4.9398	4.914	4.9264	34006040.0
2017-10-17 13:00:00	NVDA	Stock	4.9265	4.957	4.926	4.9403	40473000.0
2017-10-17 14:00:00	NVDA	Stock	4.94	4.9488	4.9202	4.9412	55389520.0
2017-10-17 15:00:00	NVDA	Stock	4.9415	4.9498	4.9275	4.943	49152520.0
2017-10-17 16:00:00	NVDA	Stock	4.9438	4.9453	4.9352	4.9438	8139640.0
2017-10-17 17:00:00	NVDA	Stock	4.9375	4.9425	4.9312	4.935	201880.0
2017-10-17 18:00:00	NVDA	Stock	4.9325	4.9425	4.9325	4.9425	212040.0
2017-10-17 19:00:00	NVDA	Stock	4.94	4.9412	4.9392	4.94	337480.0
2017-10-17 07:00:00	AMZN	Stock	50.3315	50.3315	50.3315	50.3315	2000.0
2017-10-17 08:00:00	AMZN	Stock	50.26	50.2615	50.225	50.225	48540.0
2017-10-17 09:00:00	AMZN	Stock	50.225	50.517	50.125	50.446	8348260.0
2017-10-17 10:00:00	AMZN	Stock	50.4315	50.5735	50.431	50.5025	7209560.0

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

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