PREVIEW / stock_30min / 2016-07-20

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-20.parquet
  size:    1.6 MB
  rows:    81,504
  symbols: 3,267

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-07-20 04:00:00	AAPL	Stock	24.96	24.96	24.96	24.96	496.0
2016-07-20 05:30:00	AAPL	Stock	25.0325	25.04	25.0325	25.04	1600.0
2016-07-20 06:00:00	AAPL	Stock	25.01	25.01	25.01	25.01	400.0
2016-07-20 07:00:00	AAPL	Stock	25.01	25.0375	25.01	25.0375	18100.0
2016-07-20 07:30:00	AAPL	Stock	25.0275	25.04	25.02	25.0325	25476.0
2016-07-20 08:00:00	AAPL	Stock	25.025	25.0375	25.0225	25.0325	174044.0
2016-07-20 08:30:00	AAPL	Stock	25.0325	25.0325	25.005	25.02	167004.0
2016-07-20 09:00:00	AAPL	Stock	25.02	25.025	24.9775	24.98	144896.0
2016-07-20 09:30:00	AAPL	Stock	24.98	25.115	24.97	25.055	17684632.0
2016-07-20 10:00:00	AAPL	Stock	25.0525	25.065	24.965	25.0075	11508388.0
2016-07-20 10:30:00	AAPL	Stock	25.0075	25.039	24.9725	24.999	6986908.0
2016-07-20 11:00:00	AAPL	Stock	25.0	25.0125	24.9775	25.0025	5542456.0
2016-07-20 11:30:00	AAPL	Stock	25.0025	25.02	24.98	25.0	4901660.0
2016-07-20 12:00:00	AAPL	Stock	25.0	25.0025	24.965	24.99	4996072.0
2016-07-20 12:30:00	AAPL	Stock	24.988	25.0	24.9375	24.9578	4206228.0
2016-07-20 13:00:00	AAPL	Stock	24.9578	25.0	24.95	25.0	3525092.0
2016-07-20 13:30:00	AAPL	Stock	24.9975	25.0	24.945	24.9525	4184840.0
2016-07-20 14:00:00	AAPL	Stock	24.955	24.9825	24.95	24.96	4451584.0
2016-07-20 14:30:00	AAPL	Stock	24.959	24.975	24.9375	24.9525	4386704.0
2016-07-20 15:00:00	AAPL	Stock	24.9538	24.9662	24.9338	24.9575	4475100.0
2016-07-20 15:30:00	AAPL	Stock	24.9575	25.0025	24.9525	24.9825	12561920.0
2016-07-20 16:00:00	AAPL	Stock	24.99	25.0125	24.9625	24.9875	8950820.0
2016-07-20 16:30:00	AAPL	Stock	24.9875	25.0275	24.9875	25.025	326864.0
2016-07-20 17:00:00	AAPL	Stock	25.0375	25.05	25.01	25.0375	166980.0
2016-07-20 17:30:00	AAPL	Stock	25.0375	25.0475	25.0175	25.0225	38872.0
2016-07-20 18:00:00	AAPL	Stock	25.025	25.05	25.0125	25.045	63880.0
2016-07-20 18:30:00	AAPL	Stock	25.0425	25.045	25.0375	25.0375	8240.0
2016-07-20 19:00:00	AAPL	Stock	25.03	25.0425	25.025	25.025	4000.0
2016-07-20 19:30:00	AAPL	Stock	25.04	25.0475	25.0375	25.0475	20684.0
2016-07-20 04:00:00	MSFT	Stock	55.25	55.3	55.18	55.2	1100.0
2016-07-20 04:30:00	MSFT	Stock	55.23	55.3	55.23	55.3	9600.0
2016-07-20 05:00:00	MSFT	Stock	55.34	55.4	55.23	55.29	3300.0
2016-07-20 05:30:00	MSFT	Stock	55.49	55.49	55.49	55.49	500.0
2016-07-20 06:00:00	MSFT	Stock	55.43	55.43	55.25	55.35	3878.0
2016-07-20 06:30:00	MSFT	Stock	55.35	55.45	55.35	55.45	17713.0
2016-07-20 07:00:00	MSFT	Stock	55.45	55.7	55.35	55.4	56953.0
2016-07-20 07:30:00	MSFT	Stock	55.4	55.66	55.36	55.64	106859.0
2016-07-20 08:00:00	MSFT	Stock	55.42	55.94	55.07	55.8	854077.0
2016-07-20 08:30:00	MSFT	Stock	55.81	55.86	55.65	55.8	416038.0
2016-07-20 09:00:00	MSFT	Stock	55.81	56.34	55.63	56.15	2379758.0
2016-07-20 09:30:00	MSFT	Stock	56.15	56.2	55.53	55.979	17862017.0
2016-07-20 10:00:00	MSFT	Stock	55.98	56.25	55.87	56.2	7588589.0
2016-07-20 10:30:00	MSFT	Stock	56.2	56.78	56.175	56.525	10496000.0
2016-07-20 11:00:00	MSFT	Stock	56.525	56.59	56.33	56.56	5887458.0
2016-07-20 11:30:00	MSFT	Stock	56.56	56.8	56.54	56.76	4437701.0
2016-07-20 12:00:00	MSFT	Stock	56.765	56.79	56.51	56.55	3040931.0
2016-07-20 12:30:00	MSFT	Stock	56.54	56.79	56.54	56.745	2556822.0
2016-07-20 13:00:00	MSFT	Stock	56.745	56.84	56.58	56.63	2190758.0
2016-07-20 13:30:00	MSFT	Stock	56.64	56.66	56.49	56.55	2950237.0
2016-07-20 14:00:00	MSFT	Stock	56.545	56.64	56.34	56.42	2964320.0

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

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