PREVIEW / stock_30min / 2017-07-24

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-24.parquet
  size:    1.6 MB
  rows:    81,633
  symbols: 2,978

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
2017-07-24 05:30:00	AAPL	Stock	37.525	37.525	37.525	37.525	400.0
2017-07-24 06:30:00	AAPL	Stock	37.475	37.475	37.475	37.475	2000.0
2017-07-24 07:00:00	AAPL	Stock	37.5	37.5	37.4875	37.5	7220.0
2017-07-24 07:30:00	AAPL	Stock	37.5125	37.5275	37.5125	37.5275	5292.0
2017-07-24 08:00:00	AAPL	Stock	37.5275	37.5825	37.52	37.5825	17600.0
2017-07-24 08:30:00	AAPL	Stock	37.5825	37.595	37.5625	37.5625	24088.0
2017-07-24 09:00:00	AAPL	Stock	37.58	37.66	37.57	37.6375	68832.0
2017-07-24 09:30:00	AAPL	Stock	37.645	37.6675	37.475	37.6375	7943596.0
2017-07-24 10:00:00	AAPL	Stock	37.6375	37.8025	37.6275	37.76	7480500.0
2017-07-24 10:30:00	AAPL	Stock	37.7575	37.8325	37.7375	37.78	4556216.0
2017-07-24 11:00:00	AAPL	Stock	37.78	37.785	37.705	37.7525	3504164.0
2017-07-24 11:30:00	AAPL	Stock	37.7537	37.83	37.7525	37.82	2523660.0
2017-07-24 12:00:00	AAPL	Stock	37.82	37.945	37.8175	37.9238	4225308.0
2017-07-24 12:30:00	AAPL	Stock	37.9242	37.9825	37.9242	37.9655	3600116.0
2017-07-24 13:00:00	AAPL	Stock	37.9675	38.0	37.965	37.9963	2754928.0
2017-07-24 13:30:00	AAPL	Stock	37.9965	38.0	37.92	37.94	3546480.0
2017-07-24 14:00:00	AAPL	Stock	37.9375	37.96	37.89	37.9	2448920.0
2017-07-24 14:30:00	AAPL	Stock	37.9002	37.9575	37.8825	37.955	3001100.0
2017-07-24 15:00:00	AAPL	Stock	37.9562	38.0325	37.9225	38.0312	5962924.0
2017-07-24 15:30:00	AAPL	Stock	38.03	38.11	37.89	38.0275	13281200.0
2017-07-24 16:00:00	AAPL	Stock	38.0275	38.11	37.965	37.9675	11845508.0
2017-07-24 16:30:00	AAPL	Stock	37.97	38.0225	37.925	37.93	139044.0
2017-07-24 17:00:00	AAPL	Stock	37.93	38.0225	37.92	37.9625	276992.0
2017-07-24 17:30:00	AAPL	Stock	37.9375	38.0225	37.925	37.95	20968.0
2017-07-24 18:00:00	AAPL	Stock	37.9625	37.995	37.95	37.995	25140.0
2017-07-24 18:30:00	AAPL	Stock	37.97	37.97	37.9525	37.9575	15700.0
2017-07-24 19:00:00	AAPL	Stock	37.9675	37.9675	37.9575	37.9575	2428.0
2017-07-24 19:30:00	AAPL	Stock	37.9625	37.9675	37.9575	37.9675	19108.0
2017-07-24 04:00:00	MSFT	Stock	73.61	73.7	73.6	73.68	1034.0
2017-07-24 04:30:00	MSFT	Stock	73.66	73.66	73.66	73.66	250.0
2017-07-24 05:00:00	MSFT	Stock	73.64	73.64	73.6	73.6	998.0
2017-07-24 05:30:00	MSFT	Stock	73.59	73.65	73.55	73.55	947.0
2017-07-24 06:00:00	MSFT	Stock	73.55	73.55	73.5	73.5	565.0
2017-07-24 07:00:00	MSFT	Stock	73.51	73.51	73.51	73.51	1740.0
2017-07-24 07:30:00	MSFT	Stock	73.52	73.55	73.46	73.47	2890.0
2017-07-24 08:00:00	MSFT	Stock	73.48	73.55	73.42	73.55	6909.0
2017-07-24 08:30:00	MSFT	Stock	73.6	73.63	73.55	73.6	4413.0
2017-07-24 09:00:00	MSFT	Stock	73.58	73.58	73.38	73.51	11231.0
2017-07-24 09:30:00	MSFT	Stock	73.53	73.65	73.41	73.626	2274799.0
2017-07-24 10:00:00	MSFT	Stock	73.63	73.64	73.13	73.165	1764271.0
2017-07-24 10:30:00	MSFT	Stock	73.165	73.385	73.15	73.385	1495496.0
2017-07-24 11:00:00	MSFT	Stock	73.385	73.4	73.21	73.26	1143361.0
2017-07-24 11:30:00	MSFT	Stock	73.26	73.31	73.24	73.295	589889.0
2017-07-24 12:00:00	MSFT	Stock	73.3	73.37	73.29	73.31	411311.0
2017-07-24 12:30:00	MSFT	Stock	73.315	73.41	73.29	73.33	608804.0
2017-07-24 13:00:00	MSFT	Stock	73.335	73.34	73.17	73.28	733874.0
2017-07-24 13:30:00	MSFT	Stock	73.28	73.33	73.24	73.27	566667.0
2017-07-24 14:00:00	MSFT	Stock	73.275	73.39	73.27	73.32	837258.0
2017-07-24 14:30:00	MSFT	Stock	73.315	73.39	73.3	73.38	749473.0
2017-07-24 15:00:00	MSFT	Stock	73.38	73.63	73.341	73.62	1637475.0

> showing 50 of 81,633 rows — these rows as CSV

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