PREVIEW / stock_30min / 2017-01-23

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-23.parquet
  size:    1.6 MB
  rows:    81,346
  symbols: 3,123

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-01-23 04:00:00	AAPL	Stock	29.875	29.925	29.875	29.925	8420.0
2017-01-23 04:30:00	AAPL	Stock	29.95	29.95	29.95	29.95	400.0
2017-01-23 06:00:00	AAPL	Stock	29.955	29.955	29.9425	29.9425	5156.0
2017-01-23 06:30:00	AAPL	Stock	29.95	29.95	29.9425	29.9425	2660.0
2017-01-23 07:00:00	AAPL	Stock	29.9425	29.9625	29.93	29.9375	35456.0
2017-01-23 07:30:00	AAPL	Stock	29.9375	29.94	29.9	29.9375	42672.0
2017-01-23 08:00:00	AAPL	Stock	29.9475	29.9625	29.9125	29.9375	190004.0
2017-01-23 08:30:00	AAPL	Stock	29.94	29.9675	29.935	29.9625	59436.0
2017-01-23 09:00:00	AAPL	Stock	29.96	30.0	29.945	29.98	212980.0
2017-01-23 09:30:00	AAPL	Stock	29.9825	30.2025	29.98	30.0625	18287728.0
2017-01-23 10:00:00	AAPL	Stock	30.0618	30.1175	30.0275	30.085	7230016.0
2017-01-23 10:30:00	AAPL	Stock	30.085	30.085	29.9575	29.9712	7574040.0
2017-01-23 11:00:00	AAPL	Stock	29.9725	29.9975	29.9425	29.975	4931804.0
2017-01-23 11:30:00	AAPL	Stock	29.9775	30.0088	29.9425	29.9812	4954852.0
2017-01-23 12:00:00	AAPL	Stock	29.98	30.0175	29.97	29.9988	3538560.0
2017-01-23 12:30:00	AAPL	Stock	30.0	30.0342	29.9875	30.0072	2942672.0
2017-01-23 13:00:00	AAPL	Stock	30.005	30.0225	29.9922	29.9975	2126880.0
2017-01-23 13:30:00	AAPL	Stock	29.995	30.045	29.995	30.015	3135076.0
2017-01-23 14:00:00	AAPL	Stock	30.015	30.03	29.9875	30.0012	2712388.0
2017-01-23 14:30:00	AAPL	Stock	30.0015	30.0225	29.9925	30.0088	3162536.0
2017-01-23 15:00:00	AAPL	Stock	30.0075	30.0225	29.9975	30.009	3060048.0
2017-01-23 15:30:00	AAPL	Stock	30.0098	30.0525	30.0025	30.0225	8501552.0
2017-01-23 16:00:00	AAPL	Stock	30.02	30.0275	30.0175	30.02	4371712.0
2017-01-23 16:30:00	AAPL	Stock	30.025	30.025	30.02	30.02	84492.0
2017-01-23 17:00:00	AAPL	Stock	30.0325	30.045	30.02	30.0425	62396.0
2017-01-23 17:30:00	AAPL	Stock	30.0425	30.045	30.0425	30.045	4400.0
2017-01-23 18:00:00	AAPL	Stock	30.0325	30.0325	30.0325	30.0325	400.0
2017-01-23 18:30:00	AAPL	Stock	30.0275	30.03	30.0275	30.0275	13120.0
2017-01-23 19:00:00	AAPL	Stock	30.035	30.035	30.035	30.035	32948.0
2017-01-23 19:30:00	AAPL	Stock	30.0375	30.0475	30.0325	30.0475	16520.0
2017-01-23 04:00:00	MSFT	Stock	63.0	63.0	63.0	63.0	230.0
2017-01-23 05:30:00	MSFT	Stock	62.74	62.74	62.74	62.74	100.0
2017-01-23 07:00:00	MSFT	Stock	62.75	62.75	62.74	62.74	2100.0
2017-01-23 07:30:00	MSFT	Stock	62.75	62.75	62.75	62.75	100.0
2017-01-23 08:00:00	MSFT	Stock	62.85	62.85	62.78	62.78	5131.0
2017-01-23 08:30:00	MSFT	Stock	62.8	62.8	62.8	62.8	400.0
2017-01-23 09:00:00	MSFT	Stock	62.75	62.83	62.7	62.72	3916.0
2017-01-23 09:30:00	MSFT	Stock	62.7	63.116	62.7	62.829	2528752.0
2017-01-23 10:00:00	MSFT	Stock	62.825	62.9	62.67	62.83	1477830.0
2017-01-23 10:30:00	MSFT	Stock	62.83	62.835	62.699	62.76	1259894.0
2017-01-23 11:00:00	MSFT	Stock	62.77	62.78	62.655	62.75	1102878.0
2017-01-23 11:30:00	MSFT	Stock	62.75	62.78	62.57	62.67	1049956.0
2017-01-23 12:00:00	MSFT	Stock	62.68	62.79	62.64	62.776	731545.0
2017-01-23 12:30:00	MSFT	Stock	62.78	62.82	62.745	62.81	654412.0
2017-01-23 13:00:00	MSFT	Stock	62.802	62.84	62.77	62.77	792991.0
2017-01-23 13:30:00	MSFT	Stock	62.77	62.94	62.77	62.855	986641.0
2017-01-23 14:00:00	MSFT	Stock	62.85	62.89	62.75	62.845	1108349.0
2017-01-23 14:30:00	MSFT	Stock	62.842	62.92	62.815	62.91	709723.0
2017-01-23 15:00:00	MSFT	Stock	62.905	63.025	62.89	62.97	1561515.0
2017-01-23 15:30:00	MSFT	Stock	62.965	63.02	62.92	62.98	4070147.0

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

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