PREVIEW / stock_30min / 2019-06-24

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-24.parquet
  size:    1.7 MB
  rows:    85,335
  symbols: 2,607

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-06-24 04:00:00	AAPL	Stock	49.825	49.825	49.7675	49.8	16004.0
2019-06-24 04:30:00	AAPL	Stock	49.77	49.825	49.77	49.8125	14076.0
2019-06-24 05:00:00	AAPL	Stock	49.8	49.8	49.79	49.8	10648.0
2019-06-24 05:30:00	AAPL	Stock	49.825	49.825	49.825	49.825	400.0
2019-06-24 06:00:00	AAPL	Stock	49.825	49.825	49.825	49.825	400.0
2019-06-24 06:30:00	AAPL	Stock	49.8	49.8	49.7625	49.7625	6232.0
2019-06-24 07:00:00	AAPL	Stock	49.7275	49.77	49.575	49.625	61180.0
2019-06-24 07:30:00	AAPL	Stock	49.63	49.6875	49.575	49.6875	45208.0
2019-06-24 08:00:00	AAPL	Stock	49.75	49.7875	49.5625	49.695	166924.0
2019-06-24 08:30:00	AAPL	Stock	49.695	49.775	49.695	49.75	90312.0
2019-06-24 09:00:00	AAPL	Stock	49.75	49.75	49.645	49.655	109256.0
2019-06-24 09:30:00	AAPL	Stock	49.64	50.0	49.5425	49.9025	8153240.0
2019-06-24 10:00:00	AAPL	Stock	49.91	50.04	49.815	49.8845	5069156.0
2019-06-24 10:30:00	AAPL	Stock	49.885	49.9675	49.8415	49.9425	3341828.0
2019-06-24 11:00:00	AAPL	Stock	49.9438	49.9675	49.827	49.87	3323128.0
2019-06-24 11:30:00	AAPL	Stock	49.871	49.9	49.8375	49.8725	2819532.0
2019-06-24 12:00:00	AAPL	Stock	49.875	49.8975	49.74	49.7648	2589976.0
2019-06-24 12:30:00	AAPL	Stock	49.7635	49.8125	49.735	49.7925	1839192.0
2019-06-24 13:00:00	AAPL	Stock	49.795	49.85	49.765	49.77	1837480.0
2019-06-24 13:30:00	AAPL	Stock	49.77	49.8015	49.7282	49.7537	1599700.0
2019-06-24 14:00:00	AAPL	Stock	49.7537	49.795	49.7375	49.75	1854816.0
2019-06-24 14:30:00	AAPL	Stock	49.75	49.7875	49.715	49.78	1891408.0
2019-06-24 15:00:00	AAPL	Stock	49.78	49.8	49.73	49.73	2115508.0
2019-06-24 15:30:00	AAPL	Stock	49.7325	49.84	49.615	49.6375	7573856.0
2019-06-24 16:00:00	AAPL	Stock	49.6375	49.67	49.5975	49.6468	11536400.0
2019-06-24 16:30:00	AAPL	Stock	49.65	49.6575	49.645	49.645	8428.0
2019-06-24 17:00:00	AAPL	Stock	49.645	49.6625	49.645	49.66	361868.0
2019-06-24 17:30:00	AAPL	Stock	49.66	49.665	49.64	49.665	19452.0
2019-06-24 18:00:00	AAPL	Stock	49.6675	49.675	49.6525	49.675	10384.0
2019-06-24 18:30:00	AAPL	Stock	49.6975	49.6975	49.665	49.6725	5300.0
2019-06-24 19:00:00	AAPL	Stock	49.675	49.675	49.6675	49.6675	1080.0
2019-06-24 19:30:00	AAPL	Stock	49.675	49.6875	49.6525	49.67	39096.0
2019-06-24 04:00:00	MSFT	Stock	137.45	137.5	137.4	137.45	2500.0
2019-06-24 04:30:00	MSFT	Stock	137.65	137.65	137.6	137.6	1738.0
2019-06-24 05:00:00	MSFT	Stock	137.6	137.6	137.55	137.55	899.0
2019-06-24 05:30:00	MSFT	Stock	137.65	137.65	137.65	137.65	1986.0
2019-06-24 06:00:00	MSFT	Stock	137.69	137.69	137.6	137.6	239.0
2019-06-24 06:30:00	MSFT	Stock	137.72	137.72	137.54	137.54	3290.0
2019-06-24 07:00:00	MSFT	Stock	137.5	137.58	137.32	137.45	3686.0
2019-06-24 07:30:00	MSFT	Stock	137.42	137.42	137.42	137.42	462.0
2019-06-24 08:00:00	MSFT	Stock	137.3	137.58	137.3	137.45	10585.0
2019-06-24 08:30:00	MSFT	Stock	137.47	137.55	137.45	137.49	19264.0
2019-06-24 09:00:00	MSFT	Stock	137.49	137.49	137.01	137.23	13489.0
2019-06-24 09:30:00	MSFT	Stock	137.23	137.88	137.0	137.18	1896872.0
2019-06-24 10:00:00	MSFT	Stock	137.18	137.6	137.13	137.55	913714.0
2019-06-24 10:30:00	MSFT	Stock	137.555	137.79	137.53	137.685	742790.0
2019-06-24 11:00:00	MSFT	Stock	137.681	138.0	137.67	137.96	980582.0
2019-06-24 11:30:00	MSFT	Stock	137.96	138.15	137.92	138.12	986816.0
2019-06-24 12:00:00	MSFT	Stock	138.13	138.34	138.08	138.285	1040348.0
2019-06-24 12:30:00	MSFT	Stock	138.285	138.4	138.19	138.255	836777.0

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

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