PREVIEW / stock_30min / 2017-05-12

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-12.parquet
  size:    1.6 MB
  rows:    81,650
  symbols: 3,035

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-05-12 04:00:00	AAPL	Stock	38.565	38.6025	38.5525	38.6025	28316.0
2017-05-12 04:30:00	AAPL	Stock	38.6225	38.625	38.59	38.6125	9636.0
2017-05-12 05:00:00	AAPL	Stock	38.58	38.58	38.5475	38.55	19248.0
2017-05-12 05:30:00	AAPL	Stock	38.55	38.575	38.55	38.575	3600.0
2017-05-12 06:00:00	AAPL	Stock	38.58	38.59	38.545	38.55	30960.0
2017-05-12 06:30:00	AAPL	Stock	38.545	38.56	38.545	38.56	3920.0
2017-05-12 07:00:00	AAPL	Stock	38.545	38.5975	38.525	38.595	81504.0
2017-05-12 07:30:00	AAPL	Stock	38.5925	38.6475	38.5925	38.6325	153284.0
2017-05-12 08:00:00	AAPL	Stock	38.6325	38.7025	38.565	38.6825	415052.0
2017-05-12 08:30:00	AAPL	Stock	38.685	38.7125	38.665	38.7	209368.0
2017-05-12 09:00:00	AAPL	Stock	38.6975	38.7575	38.6725	38.7	782616.0
2017-05-12 09:30:00	AAPL	Stock	38.6725	38.985	38.6675	38.8975	26238456.0
2017-05-12 10:00:00	AAPL	Stock	38.9	39.105	38.895	38.9495	16899044.0
2017-05-12 10:30:00	AAPL	Stock	38.9487	39.0625	38.8575	38.9427	10699332.0
2017-05-12 11:00:00	AAPL	Stock	38.9435	39.0658	38.93	39.0647	7609260.0
2017-05-12 11:30:00	AAPL	Stock	39.0642	39.1	38.9945	39.03	6029552.0
2017-05-12 12:00:00	AAPL	Stock	39.03	39.05	38.9625	39.0025	4078296.0
2017-05-12 12:30:00	AAPL	Stock	39.0032	39.0575	38.975	38.975	4587176.0
2017-05-12 13:00:00	AAPL	Stock	38.9762	38.995	38.9225	38.9612	5174244.0
2017-05-12 13:30:00	AAPL	Stock	38.9625	39.0125	38.92	38.9938	4954904.0
2017-05-12 14:00:00	AAPL	Stock	38.9975	39.05	38.9805	38.9925	4340024.0
2017-05-12 14:30:00	AAPL	Stock	38.99	39.015	38.98	39.0	3717204.0
2017-05-12 15:00:00	AAPL	Stock	39.0	39.01	38.9088	38.9125	5451348.0
2017-05-12 15:30:00	AAPL	Stock	38.915	39.0325	38.8847	39.025	12584656.0
2017-05-12 16:00:00	AAPL	Stock	39.025	39.04	39.015	39.025	4549296.0
2017-05-12 16:30:00	AAPL	Stock	39.02	39.025	39.005	39.0225	813336.0
2017-05-12 17:00:00	AAPL	Stock	39.0225	39.025	39.0075	39.0075	38132.0
2017-05-12 17:30:00	AAPL	Stock	39.02	39.02	39.02	39.02	4400.0
2017-05-12 18:00:00	AAPL	Stock	39.02	39.0225	39.0075	39.0225	27832.0
2017-05-12 18:30:00	AAPL	Stock	39.0125	39.025	39.0125	39.02	17668.0
2017-05-12 19:00:00	AAPL	Stock	39.02	39.0225	39.01	39.0225	11540.0
2017-05-12 19:30:00	AAPL	Stock	39.0225	39.025	39.0	39.0175	26808.0
2017-05-12 04:30:00	MSFT	Stock	68.45	68.45	68.45	68.45	100.0
2017-05-12 06:30:00	MSFT	Stock	68.44	68.46	68.37	68.46	340.0
2017-05-12 08:00:00	MSFT	Stock	68.45	68.51	68.32	68.5	7188.0
2017-05-12 08:30:00	MSFT	Stock	68.59	68.62	68.4	68.57	7621.0
2017-05-12 09:00:00	MSFT	Stock	68.56	68.64	68.45	68.52	58727.0
2017-05-12 09:30:00	MSFT	Stock	68.61	68.61	68.06	68.08	2933089.0
2017-05-12 10:00:00	MSFT	Stock	68.08	68.21	68.04	68.165	1967312.0
2017-05-12 10:30:00	MSFT	Stock	68.17	68.19	68.09	68.185	760688.0
2017-05-12 11:00:00	MSFT	Stock	68.19	68.29	68.185	68.26	733294.0
2017-05-12 11:30:00	MSFT	Stock	68.27	68.321	68.25	68.28	519503.0
2017-05-12 12:00:00	MSFT	Stock	68.285	68.35	68.25	68.32	425766.0
2017-05-12 12:30:00	MSFT	Stock	68.323	68.44	68.295	68.4	451961.0
2017-05-12 13:00:00	MSFT	Stock	68.4	68.41	68.35	68.4	396702.0
2017-05-12 13:30:00	MSFT	Stock	68.4	68.52	68.39	68.5	687882.0
2017-05-12 14:00:00	MSFT	Stock	68.505	68.52	68.29	68.316	992157.0
2017-05-12 14:30:00	MSFT	Stock	68.31	68.38	68.29	68.315	894081.0
2017-05-12 15:00:00	MSFT	Stock	68.315	68.32	68.24	68.25	929238.0
2017-05-12 15:30:00	MSFT	Stock	68.255	68.38	68.23	68.38	2461209.0

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

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