PREVIEW / stock_30min / 2016-08-25

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-25.parquet
  size:    1.6 MB
  rows:    80,288
  symbols: 3,252

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
2016-08-25 04:00:00	AAPL	Stock	27.01	27.01	26.9625	26.9625	4404.0
2016-08-25 04:30:00	AAPL	Stock	26.95	26.95	26.9375	26.9375	800.0
2016-08-25 05:30:00	AAPL	Stock	26.9575	26.9575	26.9275	26.9275	5168.0
2016-08-25 06:00:00	AAPL	Stock	26.94	26.9425	26.94	26.9425	1800.0
2016-08-25 07:00:00	AAPL	Stock	26.9225	26.9225	26.9225	26.9225	3600.0
2016-08-25 07:30:00	AAPL	Stock	26.9075	26.925	26.8875	26.925	10292.0
2016-08-25 08:00:00	AAPL	Stock	26.94	26.94	26.895	26.8975	59644.0
2016-08-25 08:30:00	AAPL	Stock	26.8975	26.9175	26.885	26.89	173940.0
2016-08-25 09:00:00	AAPL	Stock	26.8925	26.9125	26.8375	26.85	166152.0
2016-08-25 09:30:00	AAPL	Stock	26.8475	26.85	26.6925	26.7025	21363328.0
2016-08-25 10:00:00	AAPL	Stock	26.705	26.79	26.67	26.775	11701892.0
2016-08-25 10:30:00	AAPL	Stock	26.7725	26.8062	26.7178	26.8	6358456.0
2016-08-25 11:00:00	AAPL	Stock	26.8	26.8975	26.795	26.875	6943228.0
2016-08-25 11:30:00	AAPL	Stock	26.875	26.8775	26.83	26.8425	4692612.0
2016-08-25 12:00:00	AAPL	Stock	26.8438	26.8475	26.795	26.82	3081936.0
2016-08-25 12:30:00	AAPL	Stock	26.822	26.875	26.8175	26.8712	3307380.0
2016-08-25 13:00:00	AAPL	Stock	26.8725	26.93	26.8725	26.9275	3455308.0
2016-08-25 13:30:00	AAPL	Stock	26.9275	27.0075	26.8275	26.87	5101440.0
2016-08-25 14:00:00	AAPL	Stock	26.8685	26.9025	26.8275	26.8975	4382900.0
2016-08-25 14:30:00	AAPL	Stock	26.8962	26.95	26.8925	26.9135	4399560.0
2016-08-25 15:00:00	AAPL	Stock	26.9148	26.97	26.8862	26.92	3796960.0
2016-08-25 15:30:00	AAPL	Stock	26.92	26.935	26.875	26.8975	8496300.0
2016-08-25 16:00:00	AAPL	Stock	26.8975	26.9	26.8312	26.89	3473484.0
2016-08-25 16:30:00	AAPL	Stock	26.8975	26.8975	26.8925	26.8925	6000.0
2016-08-25 17:00:00	AAPL	Stock	26.9	26.91	26.89	26.8925	228012.0
2016-08-25 17:30:00	AAPL	Stock	26.89	26.89	26.88	26.8875	21000.0
2016-08-25 18:00:00	AAPL	Stock	26.8875	26.9125	26.8875	26.89	6432.0
2016-08-25 19:00:00	AAPL	Stock	26.91	26.91	26.8975	26.8975	2400.0
2016-08-25 19:30:00	AAPL	Stock	26.8925	26.9025	26.875	26.8975	23276.0
2016-08-25 09:00:00	MSFT	Stock	57.97	57.97	57.97	57.97	1800.0
2016-08-25 09:30:00	MSFT	Stock	57.88	58.22	57.78	58.18	1958178.0
2016-08-25 10:00:00	MSFT	Stock	58.18	58.2	58.03	58.05	1368039.0
2016-08-25 10:30:00	MSFT	Stock	58.045	58.11	57.99	58.09	845232.0
2016-08-25 11:00:00	MSFT	Stock	58.095	58.27	58.095	58.15	1025426.0
2016-08-25 11:30:00	MSFT	Stock	58.15	58.26	58.15	58.191	766041.0
2016-08-25 12:00:00	MSFT	Stock	58.2	58.21	58.142	58.175	576917.0
2016-08-25 12:30:00	MSFT	Stock	58.173	58.29	58.17	58.245	526679.0
2016-08-25 13:00:00	MSFT	Stock	58.25	58.27	58.18	58.25	371739.0
2016-08-25 13:30:00	MSFT	Stock	58.25	58.25	57.95	58.14	910166.0
2016-08-25 14:00:00	MSFT	Stock	58.143	58.22	58.09	58.193	985565.0
2016-08-25 14:30:00	MSFT	Stock	58.195	58.265	58.15	58.19	1023751.0
2016-08-25 15:00:00	MSFT	Stock	58.19	58.28	58.16	58.25	1089558.0
2016-08-25 15:30:00	MSFT	Stock	58.25	58.27	58.15	58.19	2905780.0
2016-08-25 16:00:00	MSFT	Stock	58.175	58.19	58.13	58.17	1845863.0
2016-08-25 16:30:00	MSFT	Stock	58.2	58.2	58.15	58.15	490.0
2016-08-25 17:00:00	MSFT	Stock	58.15	58.17	58.15	58.15	8583.0
2016-08-25 17:30:00	MSFT	Stock	58.15	58.15	58.15	58.15	200.0
2016-08-25 18:00:00	MSFT	Stock	58.17	58.17	58.17	58.17	400.0
2016-08-25 04:00:00	NVDA	Stock	1.5512	1.5512	1.5512	1.5512	10000.0
2016-08-25 05:30:00	NVDA	Stock	1.5412	1.5412	1.537	1.537	28840.0

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

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