PREVIEW / stock_30min / 2017-09-08

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-08.parquet
  size:    1.6 MB
  rows:    81,103
  symbols: 2,963

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-09-08 04:00:00	AAPL	Stock	40.285	40.3225	40.25	40.25	4012.0
2017-09-08 04:30:00	AAPL	Stock	40.275	40.275	40.25	40.25	1784.0
2017-09-08 05:30:00	AAPL	Stock	40.305	40.325	40.305	40.3225	2000.0
2017-09-08 06:00:00	AAPL	Stock	40.3275	40.365	40.3275	40.3625	4020.0
2017-09-08 06:30:00	AAPL	Stock	40.33	40.33	40.2825	40.2825	5640.0
2017-09-08 07:00:00	AAPL	Stock	40.2825	40.2975	40.265	40.2975	16196.0
2017-09-08 07:30:00	AAPL	Stock	40.3	40.305	40.2975	40.3	4440.0
2017-09-08 08:00:00	AAPL	Stock	40.2975	40.315	40.2125	40.2875	963764.0
2017-09-08 08:30:00	AAPL	Stock	40.2875	40.29	40.2525	40.2625	29052.0
2017-09-08 09:00:00	AAPL	Stock	40.2625	40.285	40.21	40.225	112512.0
2017-09-08 09:30:00	AAPL	Stock	40.225	40.2875	40.12	40.1775	9340504.0
2017-09-08 10:00:00	AAPL	Stock	40.1765	40.1875	39.9	40.0825	11914608.0
2017-09-08 10:30:00	AAPL	Stock	40.08	40.085	39.9375	39.974	6521192.0
2017-09-08 11:00:00	AAPL	Stock	39.975	40.075	39.9575	39.9985	4733108.0
2017-09-08 11:30:00	AAPL	Stock	39.9988	40.01	39.825	39.9525	7234240.0
2017-09-08 12:00:00	AAPL	Stock	39.9525	40.045	39.9475	39.9952	4396612.0
2017-09-08 12:30:00	AAPL	Stock	39.995	40.0275	39.885	39.9225	3395660.0
2017-09-08 13:00:00	AAPL	Stock	39.9225	39.9325	39.865	39.8882	3449532.0
2017-09-08 13:30:00	AAPL	Stock	39.8875	39.8925	39.7875	39.7975	4307964.0
2017-09-08 14:00:00	AAPL	Stock	39.7975	39.815	39.72	39.7428	6786424.0
2017-09-08 14:30:00	AAPL	Stock	39.7438	39.7925	39.695	39.74	4603976.0
2017-09-08 15:00:00	AAPL	Stock	39.7375	39.7488	39.66	39.6825	5412388.0
2017-09-08 15:30:00	AAPL	Stock	39.6825	39.71	39.6325	39.6575	12459604.0
2017-09-08 16:00:00	AAPL	Stock	39.6575	39.6925	39.6375	39.67	17956212.0
2017-09-08 16:30:00	AAPL	Stock	39.675	39.675	39.6375	39.6425	979576.0
2017-09-08 17:00:00	AAPL	Stock	39.6475	39.6575	39.6375	39.6475	33956.0
2017-09-08 17:30:00	AAPL	Stock	39.6475	39.675	39.64	39.6475	630544.0
2017-09-08 18:00:00	AAPL	Stock	39.6475	39.665	39.6475	39.6525	14936.0
2017-09-08 18:30:00	AAPL	Stock	39.6575	39.6575	39.6525	39.6525	21448.0
2017-09-08 19:00:00	AAPL	Stock	39.6575	39.6725	39.65	39.65	22508.0
2017-09-08 19:30:00	AAPL	Stock	39.6475	39.6475	39.635	39.6475	46804.0
2017-09-08 04:00:00	MSFT	Stock	74.67	74.67	74.67	74.67	120.0
2017-09-08 07:30:00	MSFT	Stock	74.22	74.22	74.22	74.22	1122.0
2017-09-08 08:00:00	MSFT	Stock	74.34	74.34	74.0	74.0	330543.0
2017-09-08 08:30:00	MSFT	Stock	74.16	74.27	74.16	74.27	1368.0
2017-09-08 09:00:00	MSFT	Stock	74.27	74.34	74.13	74.24	2581.0
2017-09-08 09:30:00	MSFT	Stock	74.33	74.44	74.12	74.29	1537104.0
2017-09-08 10:00:00	MSFT	Stock	74.3	74.34	74.15	74.25	727201.0
2017-09-08 10:30:00	MSFT	Stock	74.25	74.27	74.125	74.22	701452.0
2017-09-08 11:00:00	MSFT	Stock	74.22	74.38	74.19	74.32	717463.0
2017-09-08 11:30:00	MSFT	Stock	74.32	74.32	74.19	74.22	669726.0
2017-09-08 12:00:00	MSFT	Stock	74.215	74.27	74.09	74.15	513189.0
2017-09-08 12:30:00	MSFT	Stock	74.14	74.21	74.03	74.04	456280.0
2017-09-08 13:00:00	MSFT	Stock	74.04	74.22	74.02	74.21	480623.0
2017-09-08 13:30:00	MSFT	Stock	74.22	74.229	74.11	74.125	731642.0
2017-09-08 14:00:00	MSFT	Stock	74.13	74.13	73.99	73.995	439753.0
2017-09-08 14:30:00	MSFT	Stock	73.99	74.035	73.88	73.9	585691.0
2017-09-08 15:00:00	MSFT	Stock	73.895	73.95	73.84	73.94	1160865.0
2017-09-08 15:30:00	MSFT	Stock	73.938	74.08	73.88	74.0	2242323.0
2017-09-08 16:00:00	MSFT	Stock	73.98	74.106	73.95	73.98	2270223.0

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

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