PREVIEW / stock_30min / 2017-04-04

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-04-04.parquet
  size:    1.6 MB
  rows:    82,072
  symbols: 3,051

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
2017-04-04 04:00:00	AAPL	Stock	35.8375	35.8975	35.8275	35.8975	7028.0
2017-04-04 05:00:00	AAPL	Stock	35.8975	35.8975	35.8975	35.8975	1600.0
2017-04-04 05:30:00	AAPL	Stock	35.9025	35.9025	35.885	35.895	4812.0
2017-04-04 06:00:00	AAPL	Stock	35.8875	35.8875	35.885	35.885	1560.0
2017-04-04 06:30:00	AAPL	Stock	35.885	35.885	35.875	35.875	2592.0
2017-04-04 07:00:00	AAPL	Stock	35.875	35.875	35.85	35.85	17248.0
2017-04-04 07:30:00	AAPL	Stock	35.845	35.845	35.8	35.8125	27568.0
2017-04-04 08:00:00	AAPL	Stock	35.85	35.85	35.8025	35.82	61216.0
2017-04-04 08:30:00	AAPL	Stock	35.825	35.84	35.8175	35.825	89280.0
2017-04-04 09:00:00	AAPL	Stock	35.825	35.8375	35.8	35.815	109116.0
2017-04-04 09:30:00	AAPL	Stock	35.8125	35.9875	35.7925	35.9225	10084496.0
2017-04-04 10:00:00	AAPL	Stock	35.92	36.019	35.855	36.0175	6129632.0
2017-04-04 10:30:00	AAPL	Stock	36.02	36.0575	35.97	36.0112	7028556.0
2017-04-04 11:00:00	AAPL	Stock	36.01	36.12	36.0	36.08	6814980.0
2017-04-04 11:30:00	AAPL	Stock	36.08	36.12	36.0575	36.0675	4549516.0
2017-04-04 12:00:00	AAPL	Stock	36.0675	36.1075	36.0325	36.0782	2634992.0
2017-04-04 12:30:00	AAPL	Stock	36.0788	36.08	36.01	36.035	2571432.0
2017-04-04 13:00:00	AAPL	Stock	36.0362	36.0875	36.0075	36.0588	2700800.0
2017-04-04 13:30:00	AAPL	Stock	36.06	36.1	36.0588	36.0925	2078584.0
2017-04-04 14:00:00	AAPL	Stock	36.095	36.2125	36.0925	36.1765	6911244.0
2017-04-04 14:30:00	AAPL	Stock	36.175	36.2225	36.149	36.1525	4068416.0
2017-04-04 15:00:00	AAPL	Stock	36.15	36.175	36.13	36.1575	3869328.0
2017-04-04 15:30:00	AAPL	Stock	36.1575	36.215	36.1575	36.19	7991988.0
2017-04-04 16:00:00	AAPL	Stock	36.1925	36.22	36.0483	36.1925	3717556.0
2017-04-04 16:30:00	AAPL	Stock	36.1925	36.22	36.1925	36.22	4876.0
2017-04-04 17:00:00	AAPL	Stock	36.195	36.22	36.195	36.2125	5280.0
2017-04-04 17:30:00	AAPL	Stock	36.2125	36.2175	36.2025	36.2025	2000.0
2017-04-04 18:00:00	AAPL	Stock	36.205	36.2175	36.205	36.205	5400.0
2017-04-04 18:30:00	AAPL	Stock	36.205	36.205	36.2025	36.2025	20200.0
2017-04-04 19:00:00	AAPL	Stock	36.2175	36.2175	36.2025	36.21	7448.0
2017-04-04 19:30:00	AAPL	Stock	36.205	36.22	36.2025	36.2175	14736.0
2017-04-04 06:00:00	MSFT	Stock	65.39	65.4	65.39	65.4	3323.0
2017-04-04 07:30:00	MSFT	Stock	65.35	65.35	65.32	65.32	2600.0
2017-04-04 08:00:00	MSFT	Stock	65.26	65.55	65.11	65.55	33442.0
2017-04-04 08:30:00	MSFT	Stock	65.28	65.28	65.25	65.25	598.0
2017-04-04 09:00:00	MSFT	Stock	65.25	65.35	65.25	65.35	1626.0
2017-04-04 09:30:00	MSFT	Stock	65.39	65.66	65.28	65.535	1934133.0
2017-04-04 10:00:00	MSFT	Stock	65.535	65.6	65.39	65.541	863585.0
2017-04-04 10:30:00	MSFT	Stock	65.55	65.64	65.445	65.51	774816.0
2017-04-04 11:00:00	MSFT	Stock	65.52	65.73	65.49	65.66	706839.0
2017-04-04 11:30:00	MSFT	Stock	65.66	65.75	65.64	65.66	659012.0
2017-04-04 12:00:00	MSFT	Stock	65.65	65.67	65.59	65.635	602500.0
2017-04-04 12:30:00	MSFT	Stock	65.638	65.65	65.531	65.55	445145.0
2017-04-04 13:00:00	MSFT	Stock	65.555	65.63	65.5	65.53	460245.0
2017-04-04 13:30:00	MSFT	Stock	65.535	65.61	65.52	65.59	384377.0
2017-04-04 14:00:00	MSFT	Stock	65.595	65.75	65.59	65.75	563482.0
2017-04-04 14:30:00	MSFT	Stock	65.74	65.81	65.715	65.725	779667.0
2017-04-04 15:00:00	MSFT	Stock	65.72	65.76	65.68	65.7	712663.0
2017-04-04 15:30:00	MSFT	Stock	65.7	65.8	65.695	65.73	1515664.0
2017-04-04 16:00:00	MSFT	Stock	65.74	65.74	65.73	65.73	1159394.0

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

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