PREVIEW / stock_1hour / 2016-03-01

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-03-01.parquet
  size:    1.0 MB
  rows:    48,690
  symbols: 3,368

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
2016-03-01 04:00:00	AAPL	Stock	24.16	24.385	24.16	24.385	10904.0
2016-03-01 05:00:00	AAPL	Stock	24.41	24.4325	24.41	24.4325	800.0
2016-03-01 06:00:00	AAPL	Stock	24.4125	24.435	24.4125	24.42	6536.0
2016-03-01 07:00:00	AAPL	Stock	24.445	24.4625	24.37	24.38	98804.0
2016-03-01 08:00:00	AAPL	Stock	24.385	24.4425	24.325	24.385	414836.0
2016-03-01 09:00:00	AAPL	Stock	24.4	24.5125	24.1725	24.49	18627372.0
2016-03-01 10:00:00	AAPL	Stock	24.49	24.7013	24.485	24.6767	27470768.0
2016-03-01 11:00:00	AAPL	Stock	24.6775	25.0	24.6762	24.9775	30423788.0
2016-03-01 12:00:00	AAPL	Stock	24.9762	25.075	24.935	25.065	28718384.0
2016-03-01 13:00:00	AAPL	Stock	25.0655	25.1725	24.9845	25.0675	25544624.0
2016-03-01 14:00:00	AAPL	Stock	25.0662	25.1775	25.0625	25.171	18079276.0
2016-03-01 15:00:00	AAPL	Stock	25.1725	25.1925	25.0588	25.1325	29410844.0
2016-03-01 16:00:00	AAPL	Stock	25.1325	25.1725	24.1725	25.1575	7702324.0
2016-03-01 17:00:00	AAPL	Stock	25.1575	25.1725	25.1525	25.1525	99116.0
2016-03-01 18:00:00	AAPL	Stock	25.1525	25.1675	25.15	25.1575	76488.0
2016-03-01 19:00:00	AAPL	Stock	25.1575	25.1625	25.1275	25.1625	109468.0
2016-03-01 05:00:00	MSFT	Stock	51.25	51.25	51.25	51.25	575.0
2016-03-01 06:00:00	MSFT	Stock	51.29	51.3	51.2	51.2	2183.0
2016-03-01 07:00:00	MSFT	Stock	51.22	51.24	51.17	51.18	9122.0
2016-03-01 08:00:00	MSFT	Stock	51.1	51.3	50.88	51.1	11639.0
2016-03-01 09:00:00	MSFT	Stock	51.13	51.2	50.88	51.17	2961184.0
2016-03-01 10:00:00	MSFT	Stock	51.17	51.61	51.13	51.495	5403686.0
2016-03-01 11:00:00	MSFT	Stock	51.5	52.17	51.38	52.078	5303339.0
2016-03-01 12:00:00	MSFT	Stock	52.075	52.36	52.02	52.36	2805151.0
2016-03-01 13:00:00	MSFT	Stock	52.35	52.58	52.199	52.475	2790011.0
2016-03-01 14:00:00	MSFT	Stock	52.48	52.52	52.17	52.385	2731507.0
2016-03-01 15:00:00	MSFT	Stock	52.38	52.59	52.2	52.58	5866377.0
2016-03-01 16:00:00	MSFT	Stock	52.58	52.6	52.52	52.54	2487933.0
2016-03-01 17:00:00	MSFT	Stock	52.57	52.6	52.54	52.56	2120.0
2016-03-01 18:00:00	MSFT	Stock	52.54	52.59	52.52	52.58	3820.0
2016-03-01 19:00:00	MSFT	Stock	52.52	52.58	52.52	52.58	2080.0
2016-03-01 08:00:00	NVDA	Stock	0.7918	0.7972	0.7918	0.7963	52520.0
2016-03-01 09:00:00	NVDA	Stock	0.7862	0.7972	0.7848	0.7963	28544960.0
2016-03-01 10:00:00	NVDA	Stock	0.7965	0.806	0.7965	0.8036	64962200.0
2016-03-01 11:00:00	NVDA	Stock	0.8038	0.809	0.8035	0.8058	34129920.0
2016-03-01 12:00:00	NVDA	Stock	0.8058	0.8118	0.8055	0.8113	34998720.0
2016-03-01 13:00:00	NVDA	Stock	0.8113	0.8148	0.8105	0.8128	35890680.0
2016-03-01 14:00:00	NVDA	Stock	0.8128	0.8165	0.8118	0.8162	47240960.0
2016-03-01 15:00:00	NVDA	Stock	0.8162	0.8188	0.815	0.8188	72912560.0
2016-03-01 16:00:00	NVDA	Stock	0.8188	0.8188	0.784	0.8094	1905000.0
2016-03-01 17:00:00	NVDA	Stock	0.8205	0.8205	0.8205	0.8205	4000.0
2016-03-01 18:00:00	NVDA	Stock	0.8205	0.8205	0.811	0.8135	40000.0
2016-03-01 19:00:00	NVDA	Stock	0.8205	0.8205	0.8205	0.8205	56000.0
2016-03-01 07:00:00	AMZN	Stock	27.9	27.9575	27.8775	27.9255	51480.0
2016-03-01 08:00:00	AMZN	Stock	27.9125	27.975	27.85	27.85	140920.0
2016-03-01 09:00:00	AMZN	Stock	27.9	28.1135	27.8	28.0424	9213940.0
2016-03-01 10:00:00	AMZN	Stock	28.0455	28.439	28.036	28.291	14235900.0
2016-03-01 11:00:00	AMZN	Stock	28.306	28.57	28.263	28.5545	9970400.0
2016-03-01 12:00:00	AMZN	Stock	28.5535	28.681	28.4875	28.59	9345900.0
2016-03-01 13:00:00	AMZN	Stock	28.59	28.7025	28.4915	28.646	10659860.0

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

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