PREVIEW / stock_30min / 2020-01-14

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-14.parquet
  size:    1.8 MB
  rows:    87,861
  symbols: 2,471

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
2020-01-14 04:00:00	AAPL	Stock	79.125	79.1825	78.93	78.9675	112744.0
2020-01-14 04:30:00	AAPL	Stock	78.96	79.1625	78.96	79.125	45968.0
2020-01-14 05:00:00	AAPL	Stock	79.0875	79.175	79.0875	79.0875	14760.0
2020-01-14 05:30:00	AAPL	Stock	79.0925	79.1575	79.0025	79.005	51848.0
2020-01-14 06:00:00	AAPL	Stock	79.095	79.095	78.9125	78.975	38024.0
2020-01-14 06:30:00	AAPL	Stock	78.99	79.1225	78.9525	79.08	47224.0
2020-01-14 07:00:00	AAPL	Stock	79.12	79.4325	79.0525	79.4	398884.0
2020-01-14 07:30:00	AAPL	Stock	79.405	79.4425	79.2625	79.3125	231196.0
2020-01-14 08:00:00	AAPL	Stock	79.255	79.4425	79.1225	79.1525	848300.0
2020-01-14 08:30:00	AAPL	Stock	79.17	79.2825	79.1075	79.21	420224.0
2020-01-14 09:00:00	AAPL	Stock	79.2	79.275	79.05	79.16	750328.0
2020-01-14 09:30:00	AAPL	Stock	79.175	79.31	78.3378	78.4425	22870324.0
2020-01-14 10:00:00	AAPL	Stock	78.4475	79.2125	78.3675	79.1512	13601544.0
2020-01-14 10:30:00	AAPL	Stock	79.155	79.3925	78.6925	78.9382	12503932.0
2020-01-14 11:00:00	AAPL	Stock	78.94	79.0475	78.75	78.8375	6132492.0
2020-01-14 11:30:00	AAPL	Stock	78.84	79.15	78.65	79.135	6541760.0
2020-01-14 12:00:00	AAPL	Stock	79.1325	79.17	78.7875	78.8035	5799960.0
2020-01-14 12:30:00	AAPL	Stock	78.8037	78.87	78.65	78.68	5318628.0
2020-01-14 13:00:00	AAPL	Stock	78.6825	78.9	78.6785	78.8765	4369208.0
2020-01-14 13:30:00	AAPL	Stock	78.8818	78.9675	78.1875	78.345	13260724.0
2020-01-14 14:00:00	AAPL	Stock	78.35	78.75	78.0425	78.5475	11347116.0
2020-01-14 14:30:00	AAPL	Stock	78.54	78.696	78.325	78.376	6078600.0
2020-01-14 15:00:00	AAPL	Stock	78.3775	78.46	78.2125	78.236	4575444.0
2020-01-14 15:30:00	AAPL	Stock	78.2325	78.55	78.055	78.1725	12356840.0
2020-01-14 16:00:00	AAPL	Stock	78.17	78.9463	78.1125	78.2375	9490988.0
2020-01-14 16:30:00	AAPL	Stock	78.2325	78.25	78.17	78.2425	81548.0
2020-01-14 17:00:00	AAPL	Stock	78.25	78.295	78.17	78.2875	1459548.0
2020-01-14 17:30:00	AAPL	Stock	78.295	78.3	78.1675	78.1875	65232.0
2020-01-14 18:00:00	AAPL	Stock	78.185	78.1925	78.0325	78.0325	168176.0
2020-01-14 18:30:00	AAPL	Stock	78.0525	78.0525	77.745	77.745	257296.0
2020-01-14 19:00:00	AAPL	Stock	77.745	77.995	77.6975	77.985	151296.0
2020-01-14 19:30:00	AAPL	Stock	77.9775	77.9775	77.8275	77.9375	69088.0
2020-01-14 04:00:00	MSFT	Stock	162.98	163.3	162.98	163.3	904.0
2020-01-14 04:30:00	MSFT	Stock	163.35	163.6	163.35	163.6	713.0
2020-01-14 05:00:00	MSFT	Stock	163.59	163.6	163.59	163.6	300.0
2020-01-14 05:30:00	MSFT	Stock	163.6	163.6	163.2	163.2	872.0
2020-01-14 06:00:00	MSFT	Stock	163.39	163.39	162.9	163.1	6407.0
2020-01-14 06:30:00	MSFT	Stock	163.01	163.03	163.0	163.0	800.0
2020-01-14 07:00:00	MSFT	Stock	163.0	163.2	163.0	163.17	13172.0
2020-01-14 07:30:00	MSFT	Stock	163.07	163.2	162.85	163.09	14753.0
2020-01-14 08:00:00	MSFT	Stock	163.15	163.68	163.0	163.15	17597.0
2020-01-14 08:30:00	MSFT	Stock	163.16	163.29	163.04	163.246	204374.0
2020-01-14 09:00:00	MSFT	Stock	163.17	163.38	163.01	163.38	28895.0
2020-01-14 09:30:00	MSFT	Stock	163.22	163.46	162.52	162.85	2765144.0
2020-01-14 10:00:00	MSFT	Stock	162.85	163.6	162.77	163.305	1516558.0
2020-01-14 10:30:00	MSFT	Stock	163.304	163.52	162.95	163.183	919934.0
2020-01-14 11:00:00	MSFT	Stock	163.2	163.24	162.82	162.878	602852.0
2020-01-14 11:30:00	MSFT	Stock	162.87	163.21	162.85	163.196	631971.0
2020-01-14 12:00:00	MSFT	Stock	163.195	163.26	163.12	163.175	366328.0
2020-01-14 12:30:00	MSFT	Stock	163.175	163.45	163.17	163.21	526621.0

> showing 50 of 87,861 rows — these rows as CSV

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