PREVIEW / stock_30min / 2016-01-15

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-15.parquet
  size:    1.6 MB
  rows:    86,368
  symbols: 3,403

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-01-15 04:00:00	AAPL	Stock	24.59	24.59	24.4	24.46	2400.0
2016-01-15 04:30:00	AAPL	Stock	24.46	24.485	24.4	24.4	15124.0
2016-01-15 05:00:00	AAPL	Stock	24.3875	24.4375	24.37	24.38	10872.0
2016-01-15 05:30:00	AAPL	Stock	24.35	24.3725	24.2525	24.2975	42760.0
2016-01-15 06:00:00	AAPL	Stock	24.28	24.325	24.25	24.25	82096.0
2016-01-15 06:30:00	AAPL	Stock	24.25	24.3625	24.2375	24.2875	84764.0
2016-01-15 07:00:00	AAPL	Stock	24.325	24.425	24.325	24.4175	129800.0
2016-01-15 07:30:00	AAPL	Stock	24.3775	24.45	24.35	24.4125	234136.0
2016-01-15 08:00:00	AAPL	Stock	24.42	24.4375	24.25	24.365	604120.0
2016-01-15 08:30:00	AAPL	Stock	24.365	24.375	24.0375	24.15	1113868.0
2016-01-15 09:00:00	AAPL	Stock	24.15	24.1825	23.8825	23.98	1939972.0
2016-01-15 09:30:00	AAPL	Stock	24.05	24.375	23.9675	24.249	43849996.0
2016-01-15 10:00:00	AAPL	Stock	24.2505	24.3375	24.1575	24.205	19987172.0
2016-01-15 10:30:00	AAPL	Stock	24.206	24.29	24.005	24.021	16096640.0
2016-01-15 11:00:00	AAPL	Stock	24.018	24.115	23.945	24.1125	21616264.0
2016-01-15 11:30:00	AAPL	Stock	24.115	24.1325	24.0	24.0125	12286496.0
2016-01-15 12:00:00	AAPL	Stock	24.01	24.0625	23.8975	23.955	14258168.0
2016-01-15 12:30:00	AAPL	Stock	23.955	24.165	23.84	24.1425	21558780.0
2016-01-15 13:00:00	AAPL	Stock	24.14	24.3125	24.105	24.2142	19222528.0
2016-01-15 13:30:00	AAPL	Stock	24.21	24.3825	24.15	24.3025	15477948.0
2016-01-15 14:00:00	AAPL	Stock	24.305	24.3125	24.18	24.205	12064520.0
2016-01-15 14:30:00	AAPL	Stock	24.2025	24.3998	24.1775	24.38	15516992.0
2016-01-15 15:00:00	AAPL	Stock	24.3775	24.4275	24.185	24.3	16839848.0
2016-01-15 15:30:00	AAPL	Stock	24.3	24.3125	24.2212	24.2725	21742976.0
2016-01-15 16:00:00	AAPL	Stock	24.2675	24.31	24.26	24.2975	15712548.0
2016-01-15 16:30:00	AAPL	Stock	24.2975	24.315	24.2715	24.2875	631308.0
2016-01-15 17:00:00	AAPL	Stock	24.2925	24.295	24.275	24.2875	68732.0
2016-01-15 17:30:00	AAPL	Stock	24.2875	24.3125	24.2825	24.2875	138308.0
2016-01-15 18:00:00	AAPL	Stock	24.29	24.3075	24.2825	24.2925	38556.0
2016-01-15 18:30:00	AAPL	Stock	24.295	24.295	24.2775	24.2875	777372.0
2016-01-15 19:00:00	AAPL	Stock	24.285	24.2875	24.2675	24.2675	740936.0
2016-01-15 19:30:00	AAPL	Stock	24.275	24.2875	24.2725	24.2825	41488.0
2016-01-15 04:00:00	MSFT	Stock	52.48	52.48	52.48	52.48	100.0
2016-01-15 06:00:00	MSFT	Stock	51.93	51.93	51.87	51.87	5698.0
2016-01-15 06:30:00	MSFT	Stock	51.66	51.66	51.66	51.66	800.0
2016-01-15 07:00:00	MSFT	Stock	51.77	52.05	51.77	52.0	1510.0
2016-01-15 07:30:00	MSFT	Stock	51.9	52.08	51.9	51.95	2048.0
2016-01-15 08:00:00	MSFT	Stock	51.95	52.0	51.8	51.8	30219.0
2016-01-15 08:30:00	MSFT	Stock	51.8	51.81	51.35	51.55	95083.0
2016-01-15 09:00:00	MSFT	Stock	51.55	51.65	51.02	51.15	641997.0
2016-01-15 09:30:00	MSFT	Stock	51.31	51.97	51.06	51.32	10844082.0
2016-01-15 10:00:00	MSFT	Stock	51.32	51.72	51.16	51.48	4345929.0
2016-01-15 10:30:00	MSFT	Stock	51.49	51.73	51.11	51.196	4193534.0
2016-01-15 11:00:00	MSFT	Stock	51.2	51.25	50.87	51.195	3907438.0
2016-01-15 11:30:00	MSFT	Stock	51.195	51.32	50.9	51.05	2733637.0
2016-01-15 12:00:00	MSFT	Stock	51.05	51.11	50.52	50.69	3574984.0
2016-01-15 12:30:00	MSFT	Stock	50.695	51.02	50.39	50.91	3073574.0
2016-01-15 13:00:00	MSFT	Stock	50.91	51.02	50.59	50.615	4144718.0
2016-01-15 13:30:00	MSFT	Stock	50.62	51.01	50.34	50.895	3010198.0
2016-01-15 14:00:00	MSFT	Stock	50.9	51.07	50.8	50.84	3095692.0

> showing 50 of 86,368 rows — these rows as CSV

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