PREVIEW / stock_30min / 2006-10-19

all stock 30-min files

  file:    by_date/stock_30min/2006/2006-10-19.parquet
  size:    919 KB
  rows:    50,412
  symbols: 2,400

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
2006-10-19 04:00:00	AAPL	Stock	2.7696	2.7696	2.7696	2.7696	2800.0
2006-10-19 07:00:00	AAPL	Stock	2.7714	2.7771	2.7714	2.775	45500.0
2006-10-19 07:30:00	AAPL	Stock	2.7793	2.7929	2.7793	2.7811	975716.0
2006-10-19 08:00:00	AAPL	Stock	2.7839	2.8204	2.7814	2.8104	17479644.0
2006-10-19 08:30:00	AAPL	Stock	2.8104	2.8282	2.8071	2.8229	17720080.0
2006-10-19 09:00:00	AAPL	Stock	2.8239	2.8521	2.8229	2.8311	32195688.0
2006-10-19 09:30:00	AAPL	Stock	2.8307	2.8446	2.7914	2.8239	390546996.0
2006-10-19 10:00:00	AAPL	Stock	2.8229	2.8554	2.8221	2.84	225186024.0
2006-10-19 10:30:00	AAPL	Stock	2.8404	2.8443	2.8254	2.8289	129884524.0
2006-10-19 11:00:00	AAPL	Stock	2.8286	2.8357	2.8189	2.8318	91751408.0
2006-10-19 11:30:00	AAPL	Stock	2.8318	2.855	2.8125	2.8211	89831812.0
2006-10-19 12:00:00	AAPL	Stock	2.8211	2.8293	2.8129	2.8189	64390984.0
2006-10-19 12:30:00	AAPL	Stock	2.8193	2.825	2.8018	2.81	79300928.0
2006-10-19 13:00:00	AAPL	Stock	2.81	2.8221	2.8075	2.8168	52023944.0
2006-10-19 13:30:00	AAPL	Stock	2.8168	2.825	2.8136	2.8161	43723736.0
2006-10-19 14:00:00	AAPL	Stock	2.8221	2.8304	2.8143	2.8296	53268236.0
2006-10-19 14:30:00	AAPL	Stock	2.8298	2.8354	2.8218	2.8268	60113088.0
2006-10-19 15:00:00	AAPL	Stock	2.8264	2.8314	2.8229	2.825	52951276.0
2006-10-19 15:30:00	AAPL	Stock	2.8254	2.8289	2.8171	2.8218	96797792.0
2006-10-19 16:00:00	AAPL	Stock	2.8221	2.8321	2.8143	2.8161	3387804.0
2006-10-19 16:30:00	AAPL	Stock	2.8179	2.8243	2.8161	2.8214	678020.0
2006-10-19 17:00:00	AAPL	Stock	2.8211	2.8257	2.8211	2.8214	932680.0
2006-10-19 17:30:00	AAPL	Stock	2.8214	2.825	2.8211	2.825	617372.0
2006-10-19 18:00:00	AAPL	Stock	2.8246	2.825	2.8218	2.825	151480.0
2006-10-19 18:30:00	AAPL	Stock	2.8246	2.825	2.8218	2.825	150836.0
2006-10-19 19:00:00	AAPL	Stock	2.8232	2.8232	2.8218	2.8232	29680.0
2006-10-19 19:30:00	AAPL	Stock	2.8214	2.8214	2.8161	2.8161	143668.0
2006-10-19 07:30:00	MSFT	Stock	28.53	28.53	28.53	28.53	1500.0
2006-10-19 08:00:00	MSFT	Stock	28.48	28.54	28.48	28.48	9540.0
2006-10-19 08:30:00	MSFT	Stock	28.47	28.47	28.47	28.47	700.0
2006-10-19 09:00:00	MSFT	Stock	28.46	28.49	28.3	28.35	123603.0
2006-10-19 09:30:00	MSFT	Stock	28.35	28.41	28.26	28.31	6636760.0
2006-10-19 10:00:00	MSFT	Stock	28.32	28.41	28.26	28.39	4390592.0
2006-10-19 10:30:00	MSFT	Stock	28.39	28.451	28.33	28.33	2446917.0
2006-10-19 11:00:00	MSFT	Stock	28.34	28.34	28.18	28.21	4662665.0
2006-10-19 11:30:00	MSFT	Stock	28.2	28.26	28.19	28.2	3612042.0
2006-10-19 12:00:00	MSFT	Stock	28.2	28.28	28.17	28.21	2733312.0
2006-10-19 12:30:00	MSFT	Stock	28.22	28.24	28.14	28.18	2701625.0
2006-10-19 13:00:00	MSFT	Stock	28.21	28.24	28.12	28.22	2031927.0
2006-10-19 13:30:00	MSFT	Stock	28.21	28.22	28.15	28.16	1585427.0
2006-10-19 14:00:00	MSFT	Stock	28.151	28.19	28.14	28.18	1364337.0
2006-10-19 14:30:00	MSFT	Stock	28.19	28.23	28.15	28.22	2244322.0
2006-10-19 15:00:00	MSFT	Stock	28.22	28.25	28.18	28.18	2471822.0
2006-10-19 15:30:00	MSFT	Stock	28.182	28.33	28.18	28.32	5710449.0
2006-10-19 16:00:00	MSFT	Stock	28.32	28.36	28.28	28.31	94636.0
2006-10-19 16:30:00	MSFT	Stock	28.33	28.36	28.31	28.33	484917.0
2006-10-19 17:00:00	MSFT	Stock	28.32	28.32	28.32	28.32	600.0
2006-10-19 17:30:00	MSFT	Stock	28.36	28.37	28.28	28.37	6727.0
2006-10-19 18:00:00	MSFT	Stock	28.35	28.38	28.35	28.38	6015.0
2006-10-19 18:30:00	MSFT	Stock	28.33	28.33	28.33	28.33	100.0

> showing 50 of 50,412 rows — these rows as CSV

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