PREVIEW / stock_1hour / 2018-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-07-20.parquet
  size:    1.1 MB
  rows:    48,401
  symbols: 2,781

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-07-20 04:00:00	AAPL	Stock	48.1225	48.125	48.0725	48.0725	9016.0
2018-07-20 05:00:00	AAPL	Stock	48.075	48.1225	48.075	48.1225	5584.0
2018-07-20 06:00:00	AAPL	Stock	48.015	48.09	47.78	47.975	43696.0
2018-07-20 07:00:00	AAPL	Stock	47.99	48.025	47.8925	47.95	78656.0
2018-07-20 08:00:00	AAPL	Stock	47.995	48.025	47.8775	47.9	297092.0
2018-07-20 09:00:00	AAPL	Stock	47.9125	48.075	47.8925	48.015	10998688.0
2018-07-20 10:00:00	AAPL	Stock	48.015	48.1075	47.97	48.0375	6652504.0
2018-07-20 11:00:00	AAPL	Stock	48.0375	48.083	47.97	48.0125	4580988.0
2018-07-20 12:00:00	AAPL	Stock	48.0125	48.025	47.9025	47.97	6135324.0
2018-07-20 13:00:00	AAPL	Stock	47.9675	48.0112	47.9138	47.95	3066652.0
2018-07-20 14:00:00	AAPL	Stock	47.95	47.965	47.8175	47.8575	4344360.0
2018-07-20 15:00:00	AAPL	Stock	47.855	47.995	47.5425	47.9175	18011712.0
2018-07-20 16:00:00	AAPL	Stock	47.9175	47.9175	47.6925	47.81	16693752.0
2018-07-20 17:00:00	AAPL	Stock	47.86	47.86	47.8075	47.84	1072764.0
2018-07-20 18:00:00	AAPL	Stock	47.84	47.845	47.815	47.8175	30604.0
2018-07-20 19:00:00	AAPL	Stock	47.8225	47.85	47.82	47.8325	15564.0
2018-07-20 04:00:00	MSFT	Stock	107.99	108.5	107.81	108.31	16172.0
2018-07-20 05:00:00	MSFT	Stock	108.31	108.93	108.31	108.43	12297.0
2018-07-20 06:00:00	MSFT	Stock	108.5	108.5	107.6	108.25	29761.0
2018-07-20 07:00:00	MSFT	Stock	108.24	108.34	107.62	107.81	177318.0
2018-07-20 08:00:00	MSFT	Stock	107.9	108.35	107.5	107.98	533449.0
2018-07-20 09:00:00	MSFT	Stock	107.95	108.2	106.7	107.22	13477921.0
2018-07-20 10:00:00	MSFT	Stock	107.22	107.47	106.72	107.3	9290217.0
2018-07-20 11:00:00	MSFT	Stock	107.3	107.56	106.95	107.2	4990501.0
2018-07-20 12:00:00	MSFT	Stock	107.195	107.196	106.42	106.835	7986655.0
2018-07-20 13:00:00	MSFT	Stock	106.84	107.05	106.605	106.845	2771162.0
2018-07-20 14:00:00	MSFT	Stock	106.84	106.915	106.25	106.5	2520227.0
2018-07-20 15:00:00	MSFT	Stock	106.495	106.55	106.08	106.28	6045303.0
2018-07-20 16:00:00	MSFT	Stock	106.27	106.36	106.15	106.15	4391478.0
2018-07-20 17:00:00	MSFT	Stock	106.18	106.27	106.16	106.2	456360.0
2018-07-20 18:00:00	MSFT	Stock	106.25	106.27	106.15	106.25	15895.0
2018-07-20 19:00:00	MSFT	Stock	106.25	106.27	106.14	106.15	6140.0
2018-07-20 05:00:00	NVDA	Stock	6.3258	6.3258	6.3258	6.3258	8800.0
2018-07-20 06:00:00	NVDA	Stock	6.3162	6.3162	6.297	6.3	22000.0
2018-07-20 07:00:00	NVDA	Stock	6.3075	6.3162	6.2938	6.3	140440.0
2018-07-20 08:00:00	NVDA	Stock	6.3	6.325	6.2862	6.2935	440200.0
2018-07-20 09:00:00	NVDA	Stock	6.2913	6.3375	6.275	6.3244	40185040.0
2018-07-20 10:00:00	NVDA	Stock	6.326	6.3338	6.308	6.3229	27180400.0
2018-07-20 11:00:00	NVDA	Stock	6.3233	6.3328	6.3115	6.3222	20342480.0
2018-07-20 12:00:00	NVDA	Stock	6.322	6.3228	6.291	6.303	20070120.0
2018-07-20 13:00:00	NVDA	Stock	6.3026	6.3078	6.2878	6.301	17152680.0
2018-07-20 14:00:00	NVDA	Stock	6.3002	6.3042	6.2708	6.2842	17217720.0
2018-07-20 15:00:00	NVDA	Stock	6.2835	6.2878	6.2613	6.2722	38681960.0
2018-07-20 16:00:00	NVDA	Stock	6.2722	6.2808	6.2598	6.2698	17984720.0
2018-07-20 17:00:00	NVDA	Stock	6.2722	6.2722	6.2655	6.2712	1334320.0
2018-07-20 18:00:00	NVDA	Stock	6.2722	6.2722	6.2722	6.2722	8800.0
2018-07-20 19:00:00	NVDA	Stock	6.2662	6.2725	6.2653	6.2725	76600.0
2018-07-20 04:00:00	AMZN	Stock	91.2645	91.3885	91.2645	91.3885	12240.0
2018-07-20 05:00:00	AMZN	Stock	91.5395	91.5395	91.5395	91.5395	2000.0
2018-07-20 06:00:00	AMZN	Stock	91.3	91.399	91.225	91.3395	16000.0

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

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