PREVIEW / stock_30min / 2017-07-07

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-07.parquet
  size:    1.6 MB
  rows:    80,214
  symbols: 3,000

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-07-07 04:00:00	AAPL	Stock	35.6	35.6	35.6	35.6	3784.0
2017-07-07 06:00:00	AAPL	Stock	35.7	35.7075	35.7	35.7075	4000.0
2017-07-07 06:30:00	AAPL	Stock	35.7	35.7	35.7	35.7	3040.0
2017-07-07 07:00:00	AAPL	Stock	35.6625	35.6875	35.6625	35.6725	8248.0
2017-07-07 07:30:00	AAPL	Stock	35.675	35.675	35.675	35.675	400.0
2017-07-07 08:00:00	AAPL	Stock	35.665	35.75	35.665	35.75	24484.0
2017-07-07 08:30:00	AAPL	Stock	35.7275	35.8725	35.725	35.8175	328472.0
2017-07-07 09:00:00	AAPL	Stock	35.8175	35.8425	35.725	35.725	284264.0
2017-07-07 09:30:00	AAPL	Stock	35.7275	36.035	35.725	36.0037	12467640.0
2017-07-07 10:00:00	AAPL	Stock	36.0025	36.0225	35.875	35.95	5175004.0
2017-07-07 10:30:00	AAPL	Stock	35.9525	36.0325	35.945	35.959	3695848.0
2017-07-07 11:00:00	AAPL	Stock	35.9575	36.0118	35.92	35.9938	3402328.0
2017-07-07 11:30:00	AAPL	Stock	35.995	36.0625	35.99	36.0375	3972220.0
2017-07-07 12:00:00	AAPL	Stock	36.0375	36.0672	35.9825	36.0475	2676628.0
2017-07-07 12:30:00	AAPL	Stock	36.0475	36.065	36.0225	36.0612	2306740.0
2017-07-07 13:00:00	AAPL	Stock	36.0612	36.16	36.0475	36.1538	3510876.0
2017-07-07 13:30:00	AAPL	Stock	36.1538	36.1875	36.1325	36.1625	2820144.0
2017-07-07 14:00:00	AAPL	Stock	36.165	36.1675	36.0513	36.056	3241292.0
2017-07-07 14:30:00	AAPL	Stock	36.056	36.1425	36.045	36.1275	2553612.0
2017-07-07 15:00:00	AAPL	Stock	36.125	36.1325	36.005	36.1045	3866888.0
2017-07-07 15:30:00	AAPL	Stock	36.105	36.1462	36.025	36.0425	8425644.0
2017-07-07 16:00:00	AAPL	Stock	36.045	36.065	36.0375	36.06	7400488.0
2017-07-07 16:30:00	AAPL	Stock	36.0625	36.065	36.05	36.055	31988.0
2017-07-07 17:00:00	AAPL	Stock	36.055	36.0625	36.05	36.05	6600.0
2017-07-07 17:30:00	AAPL	Stock	36.0525	36.0525	36.0525	36.0525	12560.0
2017-07-07 18:00:00	AAPL	Stock	36.065	36.065	36.0525	36.0525	4244.0
2017-07-07 18:30:00	AAPL	Stock	36.0525	36.0525	36.0525	36.0525	2400.0
2017-07-07 19:00:00	AAPL	Stock	36.065	36.065	36.0575	36.0625	55284.0
2017-07-07 19:30:00	AAPL	Stock	36.06	36.065	36.04	36.065	9152.0
2017-07-07 07:30:00	MSFT	Stock	68.6	68.6	68.6	68.6	195.0
2017-07-07 08:00:00	MSFT	Stock	68.61	68.75	68.6	68.6	803.0
2017-07-07 08:30:00	MSFT	Stock	68.79	68.9	68.79	68.83	2229.0
2017-07-07 09:00:00	MSFT	Stock	68.83	68.9	68.71	68.71	25643.0
2017-07-07 09:30:00	MSFT	Stock	68.71	69.2	68.7	69.18	2032853.0
2017-07-07 10:00:00	MSFT	Stock	69.175	69.25	69.03	69.2	1046794.0
2017-07-07 10:30:00	MSFT	Stock	69.21	69.28	69.08	69.086	845245.0
2017-07-07 11:00:00	MSFT	Stock	69.09	69.33	69.042	69.26	946467.0
2017-07-07 11:30:00	MSFT	Stock	69.27	69.485	69.27	69.44	819630.0
2017-07-07 12:00:00	MSFT	Stock	69.44	69.52	69.43	69.49	644117.0
2017-07-07 12:30:00	MSFT	Stock	69.485	69.545	69.48	69.52	480274.0
2017-07-07 13:00:00	MSFT	Stock	69.52	69.76	69.513	69.755	671000.0
2017-07-07 13:30:00	MSFT	Stock	69.75	69.83	69.72	69.825	614076.0
2017-07-07 14:00:00	MSFT	Stock	69.83	69.84	69.555	69.575	895933.0
2017-07-07 14:30:00	MSFT	Stock	69.57	69.57	69.5	69.51	629521.0
2017-07-07 15:00:00	MSFT	Stock	69.505	69.52	69.42	69.51	783925.0
2017-07-07 15:30:00	MSFT	Stock	69.505	69.54	69.41	69.45	2360504.0
2017-07-07 16:00:00	MSFT	Stock	69.45	69.53	69.45	69.5	1986219.0
2017-07-07 16:30:00	MSFT	Stock	69.52	69.52	69.52	69.52	185.0
2017-07-07 17:00:00	MSFT	Stock	69.52	69.52	69.51	69.51	250.0
2017-07-07 17:30:00	MSFT	Stock	69.48	69.5	69.48	69.5	800.0

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

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