PREVIEW / stock_30min / 2015-10-30

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-10-30.parquet
  size:    1.6 MB
  rows:    81,307
  symbols: 3,427

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-10-30 04:00:00	AAPL	Stock	30.235	30.25	30.2	30.2	15036.0
2015-10-30 04:30:00	AAPL	Stock	30.225	30.2475	30.2125	30.2175	4172.0
2015-10-30 05:00:00	AAPL	Stock	30.22	30.22	30.1875	30.1875	11284.0
2015-10-30 05:30:00	AAPL	Stock	30.175	30.1875	30.175	30.175	6756.0
2015-10-30 06:00:00	AAPL	Stock	30.175	30.175	30.145	30.155	14360.0
2015-10-30 06:30:00	AAPL	Stock	30.155	30.155	30.1	30.1475	11496.0
2015-10-30 07:00:00	AAPL	Stock	30.13	30.145	30.1225	30.145	7280.0
2015-10-30 07:30:00	AAPL	Stock	30.15	30.19	30.15	30.19	41044.0
2015-10-30 08:00:00	AAPL	Stock	30.145	30.325	30.11	30.2825	705780.0
2015-10-30 08:30:00	AAPL	Stock	30.2875	30.3375	30.26	30.3175	454896.0
2015-10-30 09:00:00	AAPL	Stock	30.3175	30.325	30.245	30.26	900172.0
2015-10-30 09:30:00	AAPL	Stock	30.2475	30.305	30.115	30.2325	28197384.0
2015-10-30 10:00:00	AAPL	Stock	30.2312	30.2825	30.14	30.2075	16306964.0
2015-10-30 10:30:00	AAPL	Stock	30.2088	30.245	30.1	30.1425	13851912.0
2015-10-30 11:00:00	AAPL	Stock	30.145	30.1525	29.975	30.01	15019452.0
2015-10-30 11:30:00	AAPL	Stock	30.0088	30.0962	30.0025	30.0838	10598720.0
2015-10-30 12:00:00	AAPL	Stock	30.0825	30.155	30.0175	30.1205	8562504.0
2015-10-30 12:30:00	AAPL	Stock	30.1225	30.195	30.12	30.1675	7889808.0
2015-10-30 13:00:00	AAPL	Stock	30.1662	30.1725	30.07	30.09	6950676.0
2015-10-30 13:30:00	AAPL	Stock	30.0912	30.145	30.0688	30.1012	7629692.0
2015-10-30 14:00:00	AAPL	Stock	30.1012	30.1212	29.9775	29.99	8581036.0
2015-10-30 14:30:00	AAPL	Stock	29.99	30.04	29.895	29.905	11018520.0
2015-10-30 15:00:00	AAPL	Stock	29.9048	29.9825	29.8625	29.9	10454892.0
2015-10-30 15:30:00	AAPL	Stock	29.9	30.025	29.875	29.8762	22845624.0
2015-10-30 16:00:00	AAPL	Stock	29.875	29.9375	29.8725	29.9125	13976828.0
2015-10-30 16:30:00	AAPL	Stock	29.9125	29.9125	29.765	29.825	1620260.0
2015-10-30 17:00:00	AAPL	Stock	29.8225	29.865	29.8075	29.83	72864.0
2015-10-30 17:30:00	AAPL	Stock	29.83	29.8525	29.82	29.835	31320.0
2015-10-30 18:00:00	AAPL	Stock	29.835	29.8375	29.8125	29.8125	31672.0
2015-10-30 18:30:00	AAPL	Stock	29.8125	29.835	29.8	29.82	39800.0
2015-10-30 19:00:00	AAPL	Stock	29.83	29.835	29.82	29.835	23616.0
2015-10-30 19:30:00	AAPL	Stock	29.82	29.835	29.81	29.82	71832.0
2015-10-30 04:00:00	MSFT	Stock	53.6	53.6	53.55	53.55	980.0
2015-10-30 04:30:00	MSFT	Stock	53.55	53.55	53.55	53.55	400.0
2015-10-30 07:30:00	MSFT	Stock	53.47	53.47	53.47	53.47	100.0
2015-10-30 08:00:00	MSFT	Stock	53.47	53.49	53.4	53.45	1847.0
2015-10-30 08:30:00	MSFT	Stock	53.5	53.5	53.42	53.42	3220.0
2015-10-30 09:00:00	MSFT	Stock	53.4	53.4	53.29	53.29	6060.0
2015-10-30 09:30:00	MSFT	Stock	53.32	53.59	53.15	53.59	2613728.0
2015-10-30 10:00:00	MSFT	Stock	53.58	53.87	53.55	53.865	2554116.0
2015-10-30 10:30:00	MSFT	Stock	53.865	53.945	53.77	53.85	2141481.0
2015-10-30 11:00:00	MSFT	Stock	53.86	53.93	53.75	53.924	2584073.0
2015-10-30 11:30:00	MSFT	Stock	53.92	53.99	53.84	53.88	2128532.0
2015-10-30 12:00:00	MSFT	Stock	53.88	53.89	53.595	53.663	2654426.0
2015-10-30 12:30:00	MSFT	Stock	53.665	53.71	53.47	53.5	2318509.0
2015-10-30 13:00:00	MSFT	Stock	53.5	53.53	53.38	53.39	1698496.0
2015-10-30 13:30:00	MSFT	Stock	53.4	53.46	53.32	53.38	1592935.0
2015-10-30 14:00:00	MSFT	Stock	53.375	53.42	53.12	53.15	2067882.0
2015-10-30 14:30:00	MSFT	Stock	53.14	53.16	52.91	52.93	3306091.0
2015-10-30 15:00:00	MSFT	Stock	52.93	53.016	52.81	52.83	3909481.0

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

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