PREVIEW / stock_30min / 2015-05-07

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-05-07.parquet
  size:    1.6 MB
  rows:    84,858
  symbols: 3,510

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-05-07 04:00:00	AAPL	Stock	31.995	31.995	31.125	31.125	18584.0
2015-05-07 04:30:00	AAPL	Stock	31.075	31.075	30.925	30.9725	38000.0
2015-05-07 05:00:00	AAPL	Stock	30.9575	30.9725	30.815	30.895	37576.0
2015-05-07 05:30:00	AAPL	Stock	30.88	30.9375	30.875	30.875	17884.0
2015-05-07 06:00:00	AAPL	Stock	31.0	31.045	30.925	30.9725	42516.0
2015-05-07 06:30:00	AAPL	Stock	30.9325	30.9725	30.85	30.915	76092.0
2015-05-07 07:00:00	AAPL	Stock	30.935	31.0725	30.91	31.0275	126444.0
2015-05-07 07:30:00	AAPL	Stock	31.0325	31.1475	31.025	31.1475	174568.0
2015-05-07 08:00:00	AAPL	Stock	31.1475	31.225	30.91	31.16	468072.0
2015-05-07 08:30:00	AAPL	Stock	31.1525	31.1575	31.0975	31.1275	356756.0
2015-05-07 09:00:00	AAPL	Stock	31.1225	31.19	31.1	31.19	467672.0
2015-05-07 09:30:00	AAPL	Stock	31.19	31.36	31.005	31.1675	28273248.0
2015-05-07 10:00:00	AAPL	Stock	31.165	31.35	31.0875	31.2275	16426904.0
2015-05-07 10:30:00	AAPL	Stock	31.225	31.4	31.1475	31.295	15766944.0
2015-05-07 11:00:00	AAPL	Stock	31.295	31.355	31.23	31.325	10424120.0
2015-05-07 11:30:00	AAPL	Stock	31.325	31.3575	31.2655	31.295	6191932.0
2015-05-07 12:00:00	AAPL	Stock	31.29	31.46	31.268	31.4512	7749096.0
2015-05-07 12:30:00	AAPL	Stock	31.4525	31.52	31.41	31.4775	9814180.0
2015-05-07 13:00:00	AAPL	Stock	31.4825	31.515	31.3475	31.375	9195444.0
2015-05-07 13:30:00	AAPL	Stock	31.3775	31.44	31.3175	31.3302	8560996.0
2015-05-07 14:00:00	AAPL	Stock	31.3325	31.48	31.3325	31.4525	7311904.0
2015-05-07 14:30:00	AAPL	Stock	31.4525	31.4825	31.405	31.4475	5949068.0
2015-05-07 15:00:00	AAPL	Stock	31.445	31.465	31.3325	31.375	8970572.0
2015-05-07 15:30:00	AAPL	Stock	31.375	31.38	31.285	31.3125	14422144.0
2015-05-07 16:00:00	AAPL	Stock	31.315	31.335	31.3025	31.3125	6166108.0
2015-05-07 16:30:00	AAPL	Stock	31.3125	31.344	31.3	31.31	87772.0
2015-05-07 17:00:00	AAPL	Stock	31.3075	31.3175	31.3	31.3175	63332.0
2015-05-07 17:30:00	AAPL	Stock	31.315	31.3275	31.315	31.3175	46900.0
2015-05-07 18:00:00	AAPL	Stock	31.32	31.33	31.3175	31.325	47852.0
2015-05-07 18:30:00	AAPL	Stock	31.3275	31.335	31.3275	31.33	41772.0
2015-05-07 19:00:00	AAPL	Stock	31.33	31.355	31.33	31.3325	37568.0
2015-05-07 19:30:00	AAPL	Stock	31.3425	31.3425	31.325	31.335	46004.0
2015-05-07 04:00:00	MSFT	Stock	46.13	46.13	46.13	46.13	100.0
2015-05-07 05:00:00	MSFT	Stock	46.0	46.0	45.69	45.69	4113.0
2015-05-07 05:30:00	MSFT	Stock	45.79	45.86	45.79	45.86	1176.0
2015-05-07 06:00:00	MSFT	Stock	45.89	46.11	45.89	45.99	5047.0
2015-05-07 06:30:00	MSFT	Stock	46.0	46.0	45.98	45.98	430.0
2015-05-07 07:00:00	MSFT	Stock	46.0	46.09	45.98	46.08	3000.0
2015-05-07 07:30:00	MSFT	Stock	46.13	46.14	46.13	46.14	1500.0
2015-05-07 08:00:00	MSFT	Stock	46.1	46.28	46.1	46.17	6880.0
2015-05-07 08:30:00	MSFT	Stock	46.17	46.17	46.0	46.03	2515.0
2015-05-07 09:00:00	MSFT	Stock	46.07	46.3	46.07	46.3	28698.0
2015-05-07 09:30:00	MSFT	Stock	46.27	46.85	46.16	46.67	4220090.0
2015-05-07 10:00:00	MSFT	Stock	46.66	46.94	46.625	46.78	2736405.0
2015-05-07 10:30:00	MSFT	Stock	46.77	46.877	46.685	46.83	2138539.0
2015-05-07 11:00:00	MSFT	Stock	46.84	46.93	46.7	46.92	1513819.0
2015-05-07 11:30:00	MSFT	Stock	46.92	46.94	46.76	46.81	1173361.0
2015-05-07 12:00:00	MSFT	Stock	46.81	47.085	46.78	47.01	1427157.0
2015-05-07 12:30:00	MSFT	Stock	47.015	47.079	46.94	46.94	1323711.0
2015-05-07 13:00:00	MSFT	Stock	46.94	46.97	46.745	46.815	1959746.0

> showing 50 of 84,858 rows — these rows as CSV

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