PREVIEW / stock_1hour / 2018-04-10

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-04-10.parquet
  size:    1.1 MB
  rows:    49,447
  symbols: 2,868

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-04-10 04:00:00	AAPL	Stock	43.0575	43.2625	43.0575	43.1875	22708.0
2018-04-10 05:00:00	AAPL	Stock	43.15	43.3	43.15	43.175	42600.0
2018-04-10 06:00:00	AAPL	Stock	43.18	43.2625	43.18	43.2375	5788.0
2018-04-10 07:00:00	AAPL	Stock	43.2	43.25	43.165	43.225	219560.0
2018-04-10 08:00:00	AAPL	Stock	43.25	43.25	43.1	43.165	431112.0
2018-04-10 09:00:00	AAPL	Stock	43.165	43.3775	42.98	43.0975	16891484.0
2018-04-10 10:00:00	AAPL	Stock	43.0978	43.3625	43.0788	43.2975	14765832.0
2018-04-10 11:00:00	AAPL	Stock	43.3	43.375	43.1275	43.295	12723664.0
2018-04-10 12:00:00	AAPL	Stock	43.2938	43.3152	42.8825	43.145	11556360.0
2018-04-10 13:00:00	AAPL	Stock	43.145	43.2988	43.0925	43.2948	9234528.0
2018-04-10 14:00:00	AAPL	Stock	43.295	43.3575	43.125	43.3475	11340084.0
2018-04-10 15:00:00	AAPL	Stock	43.3462	43.5	43.2175	43.3125	17905432.0
2018-04-10 16:00:00	AAPL	Stock	43.3125	43.3475	43.24	43.3125	8844868.0
2018-04-10 17:00:00	AAPL	Stock	43.275	43.3177	43.2725	43.28	122040.0
2018-04-10 18:00:00	AAPL	Stock	43.3	43.3125	43.275	43.31	53032.0
2018-04-10 19:00:00	AAPL	Stock	43.2875	43.31	43.225	43.225	77088.0
2018-04-10 04:00:00	MSFT	Stock	92.15	92.5	92.15	92.5	3100.0
2018-04-10 05:00:00	MSFT	Stock	92.61	92.61	92.61	92.61	380.0
2018-04-10 06:00:00	MSFT	Stock	92.4	92.4	92.4	92.4	200.0
2018-04-10 07:00:00	MSFT	Stock	92.3	92.37	92.05	92.3	16234.0
2018-04-10 08:00:00	MSFT	Stock	92.367	92.5	92.05	92.15	57785.0
2018-04-10 09:00:00	MSFT	Stock	92.2	92.97	91.64	91.885	3604546.0
2018-04-10 10:00:00	MSFT	Stock	91.89	92.85	91.86	92.51	2736575.0
2018-04-10 11:00:00	MSFT	Stock	92.51	93.0	92.24	92.535	3002283.0
2018-04-10 12:00:00	MSFT	Stock	92.53	92.68	91.65	92.14	2498827.0
2018-04-10 13:00:00	MSFT	Stock	92.16	92.7	92.02	92.68	1812800.0
2018-04-10 14:00:00	MSFT	Stock	92.695	92.931	92.35	92.93	2380492.0
2018-04-10 15:00:00	MSFT	Stock	92.93	93.28	92.68	92.89	4881848.0
2018-04-10 16:00:00	MSFT	Stock	92.88	92.92	92.586	92.79	3545229.0
2018-04-10 17:00:00	MSFT	Stock	92.76	92.85	92.75	92.85	1000.0
2018-04-10 18:00:00	MSFT	Stock	92.76	92.85	92.76	92.85	900.0
2018-04-10 19:00:00	MSFT	Stock	92.75	92.75	92.69	92.7	5657.0
2018-04-10 04:00:00	NVDA	Stock	5.5788	5.595	5.565	5.591	149600.0
2018-04-10 05:00:00	NVDA	Stock	5.5753	5.6125	5.575	5.6	213000.0
2018-04-10 06:00:00	NVDA	Stock	5.6028	5.6028	5.5888	5.5938	88920.0
2018-04-10 07:00:00	NVDA	Stock	5.5875	5.6	5.5745	5.5938	2105160.0
2018-04-10 08:00:00	NVDA	Stock	5.5788	5.6053	5.5665	5.6	4354720.0
2018-04-10 09:00:00	NVDA	Stock	5.6	5.6722	5.5602	5.5977	150666440.0
2018-04-10 10:00:00	NVDA	Stock	5.5993	5.6938	5.5915	5.6778	127632600.0
2018-04-10 11:00:00	NVDA	Stock	5.6778	5.686	5.6018	5.6368	82596520.0
2018-04-10 12:00:00	NVDA	Stock	5.637	5.6436	5.5813	5.6238	53698560.0
2018-04-10 13:00:00	NVDA	Stock	5.6255	5.6813	5.6158	5.681	48906000.0
2018-04-10 14:00:00	NVDA	Stock	5.6812	5.7025	5.665	5.7016	55494320.0
2018-04-10 15:00:00	NVDA	Stock	5.6995	5.725	5.6838	5.6978	85053000.0
2018-04-10 16:00:00	NVDA	Stock	5.6978	5.7063	5.6534	5.6978	17608280.0
2018-04-10 17:00:00	NVDA	Stock	5.7	5.7188	5.7	5.7188	300360.0
2018-04-10 18:00:00	NVDA	Stock	5.713	5.7248	5.7042	5.7225	546440.0
2018-04-10 19:00:00	NVDA	Stock	5.7248	5.7342	5.7025	5.7063	1329120.0
2018-04-10 04:00:00	AMZN	Stock	71.2455	71.7	71.2455	71.6	38280.0
2018-04-10 05:00:00	AMZN	Stock	71.55	71.55	71.494	71.5085	17220.0

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

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