PREVIEW / stock_30min / 2017-03-30

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-30.parquet
  size:    1.6 MB
  rows:    81,530
  symbols: 3,095

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-03-30 04:00:00	AAPL	Stock	36.1125	36.1125	36.075	36.075	8180.0
2017-03-30 04:30:00	AAPL	Stock	36.1	36.1	36.05	36.05	32788.0
2017-03-30 05:00:00	AAPL	Stock	36.075	36.0775	36.075	36.075	1644.0
2017-03-30 05:30:00	AAPL	Stock	36.075	36.1175	36.075	36.1175	7348.0
2017-03-30 06:00:00	AAPL	Stock	36.095	36.1125	36.0875	36.0875	9600.0
2017-03-30 06:30:00	AAPL	Stock	36.0825	36.0825	36.075	36.075	12784.0
2017-03-30 07:00:00	AAPL	Stock	36.075	36.08	36.05	36.05	39644.0
2017-03-30 07:30:00	AAPL	Stock	36.0725	36.0975	36.05	36.09	24020.0
2017-03-30 08:00:00	AAPL	Stock	36.07	36.0925	35.875	36.05	160888.0
2017-03-30 08:30:00	AAPL	Stock	36.05	36.09	36.05	36.08	53728.0
2017-03-30 09:00:00	AAPL	Stock	36.075	36.085	36.0025	36.0275	107560.0
2017-03-30 09:30:00	AAPL	Stock	36.035	36.125	35.97	36.02	13701084.0
2017-03-30 10:00:00	AAPL	Stock	36.02	36.1	36.0075	36.0675	6726032.0
2017-03-30 10:30:00	AAPL	Stock	36.0603	36.07	36.0025	36.0425	5102776.0
2017-03-30 11:00:00	AAPL	Stock	36.0425	36.06	35.985	36.0175	3652980.0
2017-03-30 11:30:00	AAPL	Stock	36.0175	36.0548	35.9375	35.9425	4442344.0
2017-03-30 12:00:00	AAPL	Stock	35.9405	35.97	35.9	35.96	4654656.0
2017-03-30 12:30:00	AAPL	Stock	35.96	35.9625	35.875	35.9332	4174064.0
2017-03-30 13:00:00	AAPL	Stock	35.9325	36.035	35.9175	35.9918	4756220.0
2017-03-30 13:30:00	AAPL	Stock	35.995	36.035	35.9875	36.0	3077188.0
2017-03-30 14:00:00	AAPL	Stock	36.0025	36.0075	35.9625	35.9925	2741332.0
2017-03-30 14:30:00	AAPL	Stock	35.9925	36.005	35.9175	35.945	3160848.0
2017-03-30 15:00:00	AAPL	Stock	35.9457	35.9875	35.945	35.9575	2814612.0
2017-03-30 15:30:00	AAPL	Stock	35.955	36.0	35.93	35.98	6307632.0
2017-03-30 16:00:00	AAPL	Stock	35.9825	35.9875	35.9475	35.9725	10312916.0
2017-03-30 16:30:00	AAPL	Stock	35.9825	35.9825	35.9625	35.965	6240.0
2017-03-30 17:00:00	AAPL	Stock	35.965	35.97	35.955	35.965	7372.0
2017-03-30 17:30:00	AAPL	Stock	35.9675	35.975	35.9675	35.975	2092.0
2017-03-30 18:00:00	AAPL	Stock	35.9725	35.9725	35.9625	35.9725	7628.0
2017-03-30 18:30:00	AAPL	Stock	35.975	35.9775	35.9725	35.9775	7144.0
2017-03-30 19:00:00	AAPL	Stock	35.955	35.955	35.955	35.955	2476.0
2017-03-30 19:30:00	AAPL	Stock	35.965	35.975	35.9425	35.9425	13508.0
2017-03-30 08:00:00	MSFT	Stock	65.54	65.54	65.4	65.4	1612.0
2017-03-30 08:30:00	MSFT	Stock	65.52	65.53	65.5	65.5	440.0
2017-03-30 09:00:00	MSFT	Stock	65.5	65.63	65.33	65.33	15181.0
2017-03-30 09:30:00	MSFT	Stock	65.42	65.8	65.36	65.75	1883275.0
2017-03-30 10:00:00	MSFT	Stock	65.74	65.98	65.73	65.88	1598686.0
2017-03-30 10:30:00	MSFT	Stock	65.875	65.96	65.83	65.92	911418.0
2017-03-30 11:00:00	MSFT	Stock	65.92	65.94	65.83	65.85	870563.0
2017-03-30 11:30:00	MSFT	Stock	65.86	65.91	65.76	65.79	682816.0
2017-03-30 12:00:00	MSFT	Stock	65.79	65.87	65.745	65.795	533765.0
2017-03-30 12:30:00	MSFT	Stock	65.79	65.795	65.61	65.665	709643.0
2017-03-30 13:00:00	MSFT	Stock	65.665	65.77	65.65	65.74	551683.0
2017-03-30 13:30:00	MSFT	Stock	65.75	65.81	65.7	65.725	496406.0
2017-03-30 14:00:00	MSFT	Stock	65.73	65.83	65.71	65.78	614344.0
2017-03-30 14:30:00	MSFT	Stock	65.78	65.785	65.665	65.69	1170784.0
2017-03-30 15:00:00	MSFT	Stock	65.69	65.72	65.65	65.695	675577.0
2017-03-30 15:30:00	MSFT	Stock	65.69	65.79	65.61	65.71	2152740.0
2017-03-30 16:00:00	MSFT	Stock	65.71	65.772	65.71	65.772	1213007.0
2017-03-30 16:30:00	MSFT	Stock	65.76	65.76	65.71	65.76	800.0

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

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