PREVIEW / stock_30min / 2015-01-09

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-09.parquet
  size:    1.6 MB
  rows:    80,965
  symbols: 3,518

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-01-09 04:00:00	AAPL	Stock	28.0975	28.0975	28.0425	28.085	8884.0
2015-01-09 04:30:00	AAPL	Stock	28.085	28.085	28.0025	28.0025	9200.0
2015-01-09 05:00:00	AAPL	Stock	28.0025	28.1	27.9925	28.0425	13776.0
2015-01-09 05:30:00	AAPL	Stock	28.0125	28.0375	28.0125	28.0375	8932.0
2015-01-09 06:00:00	AAPL	Stock	28.025	28.0625	28.0125	28.0125	17684.0
2015-01-09 06:30:00	AAPL	Stock	28.01	28.025	27.9825	27.985	41312.0
2015-01-09 07:00:00	AAPL	Stock	27.9775	27.9975	27.9625	27.975	75304.0
2015-01-09 07:30:00	AAPL	Stock	27.975	27.98	27.955	27.9725	77496.0
2015-01-09 08:00:00	AAPL	Stock	27.975	28.0375	27.96	27.975	347280.0
2015-01-09 08:30:00	AAPL	Stock	27.9975	28.15	27.9725	28.1475	874232.0
2015-01-09 09:00:00	AAPL	Stock	28.145	28.19	28.13	28.1775	593412.0
2015-01-09 09:30:00	AAPL	Stock	28.1675	28.3125	27.9575	28.06	39795332.0
2015-01-09 10:00:00	AAPL	Stock	28.06	28.1375	27.85	27.8712	19664184.0
2015-01-09 10:30:00	AAPL	Stock	27.8688	27.8865	27.67	27.84	22945752.0
2015-01-09 11:00:00	AAPL	Stock	27.8375	27.84	27.5525	27.74	16016048.0
2015-01-09 11:30:00	AAPL	Stock	27.74	27.8322	27.6875	27.785	10373264.0
2015-01-09 12:00:00	AAPL	Stock	27.785	27.9425	27.7625	27.85	10344748.0
2015-01-09 12:30:00	AAPL	Stock	27.8525	27.8848	27.7775	27.785	5275072.0
2015-01-09 13:00:00	AAPL	Stock	27.7875	27.9225	27.7675	27.8175	7135896.0
2015-01-09 13:30:00	AAPL	Stock	27.8175	27.9062	27.8175	27.8775	6112172.0
2015-01-09 14:00:00	AAPL	Stock	27.875	27.95	27.83	27.93	6257904.0
2015-01-09 14:30:00	AAPL	Stock	27.935	28.0725	27.8825	28.0625	12955420.0
2015-01-09 15:00:00	AAPL	Stock	28.0625	28.165	27.975	27.9985	16570980.0
2015-01-09 15:30:00	AAPL	Stock	27.9988	28.075	27.9525	28.0	20567792.0
2015-01-09 16:00:00	AAPL	Stock	28.0012	28.0175	27.8098	27.9975	6947088.0
2015-01-09 16:30:00	AAPL	Stock	28.0	28.0075	27.945	27.995	112828.0
2015-01-09 17:00:00	AAPL	Stock	28.0	28.005	27.8972	28.0	98860.0
2015-01-09 17:30:00	AAPL	Stock	27.9925	28.0	27.9875	27.99	48200.0
2015-01-09 18:00:00	AAPL	Stock	27.995	28.0075	27.99	27.99	63384.0
2015-01-09 18:30:00	AAPL	Stock	28.0	28.0	27.99	27.99	28424.0
2015-01-09 19:00:00	AAPL	Stock	27.9875	28.015	27.9875	28.015	36388.0
2015-01-09 19:30:00	AAPL	Stock	27.99	27.99	27.9775	27.9775	23548.0
2015-01-09 05:00:00	MSFT	Stock	47.55	47.55	47.55	47.55	100.0
2015-01-09 06:30:00	MSFT	Stock	47.51	47.51	47.45	47.45	300.0
2015-01-09 07:00:00	MSFT	Stock	47.48	47.48	47.48	47.48	300.0
2015-01-09 07:30:00	MSFT	Stock	47.49	47.49	47.46	47.46	825.0
2015-01-09 08:00:00	MSFT	Stock	47.41	47.52	47.41	47.46	8462.0
2015-01-09 08:30:00	MSFT	Stock	47.5	47.75	47.5	47.64	22465.0
2015-01-09 09:00:00	MSFT	Stock	47.63	47.64	47.58	47.58	4420.0
2015-01-09 09:30:00	MSFT	Stock	47.61	47.82	47.52	47.66	2960864.0
2015-01-09 10:00:00	MSFT	Stock	47.66	47.665	47.36	47.38	1831901.0
2015-01-09 10:30:00	MSFT	Stock	47.37	47.38	47.19	47.35	1837659.0
2015-01-09 11:00:00	MSFT	Stock	47.35	47.355	46.94	46.99	1980026.0
2015-01-09 11:30:00	MSFT	Stock	46.99	47.14	46.9	47.135	1379250.0
2015-01-09 12:00:00	MSFT	Stock	47.135	47.43	47.12	47.338	1568531.0
2015-01-09 12:30:00	MSFT	Stock	47.34	47.39	47.19	47.21	972703.0
2015-01-09 13:00:00	MSFT	Stock	47.21	47.42	47.175	47.32	969792.0
2015-01-09 13:30:00	MSFT	Stock	47.32	47.41	47.24	47.265	839641.0
2015-01-09 14:00:00	MSFT	Stock	47.26	47.3	47.14	47.27	1254467.0
2015-01-09 14:30:00	MSFT	Stock	47.261	47.39	47.17	47.37	1487788.0

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

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