PREVIEW / stock_30min / 2018-08-01

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-01.parquet
  size:    1.7 MB
  rows:    83,300
  symbols: 2,799

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
2018-08-01 04:00:00	AAPL	Stock	49.3225	49.4725	49.3025	49.325	80324.0
2018-08-01 04:30:00	AAPL	Stock	49.325	49.325	49.1775	49.25	88312.0
2018-08-01 05:00:00	AAPL	Stock	49.19	49.3	49.19	49.27	20684.0
2018-08-01 05:30:00	AAPL	Stock	49.275	49.3	49.2125	49.2375	47288.0
2018-08-01 06:00:00	AAPL	Stock	49.2175	49.3	49.1625	49.3	88996.0
2018-08-01 06:30:00	AAPL	Stock	49.3225	49.45	49.3	49.375	168336.0
2018-08-01 07:00:00	AAPL	Stock	49.3875	49.5425	49.375	49.54	422980.0
2018-08-01 07:30:00	AAPL	Stock	49.54	49.745	49.4275	49.7125	632592.0
2018-08-01 08:00:00	AAPL	Stock	49.425	49.85	49.375	49.6475	1727320.0
2018-08-01 08:30:00	AAPL	Stock	49.6475	49.6875	49.4525	49.6875	2204452.0
2018-08-01 09:00:00	AAPL	Stock	49.6825	49.8975	49.5875	49.7875	4107700.0
2018-08-01 09:30:00	AAPL	Stock	49.7825	49.815	49.3275	49.6825	44178388.0
2018-08-01 10:00:00	AAPL	Stock	49.6825	49.948	49.48	49.9025	25678360.0
2018-08-01 10:30:00	AAPL	Stock	49.9025	50.33	49.9	50.1125	34908872.0
2018-08-01 11:00:00	AAPL	Stock	50.114	50.225	50.0	50.22	15657864.0
2018-08-01 11:30:00	AAPL	Stock	50.22	50.2225	49.8175	49.9825	16248000.0
2018-08-01 12:00:00	AAPL	Stock	49.9825	50.1925	49.9345	50.0075	10856256.0
2018-08-01 12:30:00	AAPL	Stock	50.0025	50.115	49.97	50.0388	7336512.0
2018-08-01 13:00:00	AAPL	Stock	50.0375	50.25	50.03	50.13	7117892.0
2018-08-01 13:30:00	AAPL	Stock	50.134	50.17	49.9625	50.02	6092808.0
2018-08-01 14:00:00	AAPL	Stock	50.025	50.1375	49.8925	50.1105	8645008.0
2018-08-01 14:30:00	AAPL	Stock	50.1075	50.1375	49.975	50.0525	6094808.0
2018-08-01 15:00:00	AAPL	Stock	50.05	50.2125	50.005	50.205	7725352.0
2018-08-01 15:30:00	AAPL	Stock	50.205	50.44	50.165	50.405	29944432.0
2018-08-01 16:00:00	AAPL	Stock	50.405	50.48	50.35	50.4	12409340.0
2018-08-01 16:30:00	AAPL	Stock	50.4	50.4625	50.2728	50.41	386752.0
2018-08-01 17:00:00	AAPL	Stock	50.4125	50.45	50.375	50.4475	165980.0
2018-08-01 17:30:00	AAPL	Stock	50.4475	50.4475	50.4	50.4175	70572.0
2018-08-01 18:00:00	AAPL	Stock	50.425	50.4375	50.4	50.4125	65624.0
2018-08-01 18:30:00	AAPL	Stock	50.4	50.4025	50.38	50.3975	105472.0
2018-08-01 19:00:00	AAPL	Stock	50.39	50.3975	50.325	50.325	85692.0
2018-08-01 19:30:00	AAPL	Stock	50.325	50.4325	50.2875	50.4175	123760.0
2018-08-01 04:00:00	MSFT	Stock	106.0	106.09	106.0	106.09	2984.0
2018-08-01 05:00:00	MSFT	Stock	106.0	106.0	105.99	105.99	2580.0
2018-08-01 05:30:00	MSFT	Stock	105.9	105.9	105.55	105.55	1200.0
2018-08-01 06:30:00	MSFT	Stock	106.0	106.08	106.0	106.0	3016.0
2018-08-01 07:00:00	MSFT	Stock	105.98	105.98	105.72	105.8	6703.0
2018-08-01 07:30:00	MSFT	Stock	105.81	105.9	105.65	105.65	5925.0
2018-08-01 08:00:00	MSFT	Stock	105.9	106.34	105.65	105.85	21256.0
2018-08-01 08:30:00	MSFT	Stock	105.76	106.08	105.7	105.91	27648.0
2018-08-01 09:00:00	MSFT	Stock	105.92	106.08	105.75	105.78	37840.0
2018-08-01 09:30:00	MSFT	Stock	106.03	106.446	105.42	106.02	3847950.0
2018-08-01 10:00:00	MSFT	Stock	106.03	106.22	105.87	106.13	1644293.0
2018-08-01 10:30:00	MSFT	Stock	106.13	106.36	105.99	106.22	1492552.0
2018-08-01 11:00:00	MSFT	Stock	106.211	106.295	106.04	106.06	1146981.0
2018-08-01 11:30:00	MSFT	Stock	106.07	106.19	105.9	106.11	1275760.0
2018-08-01 12:00:00	MSFT	Stock	106.11	106.2	105.89	106.02	1032092.0
2018-08-01 12:30:00	MSFT	Stock	106.02	106.2	105.93	106.065	888053.0
2018-08-01 13:00:00	MSFT	Stock	106.06	106.1	105.96	105.99	711782.0
2018-08-01 13:30:00	MSFT	Stock	105.99	106.14	105.86	106.01	880489.0

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

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