PREVIEW / stock_1hour / 2017-10-27

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-10-27.parquet
  size:    1.1 MB
  rows:    48,366
  symbols: 2,930

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-27 04:00:00	AAPL	Stock	39.5325	39.5325	39.505	39.505	2292.0
2017-10-27 05:00:00	AAPL	Stock	39.55	39.6	39.55	39.6	56708.0
2017-10-27 06:00:00	AAPL	Stock	39.6225	39.7125	39.6025	39.7125	104332.0
2017-10-27 07:00:00	AAPL	Stock	39.6875	39.8125	39.6475	39.7675	328004.0
2017-10-27 08:00:00	AAPL	Stock	39.75	39.985	39.535	39.8775	935240.0
2017-10-27 09:00:00	AAPL	Stock	39.8775	40.0375	39.675	39.88	23110708.0
2017-10-27 10:00:00	AAPL	Stock	39.8875	40.2475	39.8625	40.2062	26929116.0
2017-10-27 11:00:00	AAPL	Stock	40.205	40.6125	40.155	40.5975	22498564.0
2017-10-27 12:00:00	AAPL	Stock	40.595	40.7375	40.515	40.5562	19393448.0
2017-10-27 13:00:00	AAPL	Stock	40.559	40.787	40.5425	40.7785	13739192.0
2017-10-27 14:00:00	AAPL	Stock	40.7775	40.9	40.58	40.65	18493120.0
2017-10-27 15:00:00	AAPL	Stock	40.6475	40.7875	40.6275	40.7575	24033688.0
2017-10-27 16:00:00	AAPL	Stock	40.7575	40.805	40.725	40.7375	12685624.0
2017-10-27 17:00:00	AAPL	Stock	40.725	40.7625	40.7175	40.7175	651296.0
2017-10-27 18:00:00	AAPL	Stock	40.7475	40.7575	40.675	40.7375	99532.0
2017-10-27 19:00:00	AAPL	Stock	40.7375	40.7575	40.6925	40.6925	58904.0
2017-10-27 04:00:00	MSFT	Stock	82.01	82.4	82.0	82.2	10714.0
2017-10-27 05:00:00	MSFT	Stock	82.05	82.5	82.05	82.5	12613.0
2017-10-27 06:00:00	MSFT	Stock	82.51	82.59	82.42	82.45	10782.0
2017-10-27 07:00:00	MSFT	Stock	82.3	83.51	82.05	83.33	116951.0
2017-10-27 08:00:00	MSFT	Stock	82.5	84.67	82.05	84.65	1323603.0
2017-10-27 09:00:00	MSFT	Stock	84.67	86.2	83.61	85.64	19801065.0
2017-10-27 10:00:00	MSFT	Stock	85.63	85.85	84.42	84.44	11351483.0
2017-10-27 11:00:00	MSFT	Stock	84.434	84.79	83.91	84.07	7856314.0
2017-10-27 12:00:00	MSFT	Stock	84.07	84.6	84.01	84.43	5436068.0
2017-10-27 13:00:00	MSFT	Stock	84.43	84.49	84.07	84.32	3053700.0
2017-10-27 14:00:00	MSFT	Stock	84.32	84.68	84.29	84.62	3289904.0
2017-10-27 15:00:00	MSFT	Stock	84.62	84.855	83.61	83.82	8460893.0
2017-10-27 16:00:00	MSFT	Stock	83.84	84.432	83.77	83.94	5406900.0
2017-10-27 17:00:00	MSFT	Stock	83.93	83.99	83.82	83.94	8097.0
2017-10-27 18:00:00	MSFT	Stock	83.94	83.98	83.89	83.89	3500.0
2017-10-27 19:00:00	MSFT	Stock	83.95	83.99	83.86	83.99	34362.0
2017-10-27 04:00:00	NVDA	Stock	4.929	4.929	4.929	4.929	13520.0
2017-10-27 05:00:00	NVDA	Stock	4.935	4.935	4.9315	4.9315	29080.0
2017-10-27 06:00:00	NVDA	Stock	4.9338	4.9338	4.927	4.927	91200.0
2017-10-27 07:00:00	NVDA	Stock	4.93	4.9385	4.93	4.9362	214440.0
2017-10-27 08:00:00	NVDA	Stock	4.9375	4.95	4.916	4.9388	2525720.0
2017-10-27 09:00:00	NVDA	Stock	4.9338	4.9642	4.9308	4.9448	67395240.0
2017-10-27 10:00:00	NVDA	Stock	4.943	4.9485	4.9193	4.9193	64467040.0
2017-10-27 11:00:00	NVDA	Stock	4.9202	4.9958	4.9188	4.9955	89268560.0
2017-10-27 12:00:00	NVDA	Stock	4.9948	5.0225	4.9782	4.986	101196240.0
2017-10-27 13:00:00	NVDA	Stock	4.9864	5.0178	4.981	5.0175	43484120.0
2017-10-27 14:00:00	NVDA	Stock	5.0157	5.0175	5.003	5.0113	34038960.0
2017-10-27 15:00:00	NVDA	Stock	5.0105	5.0468	5.0085	5.0438	85606960.0
2017-10-27 16:00:00	NVDA	Stock	5.0465	5.0495	5.0405	5.0425	16556520.0
2017-10-27 17:00:00	NVDA	Stock	5.0475	5.05	5.044	5.045	749760.0
2017-10-27 18:00:00	NVDA	Stock	5.048	5.05	5.0452	5.05	383040.0
2017-10-27 19:00:00	NVDA	Stock	5.0515	5.0593	5.05	5.0588	179240.0
2017-10-27 04:00:00	AMZN	Stock	52.1	52.29	52.05	52.1555	189080.0
2017-10-27 05:00:00	AMZN	Stock	52.18	52.35	52.155	52.35	125260.0

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

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