PREVIEW / stock_1hour / 2018-08-03

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-08-03.parquet
  size:    1.1 MB
  rows:    48,400
  symbols: 2,779

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
2018-08-03 04:00:00	AAPL	Stock	51.65	51.75	51.625	51.655	42692.0
2018-08-03 05:00:00	AAPL	Stock	51.66	51.7075	51.66	51.685	5060.0
2018-08-03 06:00:00	AAPL	Stock	51.685	51.7425	51.6625	51.725	19792.0
2018-08-03 07:00:00	AAPL	Stock	51.74	51.92	51.74	51.8925	462944.0
2018-08-03 08:00:00	AAPL	Stock	51.7625	51.92	51.705	51.7325	779396.0
2018-08-03 09:00:00	AAPL	Stock	51.7325	51.8375	51.37	51.545	24016872.0
2018-08-03 10:00:00	AAPL	Stock	51.545	51.89	51.5375	51.6525	21106512.0
2018-08-03 11:00:00	AAPL	Stock	51.655	51.8475	51.625	51.755	11143308.0
2018-08-03 12:00:00	AAPL	Stock	51.7575	52.185	51.755	52.115	16152632.0
2018-08-03 13:00:00	AAPL	Stock	52.1125	52.1675	51.95	52.0588	9119828.0
2018-08-03 14:00:00	AAPL	Stock	52.0592	52.06	51.8325	51.87	8738228.0
2018-08-03 15:00:00	AAPL	Stock	51.87	52.0	51.8575	51.995	15136976.0
2018-08-03 16:00:00	AAPL	Stock	51.975	52.0422	51.9375	52.0125	7612180.0
2018-08-03 17:00:00	AAPL	Stock	52.02	52.025	51.9825	51.9825	72172.0
2018-08-03 18:00:00	AAPL	Stock	51.9875	52.02	51.9775	51.99	37372.0
2018-08-03 19:00:00	AAPL	Stock	51.9875	52.0175	51.9825	51.9825	51692.0
2018-08-03 04:00:00	MSFT	Stock	107.7	107.7	107.7	107.7	602.0
2018-08-03 05:00:00	MSFT	Stock	107.89	108.0	107.89	108.0	596.0
2018-08-03 06:00:00	MSFT	Stock	108.05	108.05	108.0	108.0	932.0
2018-08-03 07:00:00	MSFT	Stock	107.96	108.15	107.96	108.12	4985.0
2018-08-03 08:00:00	MSFT	Stock	108.0	108.15	107.64	107.64	26168.0
2018-08-03 09:00:00	MSFT	Stock	107.7	107.96	106.82	107.41	2602343.0
2018-08-03 10:00:00	MSFT	Stock	107.4	107.7	107.17	107.41	2684477.0
2018-08-03 11:00:00	MSFT	Stock	107.41	107.546	107.09	107.095	1566250.0
2018-08-03 12:00:00	MSFT	Stock	107.1	107.48	107.1	107.289	1182321.0
2018-08-03 13:00:00	MSFT	Stock	107.286	107.64	107.23	107.59	915424.0
2018-08-03 14:00:00	MSFT	Stock	107.58	107.665	107.46	107.63	1035128.0
2018-08-03 15:00:00	MSFT	Stock	107.64	108.05	107.62	108.03	2986136.0
2018-08-03 16:00:00	MSFT	Stock	108.04	108.07	107.96	108.0	3092697.0
2018-08-03 17:00:00	MSFT	Stock	107.99	108.02	107.98	108.02	5910.0
2018-08-03 18:00:00	MSFT	Stock	108.02	108.06	108.02	108.02	11200.0
2018-08-03 19:00:00	MSFT	Stock	107.96	107.96	107.96	107.96	1458.0
2018-08-03 07:00:00	NVDA	Stock	6.2938	6.3098	6.275	6.3075	199560.0
2018-08-03 08:00:00	NVDA	Stock	6.287	6.3088	6.275	6.2812	1801520.0
2018-08-03 09:00:00	NVDA	Stock	6.2925	6.3235	6.2733	6.2963	39994440.0
2018-08-03 10:00:00	NVDA	Stock	6.2972	6.3265	6.2786	6.291	39237360.0
2018-08-03 11:00:00	NVDA	Stock	6.2935	6.306	6.2738	6.2875	22506400.0
2018-08-03 12:00:00	NVDA	Stock	6.288	6.3148	6.288	6.2922	18512800.0
2018-08-03 13:00:00	NVDA	Stock	6.2933	6.3083	6.2883	6.2972	8714600.0
2018-08-03 14:00:00	NVDA	Stock	6.2975	6.3002	6.277	6.2943	14749200.0
2018-08-03 15:00:00	NVDA	Stock	6.2948	6.3038	6.2855	6.303	30897600.0
2018-08-03 16:00:00	NVDA	Stock	6.3025	6.3072	6.2902	6.3072	1429680.0
2018-08-03 17:00:00	NVDA	Stock	6.3025	6.3025	6.2975	6.3	53720.0
2018-08-03 18:00:00	NVDA	Stock	6.3	6.3025	6.3	6.3	82960.0
2018-08-03 19:00:00	NVDA	Stock	6.2995	6.3025	6.2995	6.3025	24720.0
2018-08-03 04:00:00	AMZN	Stock	92.05	92.05	92.05	92.05	4000.0
2018-08-03 05:00:00	AMZN	Stock	91.956	91.956	91.95	91.95	11000.0
2018-08-03 06:00:00	AMZN	Stock	91.95	91.985	91.9045	91.985	28380.0
2018-08-03 07:00:00	AMZN	Stock	92.08	92.2	91.951	92.1525	236920.0
2018-08-03 08:00:00	AMZN	Stock	92.0018	92.2	91.9	91.9	817240.0

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

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