PREVIEW / stock_30min / 2015-06-23

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-06-23.parquet
  size:    1.6 MB
  rows:    82,397
  symbols: 3,513

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-06-23 04:00:00	AAPL	Stock	31.96	31.965	31.91	31.91	1200.0
2015-06-23 04:30:00	AAPL	Stock	31.9325	31.9475	31.9325	31.9475	2400.0
2015-06-23 05:30:00	AAPL	Stock	31.955	31.955	31.955	31.955	400.0
2015-06-23 06:00:00	AAPL	Stock	31.955	31.955	31.935	31.935	3636.0
2015-06-23 06:30:00	AAPL	Stock	31.92	31.92	31.91	31.91	3600.0
2015-06-23 07:00:00	AAPL	Stock	31.915	31.9225	31.865	31.9025	41084.0
2015-06-23 07:30:00	AAPL	Stock	31.9	31.925	31.9	31.915	6260.0
2015-06-23 08:00:00	AAPL	Stock	31.9225	31.925	31.87	31.895	258568.0
2015-06-23 08:30:00	AAPL	Stock	31.9	31.9025	31.875	31.875	112604.0
2015-06-23 09:00:00	AAPL	Stock	31.875	31.8925	31.84	31.8625	153772.0
2015-06-23 09:30:00	AAPL	Stock	31.8575	31.885	31.7198	31.841	20760988.0
2015-06-23 10:00:00	AAPL	Stock	31.8425	31.9025	31.75	31.7695	12724556.0
2015-06-23 10:30:00	AAPL	Stock	31.769	31.8525	31.735	31.8225	10592952.0
2015-06-23 11:00:00	AAPL	Stock	31.8225	31.835	31.7725	31.79	8640232.0
2015-06-23 11:30:00	AAPL	Stock	31.79	31.84	31.7875	31.8	5747476.0
2015-06-23 12:00:00	AAPL	Stock	31.8	31.8025	31.7525	31.785	5510552.0
2015-06-23 12:30:00	AAPL	Stock	31.785	31.801	31.7625	31.765	3805124.0
2015-06-23 13:00:00	AAPL	Stock	31.765	31.8125	31.755	31.786	3980468.0
2015-06-23 13:30:00	AAPL	Stock	31.785	31.835	31.7825	31.81	3814556.0
2015-06-23 14:00:00	AAPL	Stock	31.8075	31.8475	31.8025	31.8195	3637432.0
2015-06-23 14:30:00	AAPL	Stock	31.82	31.85	31.8	31.8375	4264624.0
2015-06-23 15:00:00	AAPL	Stock	31.8362	31.8375	31.77	31.8062	5792596.0
2015-06-23 15:30:00	AAPL	Stock	31.8065	31.825	31.7525	31.755	9509308.0
2015-06-23 16:00:00	AAPL	Stock	31.7575	31.7905	31.7375	31.7625	12488692.0
2015-06-23 16:30:00	AAPL	Stock	31.7625	31.775	31.7575	31.7575	97364.0
2015-06-23 17:00:00	AAPL	Stock	31.7575	31.77	31.7375	31.75	115128.0
2015-06-23 17:30:00	AAPL	Stock	31.75	31.76	31.74	31.745	60520.0
2015-06-23 18:00:00	AAPL	Stock	31.745	31.7475	31.7375	31.7375	108704.0
2015-06-23 18:30:00	AAPL	Stock	31.7375	31.7525	31.7375	31.7425	78752.0
2015-06-23 19:00:00	AAPL	Stock	31.7575	31.7575	31.7375	31.7375	11200.0
2015-06-23 19:30:00	AAPL	Stock	31.74	31.745	31.7325	31.7375	26376.0
2015-06-23 07:30:00	MSFT	Stock	46.3	46.3	46.3	46.3	100.0
2015-06-23 08:00:00	MSFT	Stock	46.26	46.31	46.26	46.31	1150.0
2015-06-23 08:30:00	MSFT	Stock	46.35	46.35	46.25	46.25	1100.0
2015-06-23 09:00:00	MSFT	Stock	46.25	46.28	46.13	46.17	34810.0
2015-06-23 09:30:00	MSFT	Stock	46.13	46.28	45.95	46.028	2442528.0
2015-06-23 10:00:00	MSFT	Stock	46.02	46.06	45.73	45.785	1916770.0
2015-06-23 10:30:00	MSFT	Stock	45.78	45.88	45.69	45.75	1625084.0
2015-06-23 11:00:00	MSFT	Stock	45.75	46.1	45.68	45.74	2729524.0
2015-06-23 11:30:00	MSFT	Stock	45.74	45.81	45.68	45.725	1308351.0
2015-06-23 12:00:00	MSFT	Stock	45.72	45.77	45.62	45.76	1361168.0
2015-06-23 12:30:00	MSFT	Stock	45.75	45.785	45.725	45.73	1116748.0
2015-06-23 13:00:00	MSFT	Stock	45.735	45.825	45.7	45.79	830936.0
2015-06-23 13:30:00	MSFT	Stock	45.795	45.87	45.78	45.835	663065.0
2015-06-23 14:00:00	MSFT	Stock	45.84	45.85	45.77	45.84	828944.0
2015-06-23 14:30:00	MSFT	Stock	45.83	45.9	45.78	45.876	1261815.0
2015-06-23 15:00:00	MSFT	Stock	45.875	45.9	45.83	45.895	1584363.0
2015-06-23 15:30:00	MSFT	Stock	45.895	45.95	45.87	45.9	2495798.0
2015-06-23 16:00:00	MSFT	Stock	45.91	45.98	45.85	45.85	3554971.0
2015-06-23 16:30:00	MSFT	Stock	45.91	45.91	45.9	45.9	6700.0

> showing 50 of 82,397 rows — these rows as CSV

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