PREVIEW / stock_1hour / 2018-02-15

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-02-15.parquet
  size:    1.1 MB
  rows:    49,340
  symbols: 2,884

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-02-15 04:00:00	AAPL	Stock	42.4	42.495	42.38	42.4875	43656.0
2018-02-15 05:00:00	AAPL	Stock	42.4875	42.49	42.3825	42.3825	96876.0
2018-02-15 06:00:00	AAPL	Stock	42.3875	42.3925	42.25	42.375	152112.0
2018-02-15 07:00:00	AAPL	Stock	42.3575	42.475	42.245	42.3	585940.0
2018-02-15 08:00:00	AAPL	Stock	42.315	42.47	42.2175	42.35	1088448.0
2018-02-15 09:00:00	AAPL	Stock	42.3525	43.015	42.25	42.84	38639588.0
2018-02-15 10:00:00	AAPL	Stock	42.8425	42.8725	42.406	42.4175	34722020.0
2018-02-15 11:00:00	AAPL	Stock	42.4225	42.92	42.3	42.8375	22667072.0
2018-02-15 12:00:00	AAPL	Stock	42.8325	43.0175	42.76	43.0	14717884.0
2018-02-15 13:00:00	AAPL	Stock	43.0025	43.1925	42.91	42.9975	20063932.0
2018-02-15 14:00:00	AAPL	Stock	42.9975	43.2575	42.9925	43.2125	17195720.0
2018-02-15 15:00:00	AAPL	Stock	43.215	43.2725	43.0825	43.25	26721068.0
2018-02-15 16:00:00	AAPL	Stock	43.2475	43.2975	43.095	43.28	9542260.0
2018-02-15 17:00:00	AAPL	Stock	43.275	43.2875	43.2725	43.2875	119544.0
2018-02-15 18:00:00	AAPL	Stock	43.2875	43.3125	43.2475	43.3	63928.0
2018-02-15 19:00:00	AAPL	Stock	43.3025	43.325	43.285	43.325	82744.0
2018-02-15 04:00:00	MSFT	Stock	91.0	91.25	91.0	91.25	724.0
2018-02-15 05:00:00	MSFT	Stock	91.44	91.44	91.35	91.35	600.0
2018-02-15 06:00:00	MSFT	Stock	91.25	91.25	91.08	91.19	1609.0
2018-02-15 07:00:00	MSFT	Stock	91.29	91.29	91.11	91.25	12072.0
2018-02-15 08:00:00	MSFT	Stock	91.195	91.3	91.1	91.3	20007.0
2018-02-15 09:00:00	MSFT	Stock	91.27	91.91	90.82	91.845	2824131.0
2018-02-15 10:00:00	MSFT	Stock	91.84	92.08	90.85	90.88	4287179.0
2018-02-15 11:00:00	MSFT	Stock	90.89	91.76	90.62	91.7	2762080.0
2018-02-15 12:00:00	MSFT	Stock	91.7	91.965	91.45	91.95	1959259.0
2018-02-15 13:00:00	MSFT	Stock	91.95	92.49	91.95	92.21	2603304.0
2018-02-15 14:00:00	MSFT	Stock	92.21	92.51	92.05	92.15	2239376.0
2018-02-15 15:00:00	MSFT	Stock	92.15	92.72	92.15	92.72	5562459.0
2018-02-15 16:00:00	MSFT	Stock	92.71	92.77	92.58	92.7	3296911.0
2018-02-15 17:00:00	MSFT	Stock	92.66	92.75	92.66	92.75	1352.0
2018-02-15 18:00:00	MSFT	Stock	92.78	92.78	92.7	92.7	1400.0
2018-02-15 19:00:00	MSFT	Stock	92.7	92.8	92.7	92.8	540.0
2018-02-15 04:00:00	NVDA	Stock	6.0838	6.0985	6.0838	6.091	279400.0
2018-02-15 05:00:00	NVDA	Stock	6.0868	6.112	6.0868	6.1002	281720.0
2018-02-15 06:00:00	NVDA	Stock	6.0903	6.1	6.075	6.0925	335880.0
2018-02-15 07:00:00	NVDA	Stock	6.0975	6.1238	6.0748	6.0813	1143000.0
2018-02-15 08:00:00	NVDA	Stock	6.1058	6.111	6.0225	6.0925	3737280.0
2018-02-15 09:00:00	NVDA	Stock	6.0943	6.2093	6.0898	6.2042	123776520.0
2018-02-15 10:00:00	NVDA	Stock	6.203	6.2063	6.0555	6.0646	140535200.0
2018-02-15 11:00:00	NVDA	Stock	6.0602	6.163	6.038	6.1548	94589760.0
2018-02-15 12:00:00	NVDA	Stock	6.156	6.1925	6.1478	6.1702	53510120.0
2018-02-15 13:00:00	NVDA	Stock	6.1713	6.1892	6.1325	6.1438	60620720.0
2018-02-15 14:00:00	NVDA	Stock	6.1465	6.1608	6.1308	6.1318	43403880.0
2018-02-15 15:00:00	NVDA	Stock	6.1318	6.1625	6.1212	6.1625	86421920.0
2018-02-15 16:00:00	NVDA	Stock	6.1625	6.1748	6.144	6.1685	10577440.0
2018-02-15 17:00:00	NVDA	Stock	6.1738	6.1775	6.1675	6.1675	169640.0
2018-02-15 18:00:00	NVDA	Stock	6.167	6.1795	6.167	6.1775	320760.0
2018-02-15 19:00:00	NVDA	Stock	6.175	6.18	6.1725	6.1725	368520.0
2018-02-15 04:00:00	AMZN	Stock	73.35	73.35	73.2	73.315	93020.0
2018-02-15 05:00:00	AMZN	Stock	73.294	73.3945	73.2505	73.278	43760.0

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

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