PREVIEW / stock_1hour / 2019-04-17

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-04-17.parquet
  size:    1.1 MB
  rows:    49,945
  symbols: 2,634

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
2019-04-17 04:00:00	AAPL	Stock	49.725	49.745	49.6725	49.745	27000.0
2019-04-17 05:00:00	AAPL	Stock	49.75	49.825	49.75	49.825	17184.0
2019-04-17 06:00:00	AAPL	Stock	49.85	49.8775	49.8125	49.8725	23004.0
2019-04-17 07:00:00	AAPL	Stock	49.8175	50.01	49.8125	49.8925	150420.0
2019-04-17 08:00:00	AAPL	Stock	49.86	50.0475	49.8175	50.025	326284.0
2019-04-17 09:00:00	AAPL	Stock	50.0025	50.325	49.6525	49.99	22184460.0
2019-04-17 10:00:00	AAPL	Stock	50.0025	50.395	49.9075	50.3425	15293668.0
2019-04-17 11:00:00	AAPL	Stock	50.345	50.5	50.3	50.4708	9737248.0
2019-04-17 12:00:00	AAPL	Stock	50.4705	50.6175	50.38	50.615	9448472.0
2019-04-17 13:00:00	AAPL	Stock	50.6175	50.82	50.6075	50.7525	10705428.0
2019-04-17 14:00:00	AAPL	Stock	50.7548	50.77	50.565	50.71	11193688.0
2019-04-17 15:00:00	AAPL	Stock	50.715	50.845	50.6875	50.78	14962552.0
2019-04-17 16:00:00	AAPL	Stock	50.78	50.8375	50.74	50.75	6105180.0
2019-04-17 17:00:00	AAPL	Stock	50.74	50.7625	50.74	50.7625	42928.0
2019-04-17 18:00:00	AAPL	Stock	50.75	50.77	50.7375	50.77	82152.0
2019-04-17 19:00:00	AAPL	Stock	50.77	50.775	50.745	50.775	50644.0
2019-04-17 04:00:00	MSFT	Stock	121.19	121.25	121.15	121.21	900.0
2019-04-17 07:00:00	MSFT	Stock	121.15	121.16	120.76	120.76	23341.0
2019-04-17 08:00:00	MSFT	Stock	121.15	121.15	120.7	120.72	54540.0
2019-04-17 09:00:00	MSFT	Stock	120.75	121.44	120.7	120.84	2294228.0
2019-04-17 10:00:00	MSFT	Stock	120.84	121.316	120.54	121.06	2591577.0
2019-04-17 11:00:00	MSFT	Stock	121.057	121.34	120.89	121.165	1874021.0
2019-04-17 12:00:00	MSFT	Stock	121.165	121.47	120.91	121.41	1747577.0
2019-04-17 13:00:00	MSFT	Stock	121.41	121.58	121.2	121.35	1570335.0
2019-04-17 14:00:00	MSFT	Stock	121.35	121.446	121.17	121.36	1300787.0
2019-04-17 15:00:00	MSFT	Stock	121.37	121.85	121.22	121.75	3120953.0
2019-04-17 16:00:00	MSFT	Stock	121.77	121.77	121.0	121.1	1911203.0
2019-04-17 17:00:00	MSFT	Stock	121.18	121.25	121.18	121.25	5600.0
2019-04-17 18:00:00	MSFT	Stock	121.25	121.25	121.2	121.24	2933.0
2019-04-17 19:00:00	MSFT	Stock	121.24	121.25	121.23	121.25	9426.0
2019-04-17 04:00:00	NVDA	Stock	4.7075	4.7075	4.7075	4.7075	4000.0
2019-04-17 05:00:00	NVDA	Stock	4.7182	4.725	4.715	4.725	61960.0
2019-04-17 06:00:00	NVDA	Stock	4.725	4.732	4.7238	4.7292	81600.0
2019-04-17 07:00:00	NVDA	Stock	4.7292	4.7362	4.715	4.7312	458960.0
2019-04-17 08:00:00	NVDA	Stock	4.7255	4.7475	4.7138	4.7305	1697800.0
2019-04-17 09:00:00	NVDA	Stock	4.7295	4.7615	4.7002	4.7038	64583200.0
2019-04-17 10:00:00	NVDA	Stock	4.7038	4.7326	4.6763	4.7092	57699720.0
2019-04-17 11:00:00	NVDA	Stock	4.7098	4.718	4.672	4.6832	39380960.0
2019-04-17 12:00:00	NVDA	Stock	4.6825	4.7075	4.674	4.7026	25382160.0
2019-04-17 13:00:00	NVDA	Stock	4.7032	4.7163	4.7018	4.7055	19244880.0
2019-04-17 14:00:00	NVDA	Stock	4.7045	4.7114	4.6598	4.685	28127280.0
2019-04-17 15:00:00	NVDA	Stock	4.686	4.6958	4.675	4.6818	36134960.0
2019-04-17 16:00:00	NVDA	Stock	4.6822	4.6825	4.67	4.6775	9017160.0
2019-04-17 17:00:00	NVDA	Stock	4.675	4.6775	4.67	4.67	176360.0
2019-04-17 18:00:00	NVDA	Stock	4.67	4.6775	4.667	4.6675	382560.0
2019-04-17 19:00:00	NVDA	Stock	4.6775	4.6775	4.665	4.665	124400.0
2019-04-17 04:00:00	AMZN	Stock	93.35	93.35	93.35	93.35	2000.0
2019-04-17 06:00:00	AMZN	Stock	93.35	93.35	93.35	93.35	2000.0
2019-04-17 07:00:00	AMZN	Stock	93.3445	93.475	93.315	93.43	166460.0
2019-04-17 08:00:00	AMZN	Stock	93.3494	93.707	92.9195	93.675	269240.0

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

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