PREVIEW / stock_1hour / 2018-01-22

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-22.parquet
  size:    1.1 MB
  rows:    49,628
  symbols: 2,881

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-01-22 04:00:00	AAPL	Stock	44.4725	44.48	44.25	44.25	27124.0
2018-01-22 05:00:00	AAPL	Stock	44.235	44.25	44.225	44.225	10052.0
2018-01-22 06:00:00	AAPL	Stock	44.225	44.32	44.225	44.25	44308.0
2018-01-22 07:00:00	AAPL	Stock	44.2425	44.3	44.2125	44.285	156664.0
2018-01-22 08:00:00	AAPL	Stock	44.2775	44.4	44.225	44.3525	532040.0
2018-01-22 09:00:00	AAPL	Stock	44.3525	44.445	44.1505	44.34	14949592.0
2018-01-22 10:00:00	AAPL	Stock	44.3375	44.36	44.22	44.25	13383800.0
2018-01-22 11:00:00	AAPL	Stock	44.2512	44.31	44.21	44.284	9479504.0
2018-01-22 12:00:00	AAPL	Stock	44.2825	44.37	44.2725	44.335	8950340.0
2018-01-22 13:00:00	AAPL	Stock	44.3345	44.4175	44.33	44.3612	6643512.0
2018-01-22 14:00:00	AAPL	Stock	44.362	44.3725	44.205	44.25	8949900.0
2018-01-22 15:00:00	AAPL	Stock	44.25	44.275	44.175	44.2525	17031632.0
2018-01-22 16:00:00	AAPL	Stock	44.25	44.3075	44.2025	44.2875	15884300.0
2018-01-22 17:00:00	AAPL	Stock	44.2875	44.325	44.2775	44.315	230108.0
2018-01-22 18:00:00	AAPL	Stock	44.315	44.3375	44.315	44.335	67520.0
2018-01-22 19:00:00	AAPL	Stock	44.325	44.35	44.325	44.3375	36680.0
2018-01-22 04:00:00	MSFT	Stock	89.91	89.91	89.76	89.76	200.0
2018-01-22 06:00:00	MSFT	Stock	89.94	89.94	89.94	89.94	408.0
2018-01-22 07:00:00	MSFT	Stock	89.9	89.97	89.79	89.85	2185.0
2018-01-22 08:00:00	MSFT	Stock	89.9	89.96	89.85	89.96	3382.0
2018-01-22 09:00:00	MSFT	Stock	89.85	90.44	89.74	90.422	1905794.0
2018-01-22 10:00:00	MSFT	Stock	90.42	91.23	90.37	90.85	2963729.0
2018-01-22 11:00:00	MSFT	Stock	90.855	91.23	90.82	91.2	1732054.0
2018-01-22 12:00:00	MSFT	Stock	91.2	91.23	91.01	91.095	2200391.0
2018-01-22 13:00:00	MSFT	Stock	91.1	91.12	90.97	91.04	1914914.0
2018-01-22 14:00:00	MSFT	Stock	91.047	91.165	90.98	91.02	1507717.0
2018-01-22 15:00:00	MSFT	Stock	91.025	91.62	91.01	91.61	3346594.0
2018-01-22 16:00:00	MSFT	Stock	91.61	92.2	91.12	91.9	6032147.0
2018-01-22 17:00:00	MSFT	Stock	91.9	91.96	91.61	91.96	81782.0
2018-01-22 18:00:00	MSFT	Stock	91.95	91.98	91.85	91.98	5149.0
2018-01-22 19:00:00	MSFT	Stock	91.95	91.99	91.95	91.96	4488.0
2018-01-22 04:00:00	NVDA	Stock	5.7525	5.7563	5.7525	5.7563	26760.0
2018-01-22 05:00:00	NVDA	Stock	5.7625	5.772	5.7625	5.77	196800.0
2018-01-22 06:00:00	NVDA	Stock	5.7638	5.7688	5.7625	5.7625	80520.0
2018-01-22 07:00:00	NVDA	Stock	5.7625	5.7685	5.7588	5.7588	196560.0
2018-01-22 08:00:00	NVDA	Stock	5.7625	5.7695	5.7513	5.755	1176040.0
2018-01-22 09:00:00	NVDA	Stock	5.755	5.7653	5.7025	5.7201	78969800.0
2018-01-22 10:00:00	NVDA	Stock	5.7196	5.8158	5.7163	5.7939	95212720.0
2018-01-22 11:00:00	NVDA	Stock	5.7939	5.8198	5.7928	5.8178	42779680.0
2018-01-22 12:00:00	NVDA	Stock	5.8165	5.8268	5.8062	5.8185	36997640.0
2018-01-22 13:00:00	NVDA	Stock	5.8192	5.8335	5.8115	5.8333	28384560.0
2018-01-22 14:00:00	NVDA	Stock	5.8325	5.8378	5.822	5.825	24834960.0
2018-01-22 15:00:00	NVDA	Stock	5.826	5.844	5.8128	5.8418	47845160.0
2018-01-22 16:00:00	NVDA	Stock	5.8422	5.8988	5.8375	5.8875	174379880.0
2018-01-22 17:00:00	NVDA	Stock	5.8858	5.8923	5.8813	5.885	686120.0
2018-01-22 18:00:00	NVDA	Stock	5.8838	5.8875	5.8752	5.8863	371960.0
2018-01-22 19:00:00	NVDA	Stock	5.8825	5.8923	5.8768	5.8923	220600.0
2018-01-22 07:00:00	AMZN	Stock	64.8	64.856	64.7975	64.8435	17180.0
2018-01-22 08:00:00	AMZN	Stock	64.85	64.8995	64.725	64.7795	246480.0
2018-01-22 09:00:00	AMZN	Stock	64.8	65.107	64.7525	65.023	8700580.0

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

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