PREVIEW / stock_1hour / 2018-01-19

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-01-19.parquet
  size:    1.1 MB
  rows:    49,816
  symbols: 2,901

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-01-19 04:00:00	AAPL	Stock	44.725	44.9425	44.725	44.9425	12976.0
2018-01-19 05:00:00	AAPL	Stock	44.8875	44.8875	44.88	44.88	3800.0
2018-01-19 06:00:00	AAPL	Stock	44.88	44.88	44.815	44.8225	55824.0
2018-01-19 07:00:00	AAPL	Stock	44.815	44.84	44.75	44.8125	138812.0
2018-01-19 08:00:00	AAPL	Stock	44.825	44.85	44.685	44.7125	350556.0
2018-01-19 09:00:00	AAPL	Stock	44.725	44.895	44.5625	44.6875	23431324.0
2018-01-19 10:00:00	AAPL	Stock	44.6875	44.69	44.3925	44.46	16212956.0
2018-01-19 11:00:00	AAPL	Stock	44.4575	44.6525	44.3525	44.5108	12057980.0
2018-01-19 12:00:00	AAPL	Stock	44.5075	44.662	44.5035	44.61	6342304.0
2018-01-19 13:00:00	AAPL	Stock	44.6125	44.6718	44.575	44.5825	5277680.0
2018-01-19 14:00:00	AAPL	Stock	44.5825	44.645	44.5625	44.6115	6138376.0
2018-01-19 15:00:00	AAPL	Stock	44.6125	44.65	44.49	44.6125	17122480.0
2018-01-19 16:00:00	AAPL	Stock	44.615	44.655	44.5585	44.64	26672764.0
2018-01-19 17:00:00	AAPL	Stock	44.6275	44.6525	44.615	44.6525	702284.0
2018-01-19 18:00:00	AAPL	Stock	44.6325	44.66	44.6325	44.66	14184.0
2018-01-19 19:00:00	AAPL	Stock	44.6625	44.675	44.65	44.67	69068.0
2018-01-19 04:00:00	MSFT	Stock	90.23	90.23	90.23	90.23	216.0
2018-01-19 05:00:00	MSFT	Stock	90.55	90.55	90.55	90.55	100.0
2018-01-19 06:00:00	MSFT	Stock	90.55	90.68	90.55	90.56	732.0
2018-01-19 07:00:00	MSFT	Stock	90.55	90.61	90.43	90.43	5989.0
2018-01-19 08:00:00	MSFT	Stock	90.6	90.74	90.3	90.44	16929.0
2018-01-19 09:00:00	MSFT	Stock	90.34	90.61	89.98	90.0	6173635.0
2018-01-19 10:00:00	MSFT	Stock	90.005	90.26	89.66	89.945	3037952.0
2018-01-19 11:00:00	MSFT	Stock	89.94	90.04	89.8	89.845	1666106.0
2018-01-19 12:00:00	MSFT	Stock	89.85	90.0	89.8	89.9	1296079.0
2018-01-19 13:00:00	MSFT	Stock	89.895	89.94	89.8	89.84	1031351.0
2018-01-19 14:00:00	MSFT	Stock	89.845	90.04	89.83	89.89	2168880.0
2018-01-19 15:00:00	MSFT	Stock	89.89	90.35	89.825	90.0	6591311.0
2018-01-19 16:00:00	MSFT	Stock	90.0	90.05	89.93	89.98	11067462.0
2018-01-19 17:00:00	MSFT	Stock	89.98	89.98	89.91	89.91	6648.0
2018-01-19 18:00:00	MSFT	Stock	89.98	90.0	89.97	89.97	633229.0
2018-01-19 19:00:00	MSFT	Stock	89.98	89.98	89.92	89.97	3275.0
2018-01-19 04:00:00	NVDA	Stock	5.6532	5.7188	5.6532	5.7125	404080.0
2018-01-19 05:00:00	NVDA	Stock	5.715	5.7195	5.7125	5.7195	99360.0
2018-01-19 06:00:00	NVDA	Stock	5.7155	5.7312	5.7063	5.7312	263840.0
2018-01-19 07:00:00	NVDA	Stock	5.7248	5.7248	5.6713	5.6713	4874200.0
2018-01-19 08:00:00	NVDA	Stock	5.7218	5.7238	5.67	5.6868	4694480.0
2018-01-19 09:00:00	NVDA	Stock	5.686	5.7428	5.675	5.7033	137377000.0
2018-01-19 10:00:00	NVDA	Stock	5.7065	5.7362	5.6903	5.7163	86869880.0
2018-01-19 11:00:00	NVDA	Stock	5.718	5.7773	5.7142	5.7563	107366360.0
2018-01-19 12:00:00	NVDA	Stock	5.7563	5.7763	5.7432	5.7485	52711720.0
2018-01-19 13:00:00	NVDA	Stock	5.7488	5.7555	5.73	5.7438	42146280.0
2018-01-19 14:00:00	NVDA	Stock	5.7427	5.7525	5.7315	5.7424	36817080.0
2018-01-19 15:00:00	NVDA	Stock	5.7428	5.7588	5.7385	5.752	68353880.0
2018-01-19 16:00:00	NVDA	Stock	5.7528	5.756	5.725	5.747	10427480.0
2018-01-19 17:00:00	NVDA	Stock	5.7498	5.7588	5.747	5.7513	645600.0
2018-01-19 18:00:00	NVDA	Stock	5.753	5.7625	5.7518	5.762	1145800.0
2018-01-19 19:00:00	NVDA	Stock	5.7575	5.7615	5.7563	5.7615	158080.0
2018-01-19 04:00:00	AMZN	Stock	64.885	65.1	64.885	65.1	26380.0
2018-01-19 05:00:00	AMZN	Stock	65.087	65.087	65.018	65.018	13000.0

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

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