PREVIEW / stock_30min / 2019-01-24

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-01-24.parquet
  size:    1.7 MB
  rows:    82,250
  symbols: 2,676

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-24 04:00:00	AAPL	Stock	38.5475	38.625	38.5475	38.6225	2772.0
2019-01-24 04:30:00	AAPL	Stock	38.6275	38.6275	38.5625	38.5625	19452.0
2019-01-24 05:00:00	AAPL	Stock	38.6975	38.6975	38.695	38.695	820.0
2019-01-24 05:30:00	AAPL	Stock	38.735	38.75	38.6625	38.7225	27384.0
2019-01-24 06:00:00	AAPL	Stock	38.7875	38.7875	38.6625	38.6625	25300.0
2019-01-24 06:30:00	AAPL	Stock	38.725	38.725	38.665	38.675	9932.0
2019-01-24 07:00:00	AAPL	Stock	38.675	38.7	38.625	38.6625	38476.0
2019-01-24 07:30:00	AAPL	Stock	38.65	38.6625	38.585	38.585	35000.0
2019-01-24 08:00:00	AAPL	Stock	38.6875	38.7	38.575	38.625	118824.0
2019-01-24 08:30:00	AAPL	Stock	38.625	38.65	38.3925	38.425	309396.0
2019-01-24 09:00:00	AAPL	Stock	38.4225	38.6625	38.4075	38.475	124440.0
2019-01-24 09:30:00	AAPL	Stock	38.5325	38.62	38.2425	38.2625	11696764.0
2019-01-24 10:00:00	AAPL	Stock	38.265	38.41	38.1975	38.385	8916924.0
2019-01-24 10:30:00	AAPL	Stock	38.3875	38.405	38.07	38.0775	6331300.0
2019-01-24 11:00:00	AAPL	Stock	38.075	38.1375	37.9675	38.0375	6517976.0
2019-01-24 11:30:00	AAPL	Stock	38.0375	38.2575	38.0175	38.2388	5619956.0
2019-01-24 12:00:00	AAPL	Stock	38.2375	38.2375	38.105	38.1645	3300308.0
2019-01-24 12:30:00	AAPL	Stock	38.165	38.2125	38.035	38.055	3315564.0
2019-01-24 13:00:00	AAPL	Stock	38.0525	38.1	37.9925	38.07	3468792.0
2019-01-24 13:30:00	AAPL	Stock	38.0725	38.0975	37.955	38.0075	4243944.0
2019-01-24 14:00:00	AAPL	Stock	38.0075	38.0625	37.9475	37.971	4859712.0
2019-01-24 14:30:00	AAPL	Stock	37.9712	38.08	37.935	38.0562	4593916.0
2019-01-24 15:00:00	AAPL	Stock	38.055	38.13	38.0305	38.0925	4351332.0
2019-01-24 15:30:00	AAPL	Stock	38.0925	38.1875	38.0212	38.1775	9164260.0
2019-01-24 16:00:00	AAPL	Stock	38.175	38.1875	38.04	38.0625	15497184.0
2019-01-24 16:30:00	AAPL	Stock	38.0625	38.175	38.0625	38.125	53828.0
2019-01-24 17:00:00	AAPL	Stock	38.11	38.1225	38.06	38.06	29220.0
2019-01-24 17:30:00	AAPL	Stock	38.12	38.12	38.075	38.1	5408.0
2019-01-24 18:00:00	AAPL	Stock	38.09	38.09	38.05	38.05	23864.0
2019-01-24 18:30:00	AAPL	Stock	38.0525	38.0725	38.05	38.0725	17120.0
2019-01-24 19:00:00	AAPL	Stock	38.055	38.125	38.055	38.125	9832.0
2019-01-24 19:30:00	AAPL	Stock	38.1	38.15	38.1	38.15	16780.0
2019-01-24 04:00:00	MSFT	Stock	106.8	106.8	106.8	106.8	200.0
2019-01-24 04:30:00	MSFT	Stock	107.15	107.15	107.15	107.15	100.0
2019-01-24 05:00:00	MSFT	Stock	107.18	107.18	107.18	107.18	500.0
2019-01-24 05:30:00	MSFT	Stock	107.18	107.18	106.85	107.0	4652.0
2019-01-24 06:00:00	MSFT	Stock	107.0	107.1	106.71	106.81	4946.0
2019-01-24 06:30:00	MSFT	Stock	106.95	107.0	106.87	106.96	4303.0
2019-01-24 07:00:00	MSFT	Stock	107.04	107.08	106.88	107.04	4873.0
2019-01-24 07:30:00	MSFT	Stock	106.94	106.94	106.9	106.9	1798.0
2019-01-24 08:00:00	MSFT	Stock	107.06	107.06	106.85	106.98	20387.0
2019-01-24 08:30:00	MSFT	Stock	106.98	107.15	106.59	106.71	211027.0
2019-01-24 09:00:00	MSFT	Stock	106.82	107.16	106.81	106.95	23669.0
2019-01-24 09:30:00	MSFT	Stock	106.86	107.0	105.76	106.08	2626419.0
2019-01-24 10:00:00	MSFT	Stock	106.07	106.75	105.94	106.466	2063650.0
2019-01-24 10:30:00	MSFT	Stock	106.46	106.54	105.98	106.03	1381172.0
2019-01-24 11:00:00	MSFT	Stock	106.02	106.12	105.34	105.82	1744541.0
2019-01-24 11:30:00	MSFT	Stock	105.81	106.41	105.76	106.26	1176644.0
2019-01-24 12:00:00	MSFT	Stock	106.26	106.33	105.86	106.05	929568.0
2019-01-24 12:30:00	MSFT	Stock	106.05	106.11	105.73	105.83	703288.0

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

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