PREVIEW / stock_30min / 2015-01-22

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-22.parquet
  size:    1.6 MB
  rows:    83,267
  symbols: 3,528

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-01-22 04:30:00	AAPL	Stock	27.46	27.48	27.4	27.4	8160.0
2015-01-22 05:00:00	AAPL	Stock	27.48	27.48	27.48	27.48	2400.0
2015-01-22 05:30:00	AAPL	Stock	27.4675	27.4675	27.4675	27.4675	400.0
2015-01-22 06:00:00	AAPL	Stock	27.4375	27.44	27.3	27.3	16580.0
2015-01-22 06:30:00	AAPL	Stock	27.3775	27.3975	27.375	27.3975	10736.0
2015-01-22 07:00:00	AAPL	Stock	27.3975	27.445	27.35	27.425	126984.0
2015-01-22 07:30:00	AAPL	Stock	27.4375	27.5075	27.4275	27.5	109568.0
2015-01-22 08:00:00	AAPL	Stock	27.5	27.525	27.375	27.5	389292.0
2015-01-22 08:30:00	AAPL	Stock	27.5	27.6	27.4375	27.5075	763176.0
2015-01-22 09:00:00	AAPL	Stock	27.5225	27.5825	27.45	27.5825	517948.0
2015-01-22 09:30:00	AAPL	Stock	27.5825	27.755	27.43	27.5428	30886952.0
2015-01-22 10:00:00	AAPL	Stock	27.545	27.675	27.5375	27.5925	15770668.0
2015-01-22 10:30:00	AAPL	Stock	27.6038	27.83	27.58	27.8125	16012584.0
2015-01-22 11:00:00	AAPL	Stock	27.8125	27.87	27.7475	27.8675	12731100.0
2015-01-22 11:30:00	AAPL	Stock	27.8675	27.9175	27.8325	27.8875	12282768.0
2015-01-22 12:00:00	AAPL	Stock	27.8875	27.9175	27.7925	27.9025	9280840.0
2015-01-22 12:30:00	AAPL	Stock	27.9025	27.9075	27.7825	27.824	6059852.0
2015-01-22 13:00:00	AAPL	Stock	27.8228	27.85	27.7775	27.7965	4340544.0
2015-01-22 13:30:00	AAPL	Stock	27.795	27.869	27.795	27.868	5255928.0
2015-01-22 14:00:00	AAPL	Stock	27.87	27.9225	27.84	27.9025	6847148.0
2015-01-22 14:30:00	AAPL	Stock	27.9025	27.995	27.8925	27.971	9753708.0
2015-01-22 15:00:00	AAPL	Stock	27.9725	28.1175	27.96	28.0325	17691340.0
2015-01-22 15:30:00	AAPL	Stock	28.0325	28.1025	28.01	28.0975	17748844.0
2015-01-22 16:00:00	AAPL	Stock	28.1	28.1075	27.8098	28.1	23290072.0
2015-01-22 16:30:00	AAPL	Stock	28.0975	28.1	27.8225	28.09	159576.0
2015-01-22 17:00:00	AAPL	Stock	28.0975	28.1	28.0875	28.1	473600.0
2015-01-22 17:30:00	AAPL	Stock	28.095	28.0975	28.0875	28.095	42816.0
2015-01-22 18:00:00	AAPL	Stock	28.0975	28.1	28.08	28.0825	40024.0
2015-01-22 18:30:00	AAPL	Stock	28.0825	28.0875	28.025	28.05	50360.0
2015-01-22 19:00:00	AAPL	Stock	28.05	28.0625	28.04	28.04	31992.0
2015-01-22 19:30:00	AAPL	Stock	28.04	28.07	28.0325	28.0525	75208.0
2015-01-22 04:00:00	MSFT	Stock	46.12	46.12	46.12	46.12	100.0
2015-01-22 04:30:00	MSFT	Stock	46.14	46.25	46.14	46.14	760.0
2015-01-22 06:00:00	MSFT	Stock	46.15	46.15	46.14	46.14	200.0
2015-01-22 07:00:00	MSFT	Stock	46.15	46.15	46.12	46.15	760.0
2015-01-22 07:30:00	MSFT	Stock	46.09	46.24	46.09	46.15	2300.0
2015-01-22 08:00:00	MSFT	Stock	46.1	46.24	46.09	46.24	8585.0
2015-01-22 08:30:00	MSFT	Stock	46.22	46.44	46.09	46.2	25665.0
2015-01-22 09:00:00	MSFT	Stock	46.2	46.44	46.18	46.4	33279.0
2015-01-22 09:30:00	MSFT	Stock	46.38	46.7	46.08	46.395	6372281.0
2015-01-22 10:00:00	MSFT	Stock	46.4	46.57	46.244	46.415	3027440.0
2015-01-22 10:30:00	MSFT	Stock	46.42	46.789	46.4	46.77	3062311.0
2015-01-22 11:00:00	MSFT	Stock	46.77	46.97	46.65	46.955	2542532.0
2015-01-22 11:30:00	MSFT	Stock	46.96	46.99	46.725	46.805	1214511.0
2015-01-22 12:00:00	MSFT	Stock	46.8	46.82	46.64	46.75	1111386.0
2015-01-22 12:30:00	MSFT	Stock	46.745	46.76	46.61	46.655	1052064.0
2015-01-22 13:00:00	MSFT	Stock	46.656	46.75	46.53	46.56	831384.0
2015-01-22 13:30:00	MSFT	Stock	46.563	46.68	46.53	46.64	1021874.0
2015-01-22 14:00:00	MSFT	Stock	46.64	46.72	46.58	46.67	1025329.0
2015-01-22 14:30:00	MSFT	Stock	46.675	47.04	46.66	46.99	1796749.0

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

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