PREVIEW / stock_30min / 2019-09-17

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-09-17.parquet
  size:    1.7 MB
  rows:    85,498
  symbols: 2,546

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
2019-09-17 04:00:00	AAPL	Stock	54.975	54.975	54.975	54.975	800.0
2019-09-17 04:30:00	AAPL	Stock	54.9525	54.9525	54.8625	54.9075	2908.0
2019-09-17 05:00:00	AAPL	Stock	54.8975	54.99	54.8975	54.99	5168.0
2019-09-17 05:30:00	AAPL	Stock	54.85	54.85	54.85	54.85	2000.0
2019-09-17 06:00:00	AAPL	Stock	54.8375	54.8375	54.8275	54.8275	1200.0
2019-09-17 06:30:00	AAPL	Stock	54.825	54.8575	54.8	54.8	1512.0
2019-09-17 07:00:00	AAPL	Stock	54.845	54.8925	54.825	54.8925	37516.0
2019-09-17 07:30:00	AAPL	Stock	54.9275	55.0425	54.9275	55.0125	18544.0
2019-09-17 08:00:00	AAPL	Stock	54.8495	55.045	54.8225	54.93	222188.0
2019-09-17 08:30:00	AAPL	Stock	54.94	54.9975	54.8525	54.9975	74860.0
2019-09-17 09:00:00	AAPL	Stock	54.995	55.02	54.925	54.995	130004.0
2019-09-17 09:30:00	AAPL	Stock	54.9675	55.1475	54.78	54.8525	10644392.0
2019-09-17 10:00:00	AAPL	Stock	54.8525	54.98	54.8125	54.8775	4786936.0
2019-09-17 10:30:00	AAPL	Stock	54.8825	55.0325	54.8825	54.9425	4230408.0
2019-09-17 11:00:00	AAPL	Stock	54.94	55.1475	54.9375	55.06	4582228.0
2019-09-17 11:30:00	AAPL	Stock	55.0612	55.11	55.0225	55.0525	2322084.0
2019-09-17 12:00:00	AAPL	Stock	55.0575	55.0825	54.89	54.9825	3253504.0
2019-09-17 12:30:00	AAPL	Stock	54.985	55.0325	54.89	54.9838	2694744.0
2019-09-17 13:00:00	AAPL	Stock	54.9825	55.065	54.98	55.0225	2223680.0
2019-09-17 13:30:00	AAPL	Stock	55.0225	55.0875	54.975	55.0	2353064.0
2019-09-17 14:00:00	AAPL	Stock	55.0	55.0482	54.9625	54.985	2826392.0
2019-09-17 14:30:00	AAPL	Stock	54.9875	55.0475	54.95	55.005	2822184.0
2019-09-17 15:00:00	AAPL	Stock	55.0075	55.055	54.975	55.04	2199168.0
2019-09-17 15:30:00	AAPL	Stock	55.04	55.205	55.0375	55.1625	6050712.0
2019-09-17 16:00:00	AAPL	Stock	55.175	55.2125	55.125	55.1625	8112984.0
2019-09-17 16:30:00	AAPL	Stock	55.1625	55.19	55.15	55.185	41200.0
2019-09-17 17:00:00	AAPL	Stock	55.1925	55.1925	55.1625	55.165	10368.0
2019-09-17 17:30:00	AAPL	Stock	55.18	55.18	55.15	55.15	14160.0
2019-09-17 18:00:00	AAPL	Stock	55.15	55.2375	55.13	55.2	51288.0
2019-09-17 18:30:00	AAPL	Stock	55.2375	55.2375	55.225	55.235	10888.0
2019-09-17 19:00:00	AAPL	Stock	55.225	55.225	55.2	55.21	17960.0
2019-09-17 19:30:00	AAPL	Stock	55.2	55.2475	55.2	55.2475	11772.0
2019-09-17 06:30:00	MSFT	Stock	136.08	136.08	135.89	135.89	578.0
2019-09-17 07:00:00	MSFT	Stock	135.89	136.25	135.89	136.21	6380.0
2019-09-17 07:30:00	MSFT	Stock	136.23	136.4	136.23	136.38	2799.0
2019-09-17 08:00:00	MSFT	Stock	136.2	136.33	136.15	136.25	16645.0
2019-09-17 08:30:00	MSFT	Stock	136.15	136.33	136.13	136.2	39313.0
2019-09-17 09:00:00	MSFT	Stock	136.38	137.0	136.21	136.97	28343.0
2019-09-17 09:30:00	MSFT	Stock	136.96	137.49	136.74	137.17	1852867.0
2019-09-17 10:00:00	MSFT	Stock	137.19	137.3	136.8	136.93	872550.0
2019-09-17 10:30:00	MSFT	Stock	136.93	137.01	136.425	136.47	1163411.0
2019-09-17 11:00:00	MSFT	Stock	136.465	136.94	136.465	136.86	998817.0
2019-09-17 11:30:00	MSFT	Stock	136.87	136.995	136.83	136.87	516692.0
2019-09-17 12:00:00	MSFT	Stock	136.87	136.976	136.773	136.917	407215.0
2019-09-17 12:30:00	MSFT	Stock	136.91	136.995	136.84	136.939	360601.0
2019-09-17 13:00:00	MSFT	Stock	136.94	136.98	136.8	136.82	428320.0
2019-09-17 13:30:00	MSFT	Stock	136.821	137.06	136.805	136.895	692636.0
2019-09-17 14:00:00	MSFT	Stock	136.9	136.99	136.71	136.92	649862.0
2019-09-17 14:30:00	MSFT	Stock	136.92	136.98	136.83	136.9	595883.0
2019-09-17 15:00:00	MSFT	Stock	136.9	137.08	136.844	137.06	728729.0

> showing 50 of 85,498 rows — these rows as CSV

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