PREVIEW / stock_30min / 2017-03-31

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-31.parquet
  size:    1.6 MB
  rows:    81,463
  symbols: 3,076

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-03-31 04:00:00	AAPL	Stock	35.88	35.88	35.88	35.88	1908.0
2017-03-31 05:30:00	AAPL	Stock	35.8825	35.8825	35.8825	35.8825	1220.0
2017-03-31 06:30:00	AAPL	Stock	35.8775	35.9225	35.8775	35.92	13220.0
2017-03-31 07:00:00	AAPL	Stock	35.89	35.9125	35.88	35.9	16256.0
2017-03-31 07:30:00	AAPL	Stock	35.91	35.925	35.8875	35.925	12300.0
2017-03-31 08:00:00	AAPL	Stock	35.9	35.9575	35.9	35.95	20124.0
2017-03-31 08:30:00	AAPL	Stock	35.95	35.975	35.945	35.95	37012.0
2017-03-31 09:00:00	AAPL	Stock	35.9475	35.9475	35.905	35.9125	110584.0
2017-03-31 09:30:00	AAPL	Stock	35.93	35.975	35.7525	35.945	11289328.0
2017-03-31 10:00:00	AAPL	Stock	35.9462	36.0675	35.945	35.9933	6921468.0
2017-03-31 10:30:00	AAPL	Stock	35.995	36.0275	35.94	35.996	4570388.0
2017-03-31 11:00:00	AAPL	Stock	35.995	36.0422	35.97	35.98	3330936.0
2017-03-31 11:30:00	AAPL	Stock	35.9775	36.0225	35.95	35.96	2525136.0
2017-03-31 12:00:00	AAPL	Stock	35.9605	36.0	35.95	35.9938	1932372.0
2017-03-31 12:30:00	AAPL	Stock	35.9948	36.0175	35.9785	36.0162	2197316.0
2017-03-31 13:00:00	AAPL	Stock	36.0175	36.025	35.9875	36.0175	1851540.0
2017-03-31 13:30:00	AAPL	Stock	36.0175	36.03	35.9325	35.9325	2665100.0
2017-03-31 14:00:00	AAPL	Stock	35.9308	35.95	35.8775	35.92	4266540.0
2017-03-31 14:30:00	AAPL	Stock	35.915	35.9425	35.9075	35.9135	2595552.0
2017-03-31 15:00:00	AAPL	Stock	35.915	35.9775	35.9148	35.9625	3396604.0
2017-03-31 15:30:00	AAPL	Stock	35.9625	36.0127	35.91	35.9175	11541604.0
2017-03-31 16:00:00	AAPL	Stock	35.92	35.9565	35.9145	35.925	12123712.0
2017-03-31 16:30:00	AAPL	Stock	35.925	35.9425	35.9025	35.9275	72132.0
2017-03-31 17:00:00	AAPL	Stock	35.925	35.9375	35.915	35.935	14192.0
2017-03-31 17:30:00	AAPL	Stock	35.92	35.9225	35.915	35.9225	9412.0
2017-03-31 18:00:00	AAPL	Stock	35.915	35.925	35.915	35.915	12656.0
2017-03-31 19:00:00	AAPL	Stock	35.915	35.915	35.9125	35.915	7320.0
2017-03-31 19:30:00	AAPL	Stock	35.9075	35.9075	35.9025	35.9025	10800.0
2017-03-31 07:00:00	MSFT	Stock	65.5	65.5	65.5	65.5	500.0
2017-03-31 08:00:00	MSFT	Stock	65.65	65.75	65.65	65.75	725.0
2017-03-31 08:30:00	MSFT	Stock	65.7	65.78	65.7	65.78	2040.0
2017-03-31 09:00:00	MSFT	Stock	65.71	65.71	65.7	65.7	51000.0
2017-03-31 09:30:00	MSFT	Stock	65.65	65.75	65.45	65.66	1583026.0
2017-03-31 10:00:00	MSFT	Stock	65.665	65.78	65.65	65.69	961112.0
2017-03-31 10:30:00	MSFT	Stock	65.7	65.81	65.69	65.76	747627.0
2017-03-31 11:00:00	MSFT	Stock	65.764	65.94	65.75	65.895	787814.0
2017-03-31 11:30:00	MSFT	Stock	65.89	66.0	65.87	65.96	1237407.0
2017-03-31 12:00:00	MSFT	Stock	65.96	66.09	65.95	66.065	942504.0
2017-03-31 12:30:00	MSFT	Stock	66.07	66.08	66.02	66.075	521209.0
2017-03-31 13:00:00	MSFT	Stock	66.08	66.15	66.07	66.14	639173.0
2017-03-31 13:30:00	MSFT	Stock	66.15	66.19	66.02	66.02	916216.0
2017-03-31 14:00:00	MSFT	Stock	66.02	66.02	65.87	65.965	811738.0
2017-03-31 14:30:00	MSFT	Stock	65.96	66.03	65.91	65.91	1052966.0
2017-03-31 15:00:00	MSFT	Stock	65.911	66.085	65.91	66.05	1046513.0
2017-03-31 15:30:00	MSFT	Stock	66.05	66.155	65.85	65.87	4055678.0
2017-03-31 16:00:00	MSFT	Stock	65.84	65.97	65.84	65.88	4195205.0
2017-03-31 16:30:00	MSFT	Stock	65.95	65.96	65.88	65.96	2400.0
2017-03-31 17:00:00	MSFT	Stock	65.88	65.88	65.88	65.88	400.0
2017-03-31 17:30:00	MSFT	Stock	65.88	65.93	65.88	65.93	1499.0
2017-03-31 18:00:00	MSFT	Stock	65.88	65.88	65.88	65.88	650.0

> showing 50 of 81,463 rows — these rows as CSV

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