PREVIEW / stock_30min / 2016-03-09

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-03-09.parquet
  size:    1.5 MB
  rows:    81,194
  symbols: 3,335

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-03-09 04:00:00	AAPL	Stock	25.37	25.4275	25.37	25.385	3156.0
2016-03-09 05:00:00	AAPL	Stock	25.3875	25.43	25.1325	25.43	10124.0
2016-03-09 05:30:00	AAPL	Stock	25.4	25.4	25.4	25.4	1200.0
2016-03-09 06:00:00	AAPL	Stock	25.3975	25.405	25.3825	25.3825	19064.0
2016-03-09 06:30:00	AAPL	Stock	25.3975	25.4125	25.375	25.3975	14080.0
2016-03-09 07:00:00	AAPL	Stock	25.4	25.4825	25.4	25.4375	66476.0
2016-03-09 07:30:00	AAPL	Stock	25.4375	25.4375	25.3825	25.3825	18860.0
2016-03-09 08:00:00	AAPL	Stock	25.385	25.475	25.3775	25.405	95616.0
2016-03-09 08:30:00	AAPL	Stock	25.4	25.4175	25.35	25.375	104012.0
2016-03-09 09:00:00	AAPL	Stock	25.375	25.42	25.33	25.335	160988.0
2016-03-09 09:30:00	AAPL	Stock	25.335	25.395	25.0675	25.1625	18174400.0
2016-03-09 10:00:00	AAPL	Stock	25.1625	25.27	25.1575	25.225	9327336.0
2016-03-09 10:30:00	AAPL	Stock	25.225	25.3375	25.1625	25.2032	8200036.0
2016-03-09 11:00:00	AAPL	Stock	25.205	25.306	25.1975	25.305	6789136.0
2016-03-09 11:30:00	AAPL	Stock	25.3075	25.3575	25.2638	25.3175	5928604.0
2016-03-09 12:00:00	AAPL	Stock	25.315	25.325	25.26	25.3025	3803260.0
2016-03-09 12:30:00	AAPL	Stock	25.305	25.31	25.2175	25.28	5067704.0
2016-03-09 13:00:00	AAPL	Stock	25.275	25.28	25.196	25.2275	3426268.0
2016-03-09 13:30:00	AAPL	Stock	25.2275	25.325	25.2225	25.3075	4414028.0
2016-03-09 14:00:00	AAPL	Stock	25.31	25.3275	25.25	25.2975	4725972.0
2016-03-09 14:30:00	AAPL	Stock	25.295	25.2975	25.205	25.2462	4524236.0
2016-03-09 15:00:00	AAPL	Stock	25.2475	25.2725	25.2025	25.2575	5825596.0
2016-03-09 15:30:00	AAPL	Stock	25.2538	25.2875	25.22	25.2775	10321824.0
2016-03-09 16:00:00	AAPL	Stock	25.28	25.28	25.233	25.2775	7784132.0
2016-03-09 16:30:00	AAPL	Stock	25.275	25.2875	25.275	25.2875	45568.0
2016-03-09 17:00:00	AAPL	Stock	25.28	25.29	25.2775	25.29	8232.0
2016-03-09 17:30:00	AAPL	Stock	25.28	25.2825	25.2775	25.2825	2400.0
2016-03-09 18:00:00	AAPL	Stock	25.2825	25.29	25.2825	25.29	15108.0
2016-03-09 18:30:00	AAPL	Stock	25.2825	25.2825	25.28	25.2825	2600.0
2016-03-09 19:00:00	AAPL	Stock	25.295	25.295	25.2825	25.295	11640.0
2016-03-09 19:30:00	AAPL	Stock	25.2875	25.295	25.28	25.295	38404.0
2016-03-09 04:00:00	MSFT	Stock	50.49	52.01	50.49	52.01	440.0
2016-03-09 06:30:00	MSFT	Stock	51.99	51.99	51.99	51.99	100.0
2016-03-09 07:00:00	MSFT	Stock	51.99	52.0	51.99	52.0	1100.0
2016-03-09 08:00:00	MSFT	Stock	52.15	52.15	51.92	51.92	1315.0
2016-03-09 08:30:00	MSFT	Stock	51.98	51.98	51.98	51.98	500.0
2016-03-09 09:00:00	MSFT	Stock	51.98	52.07	51.9	51.9	4040.0
2016-03-09 09:30:00	MSFT	Stock	51.9	52.22	51.855	52.155	2135365.0
2016-03-09 10:00:00	MSFT	Stock	52.14	52.41	52.04	52.355	1907406.0
2016-03-09 10:30:00	MSFT	Stock	52.36	52.64	52.27	52.295	2408147.0
2016-03-09 11:00:00	MSFT	Stock	52.29	52.69	52.29	52.6	1634090.0
2016-03-09 11:30:00	MSFT	Stock	52.6	52.77	52.6	52.684	1609885.0
2016-03-09 12:00:00	MSFT	Stock	52.68	52.72	52.6	52.68	1157655.0
2016-03-09 12:30:00	MSFT	Stock	52.68	52.72	52.5	52.54	1121064.0
2016-03-09 13:00:00	MSFT	Stock	52.54	52.63	52.39	52.42	920111.0
2016-03-09 13:30:00	MSFT	Stock	52.43	52.674	52.422	52.63	1531468.0
2016-03-09 14:00:00	MSFT	Stock	52.62	52.84	52.61	52.825	1383787.0
2016-03-09 14:30:00	MSFT	Stock	52.82	52.835	52.65	52.79	1876768.0
2016-03-09 15:00:00	MSFT	Stock	52.79	52.798	52.56	52.685	1552019.0
2016-03-09 15:30:00	MSFT	Stock	52.685	52.85	52.625	52.83	4108389.0

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

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