PREVIEW / stock_30min / 2015-08-10

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-08-10.parquet
  size:    1.6 MB
  rows:    82,412
  symbols: 3,468

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
2015-08-10 04:00:00	AAPL	Stock	28.9175	28.9175	28.9175	28.9175	400.0
2015-08-10 04:30:00	AAPL	Stock	28.9425	28.9725	28.9425	28.97	26408.0
2015-08-10 05:00:00	AAPL	Stock	28.97	28.97	28.9425	28.9425	42800.0
2015-08-10 05:30:00	AAPL	Stock	28.98	29.02	28.98	29.02	7096.0
2015-08-10 06:00:00	AAPL	Stock	29.0225	29.0775	29.0025	29.0775	17716.0
2015-08-10 06:30:00	AAPL	Stock	29.0625	29.095	29.025	29.025	10016.0
2015-08-10 07:00:00	AAPL	Stock	29.035	29.07	29.015	29.05	99200.0
2015-08-10 07:30:00	AAPL	Stock	29.055	29.1	29.0475	29.0525	126560.0
2015-08-10 08:00:00	AAPL	Stock	29.0625	29.1375	29.0325	29.1	454232.0
2015-08-10 08:30:00	AAPL	Stock	29.1	29.21	29.1	29.1458	693064.0
2015-08-10 09:00:00	AAPL	Stock	29.155	29.1975	29.14	29.14	394544.0
2015-08-10 09:30:00	AAPL	Stock	29.1325	29.4625	29.1325	29.35	34009076.0
2015-08-10 10:00:00	AAPL	Stock	29.3525	29.5825	29.35	29.5525	20839244.0
2015-08-10 10:30:00	AAPL	Stock	29.5525	29.685	29.5262	29.5988	19711424.0
2015-08-10 11:00:00	AAPL	Stock	29.6025	29.7	29.5525	29.6875	12406456.0
2015-08-10 11:30:00	AAPL	Stock	29.685	29.8025	29.6725	29.759	14119876.0
2015-08-10 12:00:00	AAPL	Stock	29.757	29.8475	29.7275	29.7612	13909760.0
2015-08-10 12:30:00	AAPL	Stock	29.761	29.86	29.7225	29.855	9556144.0
2015-08-10 13:00:00	AAPL	Stock	29.8552	29.92	29.845	29.8475	9439140.0
2015-08-10 13:30:00	AAPL	Stock	29.8475	29.9375	29.8225	29.9062	8724332.0
2015-08-10 14:00:00	AAPL	Stock	29.9075	29.995	29.9075	29.945	13106968.0
2015-08-10 14:30:00	AAPL	Stock	29.945	29.9975	29.8775	29.938	11257392.0
2015-08-10 15:00:00	AAPL	Stock	29.9375	29.9575	29.9025	29.9338	9199060.0
2015-08-10 15:30:00	AAPL	Stock	29.9338	29.95	29.8875	29.93	19633236.0
2015-08-10 16:00:00	AAPL	Stock	29.93	29.94	29.7225	29.8775	7888324.0
2015-08-10 16:30:00	AAPL	Stock	29.875	29.93	29.8175	29.8875	243744.0
2015-08-10 17:00:00	AAPL	Stock	29.8825	29.895	29.8575	29.875	81324.0
2015-08-10 17:30:00	AAPL	Stock	29.8658	29.93	29.855	29.875	88272.0
2015-08-10 18:00:00	AAPL	Stock	29.875	29.925	29.875	29.905	126596.0
2015-08-10 18:30:00	AAPL	Stock	29.905	29.9125	29.9	29.9	20916.0
2015-08-10 19:00:00	AAPL	Stock	29.91	29.9225	29.9025	29.9218	25280.0
2015-08-10 19:30:00	AAPL	Stock	29.915	29.925	29.9075	29.9225	89180.0
2015-08-10 08:00:00	MSFT	Stock	46.8	46.99	46.8	46.99	36610.0
2015-08-10 08:30:00	MSFT	Stock	46.98	47.13	46.98	47.1	5843.0
2015-08-10 09:00:00	MSFT	Stock	47.08	47.08	46.9	47.0	10157.0
2015-08-10 09:30:00	MSFT	Stock	47.0	47.32	46.84	47.189	2521897.0
2015-08-10 10:00:00	MSFT	Stock	47.18	47.45	47.18	47.34	1522215.0
2015-08-10 10:30:00	MSFT	Stock	47.345	47.49	47.255	47.39	1410971.0
2015-08-10 11:00:00	MSFT	Stock	47.395	47.48	47.25	47.26	1209240.0
2015-08-10 11:30:00	MSFT	Stock	47.26	47.345	47.25	47.33	1983495.0
2015-08-10 12:00:00	MSFT	Stock	47.33	47.365	47.28	47.285	781935.0
2015-08-10 12:30:00	MSFT	Stock	47.285	47.325	47.25	47.29	1031712.0
2015-08-10 13:00:00	MSFT	Stock	47.29	47.3	47.265	47.28	703687.0
2015-08-10 13:30:00	MSFT	Stock	47.28	47.29	47.25	47.28	733711.0
2015-08-10 14:00:00	MSFT	Stock	47.285	47.42	47.26	47.38	1418106.0
2015-08-10 14:30:00	MSFT	Stock	47.37	47.39	47.32	47.33	921306.0
2015-08-10 15:00:00	MSFT	Stock	47.33	47.38	47.32	47.335	1390032.0
2015-08-10 15:30:00	MSFT	Stock	47.335	47.35	47.225	47.33	2787560.0
2015-08-10 16:00:00	MSFT	Stock	47.33	47.345	47.3	47.33	3247648.0
2015-08-10 16:30:00	MSFT	Stock	47.213	47.3	47.213	47.3	4709.0

> showing 50 of 82,412 rows — these rows as CSV

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