PREVIEW / stock_30min / 2019-01-28

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-28.parquet
  size:    1.7 MB
  rows:    84,147
  symbols: 2,693

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-01-28 04:00:00	AAPL	Stock	39.3225	39.345	39.25	39.27	51972.0
2019-01-28 04:30:00	AAPL	Stock	39.2975	39.3	39.2975	39.3	4212.0
2019-01-28 05:00:00	AAPL	Stock	39.3	39.3	39.3	39.3	2224.0
2019-01-28 05:30:00	AAPL	Stock	39.275	39.2775	39.275	39.2775	1208.0
2019-01-28 06:00:00	AAPL	Stock	39.3	39.3125	39.3	39.3125	3600.0
2019-01-28 06:30:00	AAPL	Stock	39.2825	39.2825	39.27	39.27	2684.0
2019-01-28 07:00:00	AAPL	Stock	39.2875	39.3425	39.2	39.225	183152.0
2019-01-28 07:30:00	AAPL	Stock	39.23	39.23	39.05	39.1	133636.0
2019-01-28 08:00:00	AAPL	Stock	39.275	39.5375	39.0625	39.0675	265144.0
2019-01-28 08:30:00	AAPL	Stock	39.075	39.125	39.01	39.1	207124.0
2019-01-28 09:00:00	AAPL	Stock	39.1	39.1225	38.6475	38.9025	911536.0
2019-01-28 09:30:00	AAPL	Stock	38.8825	38.9875	38.415	38.6425	17774996.0
2019-01-28 10:00:00	AAPL	Stock	38.6425	38.9175	38.58	38.8225	8702652.0
2019-01-28 10:30:00	AAPL	Stock	38.8175	38.83	38.5875	38.5925	6697188.0
2019-01-28 11:00:00	AAPL	Stock	38.5875	38.794	38.5625	38.7225	6110192.0
2019-01-28 11:30:00	AAPL	Stock	38.725	38.775	38.59	38.615	4355680.0
2019-01-28 12:00:00	AAPL	Stock	38.615	38.77	38.5925	38.7565	2955716.0
2019-01-28 12:30:00	AAPL	Stock	38.7575	38.785	38.7	38.7075	3305552.0
2019-01-28 13:00:00	AAPL	Stock	38.71	38.955	38.695	38.8975	4574876.0
2019-01-28 13:30:00	AAPL	Stock	38.8925	39.005	38.8925	38.935	3569916.0
2019-01-28 14:00:00	AAPL	Stock	38.9375	39.0125	38.8825	38.925	4107236.0
2019-01-28 14:30:00	AAPL	Stock	38.9275	39.07	38.895	39.005	4500288.0
2019-01-28 15:00:00	AAPL	Stock	39.005	39.0458	38.9175	38.985	5813316.0
2019-01-28 15:30:00	AAPL	Stock	38.9862	39.0825	38.9325	39.075	7500796.0
2019-01-28 16:00:00	AAPL	Stock	39.075	39.09	39.0	39.025	11490452.0
2019-01-28 16:30:00	AAPL	Stock	39.025	39.035	38.975	39.0	65680.0
2019-01-28 17:00:00	AAPL	Stock	39.0	39.0	38.9625	38.975	23500.0
2019-01-28 17:30:00	AAPL	Stock	38.975	38.9925	38.9575	38.9925	33420.0
2019-01-28 18:00:00	AAPL	Stock	38.975	38.9925	38.94	38.97	27092.0
2019-01-28 18:30:00	AAPL	Stock	38.97	38.9725	38.94	38.945	11464.0
2019-01-28 19:00:00	AAPL	Stock	38.935	38.9425	38.875	38.875	35068.0
2019-01-28 19:30:00	AAPL	Stock	38.875	38.9125	38.8525	38.9	39776.0
2019-01-28 04:00:00	MSFT	Stock	106.97	106.97	106.51	106.55	1231.0
2019-01-28 04:30:00	MSFT	Stock	106.5	106.5	106.5	106.5	400.0
2019-01-28 05:00:00	MSFT	Stock	106.64	106.7	106.64	106.7	998.0
2019-01-28 06:00:00	MSFT	Stock	106.59	106.6	106.55	106.6	2200.0
2019-01-28 06:30:00	MSFT	Stock	106.63	106.66	106.51	106.51	2769.0
2019-01-28 07:00:00	MSFT	Stock	106.57	106.88	106.5	106.8	60269.0
2019-01-28 07:30:00	MSFT	Stock	106.8	107.1	106.63	106.99	44586.0
2019-01-28 08:00:00	MSFT	Stock	106.58	107.45	106.53	106.81	23557.0
2019-01-28 08:30:00	MSFT	Stock	106.85	107.0	106.75	106.85	29027.0
2019-01-28 09:00:00	MSFT	Stock	106.89	106.98	106.1	106.3	176721.0
2019-01-28 09:30:00	MSFT	Stock	106.35	106.48	104.86	105.295	4100501.0
2019-01-28 10:00:00	MSFT	Stock	105.295	105.43	104.98	105.235	2276993.0
2019-01-28 10:30:00	MSFT	Stock	105.23	105.23	104.82	104.94	2241047.0
2019-01-28 11:00:00	MSFT	Stock	104.945	105.22	104.82	105.145	1630959.0
2019-01-28 11:30:00	MSFT	Stock	105.15	105.24	104.71	104.86	1765387.0
2019-01-28 12:00:00	MSFT	Stock	104.85	105.06	104.8	104.94	1444690.0
2019-01-28 12:30:00	MSFT	Stock	104.95	105.0	104.695	104.75	1186451.0
2019-01-28 13:00:00	MSFT	Stock	104.75	105.1	104.66	104.945	977000.0

> showing 50 of 84,147 rows — these rows as CSV

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