PREVIEW / stock_1hour / 2015-02-20

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-20.parquet
  size:    1.0 MB
  rows:    48,616
  symbols: 3,506

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-02-20 04:00:00	AAPL	Stock	32.18	32.2075	32.1325	32.2075	14840.0
2015-02-20 05:00:00	AAPL	Stock	32.2125	32.2525	32.2075	32.25	42496.0
2015-02-20 06:00:00	AAPL	Stock	32.2475	32.25	32.2225	32.225	71668.0
2015-02-20 07:00:00	AAPL	Stock	32.225	32.2475	32.175	32.19	183512.0
2015-02-20 08:00:00	AAPL	Stock	32.19	32.25	32.1125	32.2	774720.0
2015-02-20 09:00:00	AAPL	Stock	32.2	32.21	32.0125	32.105	35292760.0
2015-02-20 10:00:00	AAPL	Stock	32.1025	32.205	32.07	32.19	28190708.0
2015-02-20 11:00:00	AAPL	Stock	32.1925	32.22	32.1375	32.162	16345960.0
2015-02-20 12:00:00	AAPL	Stock	32.16	32.165	32.0775	32.1375	15143664.0
2015-02-20 13:00:00	AAPL	Stock	32.14	32.205	32.1275	32.2032	15442720.0
2015-02-20 14:00:00	AAPL	Stock	32.205	32.3237	32.195	32.2988	23674728.0
2015-02-20 15:00:00	AAPL	Stock	32.3	32.375	32.26	32.375	37509992.0
2015-02-20 16:00:00	AAPL	Stock	32.3738	32.3765	32.156	32.3725	11496572.0
2015-02-20 17:00:00	AAPL	Stock	32.3675	32.3725	32.199	32.3675	162052.0
2015-02-20 18:00:00	AAPL	Stock	32.37	32.3738	32.36	32.3653	94196.0
2015-02-20 19:00:00	AAPL	Stock	32.3675	32.3775	32.365	32.3775	111500.0
2015-02-20 07:00:00	MSFT	Stock	43.5	43.5	43.5	43.5	4460.0
2015-02-20 08:00:00	MSFT	Stock	43.59	43.65	43.42	43.49	6260.0
2015-02-20 09:00:00	MSFT	Stock	43.48	43.66	43.29	43.37	7010765.0
2015-02-20 10:00:00	MSFT	Stock	43.37	43.66	43.365	43.62	4372735.0
2015-02-20 11:00:00	MSFT	Stock	43.625	43.7	43.535	43.65	2143505.0
2015-02-20 12:00:00	MSFT	Stock	43.64	43.68	43.56	43.65	2038739.0
2015-02-20 13:00:00	MSFT	Stock	43.646	43.806	43.62	43.79	2070380.0
2015-02-20 14:00:00	MSFT	Stock	43.79	43.83	43.72	43.804	2886882.0
2015-02-20 15:00:00	MSFT	Stock	43.81	43.88	43.78	43.86	5241593.0
2015-02-20 16:00:00	MSFT	Stock	43.855	43.855	43.642	43.82	2638325.0
2015-02-20 17:00:00	MSFT	Stock	43.86	43.86	43.81	43.81	13985.0
2015-02-20 18:00:00	MSFT	Stock	43.81	43.81	43.68	43.68	6186.0
2015-02-20 19:00:00	MSFT	Stock	43.74	43.84	43.74	43.84	1930.0
2015-02-20 08:00:00	NVDA	Stock	0.554	0.5545	0.5508	0.5545	2790760.0
2015-02-20 09:00:00	NVDA	Stock	0.554	0.5542	0.55	0.552	17131040.0
2015-02-20 10:00:00	NVDA	Stock	0.5518	0.5552	0.5508	0.554	20369840.0
2015-02-20 11:00:00	NVDA	Stock	0.5541	0.5548	0.5522	0.553	12609400.0
2015-02-20 12:00:00	NVDA	Stock	0.553	0.554	0.5522	0.5538	11148080.0
2015-02-20 13:00:00	NVDA	Stock	0.554	0.5555	0.5535	0.5552	9326960.0
2015-02-20 14:00:00	NVDA	Stock	0.5552	0.5572	0.5548	0.5572	12973400.0
2015-02-20 15:00:00	NVDA	Stock	0.5572	0.5588	0.5565	0.5582	50624760.0
2015-02-20 16:00:00	NVDA	Stock	0.5584	0.5585	0.5551	0.5585	14134760.0
2015-02-20 17:00:00	NVDA	Stock	0.5585	0.5585	0.5585	0.5585	4000.0
2015-02-20 18:00:00	NVDA	Stock	0.558	0.558	0.557	0.557	60000.0
2015-02-20 06:00:00	AMZN	Stock	18.949	18.949	18.949	18.949	10000.0
2015-02-20 07:00:00	AMZN	Stock	18.949	18.9515	18.925	18.925	32000.0
2015-02-20 08:00:00	AMZN	Stock	18.91	18.915	18.8985	18.9055	52900.0
2015-02-20 09:00:00	AMZN	Stock	18.9	18.984	18.8058	18.8315	9501180.0
2015-02-20 10:00:00	AMZN	Stock	18.8445	18.9325	18.792	18.8745	7819740.0
2015-02-20 11:00:00	AMZN	Stock	18.8795	18.9355	18.866	18.934	5086480.0
2015-02-20 12:00:00	AMZN	Stock	18.9365	19.06	18.932	19.038	8438600.0
2015-02-20 13:00:00	AMZN	Stock	19.0346	19.1385	19.02	19.1222	8155740.0
2015-02-20 14:00:00	AMZN	Stock	19.1235	19.1625	19.1005	19.148	7907000.0
2015-02-20 15:00:00	AMZN	Stock	19.149	19.185	19.1345	19.1825	10823580.0

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

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