PREVIEW / stock_30min / 2017-07-10

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-10.parquet
  size:    1.6 MB
  rows:    80,720
  symbols: 2,990

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-10 04:00:00	AAPL	Stock	36.2075	36.2075	36.1375	36.1375	800.0
2017-07-10 05:00:00	AAPL	Stock	36.1475	36.1475	36.1475	36.1475	432.0
2017-07-10 06:00:00	AAPL	Stock	36.155	36.155	36.15	36.15	3492.0
2017-07-10 06:30:00	AAPL	Stock	36.21	36.21	36.21	36.21	612.0
2017-07-10 07:00:00	AAPL	Stock	36.21	36.2475	36.16	36.175	26920.0
2017-07-10 07:30:00	AAPL	Stock	36.16	36.175	36.15	36.175	7640.0
2017-07-10 08:00:00	AAPL	Stock	36.1625	36.215	36.0	36.14	128552.0
2017-07-10 08:30:00	AAPL	Stock	36.12	36.1375	36.075	36.075	89256.0
2017-07-10 09:00:00	AAPL	Stock	36.0775	36.0775	36.01	36.045	404916.0
2017-07-10 09:30:00	AAPL	Stock	36.0275	36.1325	35.8425	35.87	10127380.0
2017-07-10 10:00:00	AAPL	Stock	35.8675	35.99	35.8575	35.9535	5675420.0
2017-07-10 10:30:00	AAPL	Stock	35.95	36.225	35.92	36.21	5743632.0
2017-07-10 11:00:00	AAPL	Stock	36.2075	36.2475	36.17	36.1825	4128364.0
2017-07-10 11:30:00	AAPL	Stock	36.18	36.2325	36.1775	36.2112	2992656.0
2017-07-10 12:00:00	AAPL	Stock	36.21	36.3147	36.2	36.309	3991444.0
2017-07-10 12:30:00	AAPL	Stock	36.3075	36.38	36.26	36.375	4835228.0
2017-07-10 13:00:00	AAPL	Stock	36.3775	36.4388	36.3675	36.3825	4025608.0
2017-07-10 13:30:00	AAPL	Stock	36.3825	36.4688	36.3775	36.4662	2960368.0
2017-07-10 14:00:00	AAPL	Stock	36.4665	36.4875	36.4275	36.4285	2938224.0
2017-07-10 14:30:00	AAPL	Stock	36.43	36.4575	36.39	36.4125	2689596.0
2017-07-10 15:00:00	AAPL	Stock	36.4125	36.4275	36.36	36.375	3725628.0
2017-07-10 15:30:00	AAPL	Stock	36.375	36.4175	36.2575	36.2725	11839372.0
2017-07-10 16:00:00	AAPL	Stock	36.265	36.31	36.2525	36.2525	10470984.0
2017-07-10 16:30:00	AAPL	Stock	36.25	36.2775	36.25	36.25	29040.0
2017-07-10 17:00:00	AAPL	Stock	36.24	36.25	36.2375	36.2375	2344.0
2017-07-10 17:30:00	AAPL	Stock	36.24	36.25	36.24	36.25	3200.0
2017-07-10 18:00:00	AAPL	Stock	36.2425	36.25	36.2425	36.25	9680.0
2017-07-10 18:30:00	AAPL	Stock	36.24	36.25	36.24	36.24	2724.0
2017-07-10 19:00:00	AAPL	Stock	36.24	36.25	36.24	36.245	5200.0
2017-07-10 19:30:00	AAPL	Stock	36.25	36.25	36.2375	36.2375	11788.0
2017-07-10 07:00:00	MSFT	Stock	69.65	69.65	69.65	69.65	436.0
2017-07-10 07:30:00	MSFT	Stock	69.66	69.66	69.61	69.61	1173.0
2017-07-10 08:00:00	MSFT	Stock	69.6	69.78	69.6	69.78	4297.0
2017-07-10 08:30:00	MSFT	Stock	69.64	69.65	69.6	69.6	11607.0
2017-07-10 09:00:00	MSFT	Stock	69.59	69.63	69.35	69.4	10270.0
2017-07-10 09:30:00	MSFT	Stock	69.46	69.96	69.2	69.58	2319964.0
2017-07-10 10:00:00	MSFT	Stock	69.57	69.93	69.55	69.845	1523776.0
2017-07-10 10:30:00	MSFT	Stock	69.845	70.0	69.8	69.98	842789.0
2017-07-10 11:00:00	MSFT	Stock	69.98	70.02	69.86	69.885	892688.0
2017-07-10 11:30:00	MSFT	Stock	69.885	70.02	69.88	69.97	883548.0
2017-07-10 12:00:00	MSFT	Stock	69.969	70.05	69.92	69.98	623391.0
2017-07-10 12:30:00	MSFT	Stock	69.98	69.99	69.835	69.85	452001.0
2017-07-10 13:00:00	MSFT	Stock	69.85	69.93	69.82	69.86	447089.0
2017-07-10 13:30:00	MSFT	Stock	69.87	70.03	69.87	69.995	490879.0
2017-07-10 14:00:00	MSFT	Stock	69.997	70.075	69.983	70.025	743431.0
2017-07-10 14:30:00	MSFT	Stock	70.03	70.1	70.02	70.055	500236.0
2017-07-10 15:00:00	MSFT	Stock	70.06	70.12	70.03	70.105	746093.0
2017-07-10 15:30:00	MSFT	Stock	70.11	70.25	69.98	69.98	2029972.0
2017-07-10 16:00:00	MSFT	Stock	69.98	70.01	69.98	69.98	1627217.0
2017-07-10 16:30:00	MSFT	Stock	69.94	69.94	69.94	69.94	170.0

> showing 50 of 80,720 rows — these rows as CSV

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