PREVIEW / stock_30min / 2019-07-08

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-08.parquet
  size:    1.7 MB
  rows:    82,494
  symbols: 2,591

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-07-08 04:00:00	AAPL	Stock	50.8	50.835	50.6725	50.775	9600.0
2019-07-08 04:30:00	AAPL	Stock	50.7025	50.7025	50.7025	50.7025	3100.0
2019-07-08 05:00:00	AAPL	Stock	50.6575	50.6575	50.5	50.5	18772.0
2019-07-08 05:30:00	AAPL	Stock	50.5	50.5	50.165	50.1775	34420.0
2019-07-08 06:00:00	AAPL	Stock	50.185	50.2425	50.1725	50.175	12632.0
2019-07-08 06:30:00	AAPL	Stock	50.125	50.2	50.125	50.175	34692.0
2019-07-08 07:00:00	AAPL	Stock	50.2	50.2975	50.1625	50.275	92168.0
2019-07-08 07:30:00	AAPL	Stock	50.3075	50.3525	50.255	50.2775	109088.0
2019-07-08 08:00:00	AAPL	Stock	50.2507	50.3675	50.165	50.3	287464.0
2019-07-08 08:30:00	AAPL	Stock	50.315	50.375	50.2625	50.275	296796.0
2019-07-08 09:00:00	AAPL	Stock	50.275	50.335	50.2	50.25	422112.0
2019-07-08 09:30:00	AAPL	Stock	50.235	50.35	49.6025	49.7125	20287564.0
2019-07-08 10:00:00	AAPL	Stock	49.7138	49.9325	49.6825	49.9025	9234480.0
2019-07-08 10:30:00	AAPL	Stock	49.9012	49.9675	49.755	49.8125	5981488.0
2019-07-08 11:00:00	AAPL	Stock	49.8125	50.045	49.805	50.04	6658516.0
2019-07-08 11:30:00	AAPL	Stock	50.035	50.035	49.8775	49.9818	3548272.0
2019-07-08 12:00:00	AAPL	Stock	49.98	50.0225	49.9175	49.9675	2849768.0
2019-07-08 12:30:00	AAPL	Stock	49.9688	50.0175	49.94	49.9975	2700908.0
2019-07-08 13:00:00	AAPL	Stock	49.9975	50.0225	49.9375	49.975	2268948.0
2019-07-08 13:30:00	AAPL	Stock	49.975	49.995	49.885	49.91	2423668.0
2019-07-08 14:00:00	AAPL	Stock	49.9125	49.9338	49.825	49.8375	2933056.0
2019-07-08 14:30:00	AAPL	Stock	49.8375	50.0075	49.8288	49.9955	3659564.0
2019-07-08 15:00:00	AAPL	Stock	49.9975	50.0425	49.945	49.98	3818032.0
2019-07-08 15:30:00	AAPL	Stock	49.9875	50.0125	49.9325	50.0025	7729660.0
2019-07-08 16:00:00	AAPL	Stock	50.005	50.005	49.9525	49.9525	7210580.0
2019-07-08 16:30:00	AAPL	Stock	49.95	50.005	49.925	50.0	93660.0
2019-07-08 17:00:00	AAPL	Stock	49.9925	50.0175	49.9675	49.9975	53708.0
2019-07-08 17:30:00	AAPL	Stock	49.9825	50.005	49.9575	50.0048	46344.0
2019-07-08 18:00:00	AAPL	Stock	49.9825	50.0375	49.9825	50.0075	38252.0
2019-07-08 18:30:00	AAPL	Stock	50.005	50.025	50.005	50.01	21160.0
2019-07-08 19:00:00	AAPL	Stock	50.0325	50.125	50.0325	50.1075	43820.0
2019-07-08 19:30:00	AAPL	Stock	50.1075	50.125	50.025	50.08	81048.0
2019-07-08 04:00:00	MSFT	Stock	136.88	136.88	136.58	136.65	1906.0
2019-07-08 05:00:00	MSFT	Stock	136.5	136.5	136.44	136.5	600.0
2019-07-08 06:30:00	MSFT	Stock	136.21	136.27	136.21	136.27	230.0
2019-07-08 07:00:00	MSFT	Stock	136.41	136.5	136.35	136.49	3649.0
2019-07-08 07:30:00	MSFT	Stock	136.43	136.43	136.35	136.35	1700.0
2019-07-08 08:00:00	MSFT	Stock	136.4	137.4	136.26	136.4	5042.0
2019-07-08 08:30:00	MSFT	Stock	136.34	136.5	136.31	136.43	10310.0
2019-07-08 09:00:00	MSFT	Stock	136.39	136.49	136.11	136.16	17044.0
2019-07-08 09:30:00	MSFT	Stock	136.19	136.4	135.37	135.51	2180352.0
2019-07-08 10:00:00	MSFT	Stock	135.505	136.16	135.385	135.985	1840310.0
2019-07-08 10:30:00	MSFT	Stock	135.98	136.42	135.81	136.415	1011375.0
2019-07-08 11:00:00	MSFT	Stock	136.41	136.63	136.25	136.35	859059.0
2019-07-08 11:30:00	MSFT	Stock	136.35	136.37	136.152	136.27	586787.0
2019-07-08 12:00:00	MSFT	Stock	136.27	136.44	136.06	136.2	497478.0
2019-07-08 12:30:00	MSFT	Stock	136.21	136.47	136.21	136.43	519177.0
2019-07-08 13:00:00	MSFT	Stock	136.434	136.64	136.385	136.53	526685.0
2019-07-08 13:30:00	MSFT	Stock	136.54	136.65	136.37	136.5	454129.0
2019-07-08 14:00:00	MSFT	Stock	136.5	136.69	136.44	136.69	571587.0

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

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