PREVIEW / stock_1hour / 2015-12-01

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-12-01.parquet
  size:    1.0 MB
  rows:    48,876
  symbols: 3,431

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
2015-12-01 04:00:00	AAPL	Stock	29.72	29.735	29.65	29.6625	22860.0
2015-12-01 05:00:00	AAPL	Stock	29.6625	29.68	29.625	29.68	27736.0
2015-12-01 06:00:00	AAPL	Stock	29.6775	29.7475	29.6775	29.725	57636.0
2015-12-01 07:00:00	AAPL	Stock	29.72	29.745	29.69	29.735	93488.0
2015-12-01 08:00:00	AAPL	Stock	29.72	29.75	29.65	29.6575	351188.0
2015-12-01 09:00:00	AAPL	Stock	29.6575	29.7125	29.5375	29.6625	15552284.0
2015-12-01 10:00:00	AAPL	Stock	29.6625	29.685	29.455	29.57	22394732.0
2015-12-01 11:00:00	AAPL	Stock	29.5725	29.62	29.4925	29.5175	10173172.0
2015-12-01 12:00:00	AAPL	Stock	29.5175	29.583	29.44	29.4588	15823040.0
2015-12-01 13:00:00	AAPL	Stock	29.4575	29.46	29.2825	29.34	16592068.0
2015-12-01 14:00:00	AAPL	Stock	29.34	29.375	29.215	29.286	15658808.0
2015-12-01 15:00:00	AAPL	Stock	29.285	29.345	29.25	29.3225	23938156.0
2015-12-01 16:00:00	AAPL	Stock	29.3308	29.5872	29.3	29.325	10403832.0
2015-12-01 17:00:00	AAPL	Stock	29.325	29.325	29.31	29.3175	44996.0
2015-12-01 18:00:00	AAPL	Stock	29.325	29.325	29.3075	29.3075	23712.0
2015-12-01 19:00:00	AAPL	Stock	29.32	29.32	29.295	29.2975	109548.0
2015-12-01 05:00:00	MSFT	Stock	54.49	54.55	54.49	54.55	2400.0
2015-12-01 06:00:00	MSFT	Stock	54.6	54.61	54.6	54.6	2900.0
2015-12-01 07:00:00	MSFT	Stock	54.57	54.57	54.47	54.55	1542.0
2015-12-01 08:00:00	MSFT	Stock	54.6	54.66	54.57	54.6	31432.0
2015-12-01 09:00:00	MSFT	Stock	54.65	54.65	54.3	54.58	4282600.0
2015-12-01 10:00:00	MSFT	Stock	54.58	55.14	54.35	55.035	6953650.0
2015-12-01 11:00:00	MSFT	Stock	55.04	55.1	54.72	54.825	5294009.0
2015-12-01 12:00:00	MSFT	Stock	54.83	54.9	54.705	54.81	2854093.0
2015-12-01 13:00:00	MSFT	Stock	54.81	54.819	54.64	54.77	3150296.0
2015-12-01 14:00:00	MSFT	Stock	54.77	54.989	54.75	54.94	3390381.0
2015-12-01 15:00:00	MSFT	Stock	54.94	55.23	54.875	55.21	8378428.0
2015-12-01 16:00:00	MSFT	Stock	55.22	55.3	54.875	55.25	3666583.0
2015-12-01 17:00:00	MSFT	Stock	55.23	55.29	55.23	55.29	530.0
2015-12-01 18:00:00	MSFT	Stock	55.23	55.25	55.22	55.25	3606.0
2015-12-01 19:00:00	MSFT	Stock	55.2	55.25	55.2	55.25	7491.0
2015-12-01 04:00:00	NVDA	Stock	0.7975	0.8	0.7975	0.8	24000.0
2015-12-01 08:00:00	NVDA	Stock	0.797	0.8012	0.797	0.8012	295000.0
2015-12-01 09:00:00	NVDA	Stock	0.8012	0.8162	0.7992	0.816	55308320.0
2015-12-01 10:00:00	NVDA	Stock	0.816	0.8172	0.8058	0.8131	84589520.0
2015-12-01 11:00:00	NVDA	Stock	0.8132	0.8152	0.8088	0.8132	60014800.0
2015-12-01 12:00:00	NVDA	Stock	0.8132	0.8138	0.811	0.813	34700520.0
2015-12-01 13:00:00	NVDA	Stock	0.813	0.8139	0.809	0.8138	25322920.0
2015-12-01 14:00:00	NVDA	Stock	0.8135	0.8188	0.8134	0.8172	40078400.0
2015-12-01 15:00:00	NVDA	Stock	0.8172	0.8198	0.8152	0.8188	79359960.0
2015-12-01 16:00:00	NVDA	Stock	0.8187	0.8188	0.8142	0.817	4133000.0
2015-12-01 04:00:00	AMZN	Stock	33.4	33.4245	33.3945	33.3945	17640.0
2015-12-01 05:00:00	AMZN	Stock	33.352	33.3895	33.3495	33.3895	12000.0
2015-12-01 06:00:00	AMZN	Stock	33.3945	33.443	33.3945	33.443	30360.0
2015-12-01 07:00:00	AMZN	Stock	33.45	33.56	33.43	33.55	243760.0
2015-12-01 08:00:00	AMZN	Stock	33.5205	33.595	33.4875	33.575	371180.0
2015-12-01 09:00:00	AMZN	Stock	33.574	33.7	33.4665	33.6205	11654640.0
2015-12-01 10:00:00	AMZN	Stock	33.6015	33.7255	33.393	33.524	14816540.0
2015-12-01 11:00:00	AMZN	Stock	33.539	33.8125	33.47	33.7755	11050280.0
2015-12-01 12:00:00	AMZN	Stock	33.7692	34.05	33.75	34.0	10671200.0

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

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