PREVIEW / stock_1hour / 2018-10-24

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-24.parquet
  size:    1.1 MB
  rows:    50,022
  symbols: 2,777

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-10-24 04:00:00	AAPL	Stock	55.2575	55.49	55.13	55.1625	27700.0
2018-10-24 05:00:00	AAPL	Stock	55.055	55.25	55.055	55.225	12644.0
2018-10-24 06:00:00	AAPL	Stock	55.325	55.395	55.2625	55.395	47252.0
2018-10-24 07:00:00	AAPL	Stock	55.3975	55.8075	55.375	55.8	413184.0
2018-10-24 08:00:00	AAPL	Stock	55.7	55.82	55.375	55.79	586360.0
2018-10-24 09:00:00	AAPL	Stock	55.775	56.0575	55.28	55.4875	19960960.0
2018-10-24 10:00:00	AAPL	Stock	55.495	55.575	55.1275	55.135	16326684.0
2018-10-24 11:00:00	AAPL	Stock	55.1375	55.4175	54.73	55.385	17199720.0
2018-10-24 12:00:00	AAPL	Stock	55.3825	55.415	55.035	55.3275	9504496.0
2018-10-24 13:00:00	AAPL	Stock	55.3125	55.32	54.6875	54.785	13372060.0
2018-10-24 14:00:00	AAPL	Stock	54.7802	55.22	54.6475	54.9	12864504.0
2018-10-24 15:00:00	AAPL	Stock	54.9125	54.915	53.635	53.77	31115984.0
2018-10-24 16:00:00	AAPL	Stock	53.7775	54.3	53.735	54.255	12634072.0
2018-10-24 17:00:00	AAPL	Stock	54.25	54.2875	53.7725	54.25	258200.0
2018-10-24 18:00:00	AAPL	Stock	54.2325	54.25	54.075	54.2125	175464.0
2018-10-24 19:00:00	AAPL	Stock	54.215	54.245	54.0	54.245	182420.0
2018-10-24 04:00:00	MSFT	Stock	107.9	107.9	107.0	107.0	4668.0
2018-10-24 05:00:00	MSFT	Stock	107.31	107.46	107.26	107.46	1650.0
2018-10-24 06:00:00	MSFT	Stock	107.41	107.67	107.32	107.67	1092.0
2018-10-24 07:00:00	MSFT	Stock	107.73	108.9	107.72	108.85	38951.0
2018-10-24 08:00:00	MSFT	Stock	108.63	108.96	107.75	108.8	103748.0
2018-10-24 09:00:00	MSFT	Stock	108.75	108.858	106.76	106.995	3776637.0
2018-10-24 10:00:00	MSFT	Stock	106.99	107.55	106.272	106.62	5650821.0
2018-10-24 11:00:00	MSFT	Stock	106.63	106.83	104.815	106.055	7423312.0
2018-10-24 12:00:00	MSFT	Stock	106.05	106.23	105.32	105.94	3991244.0
2018-10-24 13:00:00	MSFT	Stock	105.95	105.99	104.34	104.54	4981689.0
2018-10-24 14:00:00	MSFT	Stock	104.54	105.31	103.94	104.82	6553344.0
2018-10-24 15:00:00	MSFT	Stock	104.815	104.88	101.59	102.38	14363545.0
2018-10-24 16:00:00	MSFT	Stock	102.32	107.24	98.58	106.0	7400442.0
2018-10-24 17:00:00	MSFT	Stock	106.0	106.88	105.0	106.78	331453.0
2018-10-24 18:00:00	MSFT	Stock	106.61	106.61	104.06	104.5	320290.0
2018-10-24 19:00:00	MSFT	Stock	104.5	104.65	103.78	104.4	98145.0
2018-10-24 04:00:00	NVDA	Stock	5.433	5.445	5.433	5.445	21680.0
2018-10-24 05:00:00	NVDA	Stock	5.445	5.4492	5.4333	5.4492	67840.0
2018-10-24 06:00:00	NVDA	Stock	5.45	5.45	5.4425	5.4425	41640.0
2018-10-24 07:00:00	NVDA	Stock	5.462	5.5148	5.4565	5.504	1278840.0
2018-10-24 08:00:00	NVDA	Stock	5.45	5.5242	5.45	5.521	1374800.0
2018-10-24 09:00:00	NVDA	Stock	5.521	5.5348	5.4092	5.4163	74312160.0
2018-10-24 10:00:00	NVDA	Stock	5.4195	5.4195	5.294	5.3358	125814640.0
2018-10-24 11:00:00	NVDA	Stock	5.3358	5.3505	5.2193	5.3355	131401200.0
2018-10-24 12:00:00	NVDA	Stock	5.3355	5.3575	5.2775	5.31	61536880.0
2018-10-24 13:00:00	NVDA	Stock	5.31	5.3115	5.2288	5.2315	50269080.0
2018-10-24 14:00:00	NVDA	Stock	5.2288	5.2498	5.165	5.1768	65572520.0
2018-10-24 15:00:00	NVDA	Stock	5.178	5.18	4.9713	4.983	187838560.0
2018-10-24 16:00:00	NVDA	Stock	4.9853	5.0738	4.7878	4.8125	43576280.0
2018-10-24 17:00:00	NVDA	Stock	4.8002	4.8838	4.794	4.8435	11405840.0
2018-10-24 18:00:00	NVDA	Stock	4.8392	4.8512	4.825	4.85	1776080.0
2018-10-24 19:00:00	NVDA	Stock	4.85	4.885	4.8025	4.8075	1526600.0
2018-10-24 04:00:00	AMZN	Stock	88.0	88.0165	87.7	87.75	27120.0
2018-10-24 05:00:00	AMZN	Stock	87.6625	87.8495	87.6625	87.8495	9700.0

> showing 50 of 50,022 rows — these rows as CSV

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