PREVIEW / stock_30min / 2015-03-31

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-03-31.parquet
  size:    1.6 MB
  rows:    83,448
  symbols: 3,526

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-03-31 04:00:00	AAPL	Stock	31.5875	31.5875	31.565	31.5875	4208.0
2015-03-31 04:30:00	AAPL	Stock	31.5875	31.6	31.5875	31.6	4800.0
2015-03-31 06:00:00	AAPL	Stock	31.5225	31.5225	31.3775	31.47	16436.0
2015-03-31 06:30:00	AAPL	Stock	31.4625	31.5	31.45	31.47	22784.0
2015-03-31 07:00:00	AAPL	Stock	31.47	31.475	31.4275	31.4475	59712.0
2015-03-31 07:30:00	AAPL	Stock	31.4725	31.475	31.445	31.45	89568.0
2015-03-31 08:00:00	AAPL	Stock	31.4475	31.5	31.4225	31.4725	592376.0
2015-03-31 08:30:00	AAPL	Stock	31.465	31.55	31.465	31.5125	273756.0
2015-03-31 09:00:00	AAPL	Stock	31.515	31.5375	31.4925	31.5175	365040.0
2015-03-31 09:30:00	AAPL	Stock	31.5225	31.6225	31.3	31.4125	25714592.0
2015-03-31 10:00:00	AAPL	Stock	31.4075	31.46	31.255	31.325	16275920.0
2015-03-31 10:30:00	AAPL	Stock	31.3225	31.35	31.2325	31.25	10488004.0
2015-03-31 11:00:00	AAPL	Stock	31.2475	31.4125	31.2475	31.385	9484748.0
2015-03-31 11:30:00	AAPL	Stock	31.3875	31.3925	31.2425	31.2675	9808284.0
2015-03-31 12:00:00	AAPL	Stock	31.2675	31.333	31.245	31.2975	5014116.0
2015-03-31 12:30:00	AAPL	Stock	31.3025	31.3375	31.265	31.3	4610896.0
2015-03-31 13:00:00	AAPL	Stock	31.3025	31.35	31.3	31.325	4928808.0
2015-03-31 13:30:00	AAPL	Stock	31.325	31.38	31.3075	31.33	4736704.0
2015-03-31 14:00:00	AAPL	Stock	31.3275	31.38	31.3175	31.34	4329640.0
2015-03-31 14:30:00	AAPL	Stock	31.34	31.375	31.2875	31.3375	5878376.0
2015-03-31 15:00:00	AAPL	Stock	31.3362	31.3375	31.105	31.1542	16002436.0
2015-03-31 15:30:00	AAPL	Stock	31.155	31.215	31.0888	31.1125	21571168.0
2015-03-31 16:00:00	AAPL	Stock	31.12	31.2955	31.1055	31.12	15361472.0
2015-03-31 16:30:00	AAPL	Stock	31.12	31.308	31.1058	31.2922	584772.0
2015-03-31 17:00:00	AAPL	Stock	31.1175	31.125	31.1125	31.12	70176.0
2015-03-31 17:30:00	AAPL	Stock	31.1175	31.125	31.1125	31.1225	32220.0
2015-03-31 18:00:00	AAPL	Stock	31.1248	31.1325	31.115	31.1275	56684.0
2015-03-31 18:30:00	AAPL	Stock	31.1425	31.17	31.1175	31.1175	74660.0
2015-03-31 19:00:00	AAPL	Stock	31.13	31.1325	31.1125	31.12	42192.0
2015-03-31 19:30:00	AAPL	Stock	31.13	31.1425	31.12	31.1325	62584.0
2015-03-31 04:00:00	MSFT	Stock	40.9	40.9	40.85	40.85	698.0
2015-03-31 07:00:00	MSFT	Stock	40.68	40.68	40.59	40.59	1000.0
2015-03-31 07:30:00	MSFT	Stock	40.69	40.75	40.68	40.68	1700.0
2015-03-31 08:00:00	MSFT	Stock	40.76	40.78	40.67	40.76	7750.0
2015-03-31 08:30:00	MSFT	Stock	40.71	40.84	40.71	40.83	10215.0
2015-03-31 09:00:00	MSFT	Stock	40.83	40.84	40.68	40.78	99100.0
2015-03-31 09:30:00	MSFT	Stock	40.78	40.94	40.56	40.616	4440210.0
2015-03-31 10:00:00	MSFT	Stock	40.61	40.8	40.58	40.775	2316907.0
2015-03-31 10:30:00	MSFT	Stock	40.78	40.83	40.71	40.76	1623075.0
2015-03-31 11:00:00	MSFT	Stock	40.77	40.82	40.68	40.69	1926336.0
2015-03-31 11:30:00	MSFT	Stock	40.69	40.7	40.58	40.59	2499761.0
2015-03-31 12:00:00	MSFT	Stock	40.59	40.7	40.54	40.7	1773624.0
2015-03-31 12:30:00	MSFT	Stock	40.695	40.77	40.66	40.745	1431469.0
2015-03-31 13:00:00	MSFT	Stock	40.742	40.94	40.73	40.93	1255666.0
2015-03-31 13:30:00	MSFT	Stock	40.93	40.99	40.82	40.845	1623098.0
2015-03-31 14:00:00	MSFT	Stock	40.84	40.98	40.83	40.914	1054653.0
2015-03-31 14:30:00	MSFT	Stock	40.915	41.03	40.89	41.03	985077.0
2015-03-31 15:00:00	MSFT	Stock	41.025	41.025	40.65	40.71	2619292.0
2015-03-31 15:30:00	MSFT	Stock	40.71	40.78	40.63	40.65	4638692.0
2015-03-31 16:00:00	MSFT	Stock	40.655	40.767	40.6	40.67	5087445.0

> showing 50 of 83,448 rows — these rows as CSV

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