PREVIEW / stock_1hour / 2019-08-19

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-08-19.parquet
  size:    1.1 MB
  rows:    50,663
  symbols: 2,561

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-08-19 04:00:00	AAPL	Stock	52.15	52.3725	52.15	52.15	43744.0
2019-08-19 05:00:00	AAPL	Stock	52.2675	52.3075	52.22	52.3075	5400.0
2019-08-19 06:00:00	AAPL	Stock	52.36	52.5825	52.3375	52.4975	51680.0
2019-08-19 07:00:00	AAPL	Stock	52.4275	52.635	52.4125	52.6	269492.0
2019-08-19 08:00:00	AAPL	Stock	52.48	52.7125	52.4425	52.6375	581932.0
2019-08-19 09:00:00	AAPL	Stock	52.675	53.1828	52.5062	53.0275	21581584.0
2019-08-19 10:00:00	AAPL	Stock	53.025	53.0598	52.78	52.985	13812704.0
2019-08-19 11:00:00	AAPL	Stock	52.9842	53.045	52.895	52.935	8424376.0
2019-08-19 12:00:00	AAPL	Stock	52.935	52.985	52.845	52.98	6433220.0
2019-08-19 13:00:00	AAPL	Stock	52.9788	53.03	52.94	52.9625	5620496.0
2019-08-19 14:00:00	AAPL	Stock	52.9625	52.97	52.725	52.7685	6711000.0
2019-08-19 15:00:00	AAPL	Stock	52.7725	52.84	52.5325	52.585	12720684.0
2019-08-19 16:00:00	AAPL	Stock	52.5875	52.6225	52.3775	52.6125	8829856.0
2019-08-19 17:00:00	AAPL	Stock	52.5875	52.5875	52.5075	52.515	28380.0
2019-08-19 18:00:00	AAPL	Stock	52.51	52.575	52.5025	52.56	52700.0
2019-08-19 19:00:00	AAPL	Stock	52.575	52.6	52.5125	52.525	32200.0
2019-08-19 04:00:00	MSFT	Stock	137.62	137.69	136.62	136.84	5637.0
2019-08-19 05:00:00	MSFT	Stock	137.1	137.5	137.1	137.5	3606.0
2019-08-19 06:00:00	MSFT	Stock	137.59	137.9	137.37	137.8	3009.0
2019-08-19 07:00:00	MSFT	Stock	137.68	138.0	137.55	137.8	19131.0
2019-08-19 08:00:00	MSFT	Stock	137.875	138.0	137.56	137.79	66595.0
2019-08-19 09:00:00	MSFT	Stock	137.78	138.262	137.44	137.647	2865726.0
2019-08-19 10:00:00	MSFT	Stock	137.65	137.86	136.885	137.7	2628762.0
2019-08-19 11:00:00	MSFT	Stock	137.7	137.99	137.68	137.82	1874754.0
2019-08-19 12:00:00	MSFT	Stock	137.81	138.165	137.64	138.09	2159593.0
2019-08-19 13:00:00	MSFT	Stock	138.09	138.5	138.07	138.335	2478510.0
2019-08-19 14:00:00	MSFT	Stock	138.34	138.35	137.873	138.19	1632323.0
2019-08-19 15:00:00	MSFT	Stock	138.2	138.55	138.045	138.41	3383842.0
2019-08-19 16:00:00	MSFT	Stock	138.41	138.42	138.25	138.25	3971804.0
2019-08-19 17:00:00	MSFT	Stock	138.28	138.37	138.17	138.37	5670.0
2019-08-19 18:00:00	MSFT	Stock	138.25	138.36	138.2	138.21	3709.0
2019-08-19 19:00:00	MSFT	Stock	138.3	138.32	138.08	138.09	9935.0
2019-08-19 04:00:00	NVDA	Stock	4.034	4.0748	4.034	4.05	132840.0
2019-08-19 05:00:00	NVDA	Stock	4.06	4.0662	4.06	4.0662	27920.0
2019-08-19 06:00:00	NVDA	Stock	4.0688	4.075	4.0638	4.075	188040.0
2019-08-19 07:00:00	NVDA	Stock	4.072	4.1238	4.0552	4.1128	2669920.0
2019-08-19 08:00:00	NVDA	Stock	4.07	4.125	4.0562	4.1128	5346360.0
2019-08-19 09:00:00	NVDA	Stock	4.1138	4.2072	4.0868	4.1977	165931040.0
2019-08-19 10:00:00	NVDA	Stock	4.1995	4.2208	4.17	4.2163	139674960.0
2019-08-19 11:00:00	NVDA	Stock	4.2163	4.2352	4.208	4.2255	104694640.0
2019-08-19 12:00:00	NVDA	Stock	4.2252	4.2422	4.2102	4.2405	68749640.0
2019-08-19 13:00:00	NVDA	Stock	4.2402	4.252	4.2352	4.2462	61864720.0
2019-08-19 14:00:00	NVDA	Stock	4.246	4.2618	4.2344	4.237	71369200.0
2019-08-19 15:00:00	NVDA	Stock	4.2373	4.2855	4.228	4.2693	142171360.0
2019-08-19 16:00:00	NVDA	Stock	4.2695	4.28	4.265	4.2745	14740880.0
2019-08-19 17:00:00	NVDA	Stock	4.2758	4.281	4.273	4.275	428600.0
2019-08-19 18:00:00	NVDA	Stock	4.275	4.293	4.275	4.2883	649440.0
2019-08-19 19:00:00	NVDA	Stock	4.2925	4.2962	4.2868	4.29	611480.0
2019-08-19 04:00:00	AMZN	Stock	90.45	90.6045	90.45	90.6045	6980.0
2019-08-19 07:00:00	AMZN	Stock	90.7345	90.85	90.6465	90.8395	90260.0

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

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