PREVIEW / stock_30min / 2007-04-02

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-04-02.parquet
  size:    1.0 MB
  rows:    56,082
  symbols: 2,562

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
2007-04-02 05:00:00	AAPL	Stock	3.36	3.36	3.3571	3.3571	14840.0
2007-04-02 07:30:00	AAPL	Stock	3.3468	3.3571	3.3454	3.3571	292880.0
2007-04-02 08:00:00	AAPL	Stock	3.3471	3.3554	3.3182	3.3482	1280384.0
2007-04-02 08:30:00	AAPL	Stock	3.3486	3.3486	3.3357	3.3429	1392552.0
2007-04-02 09:00:00	AAPL	Stock	3.3436	3.37	3.3436	3.3625	6388228.0
2007-04-02 09:30:00	AAPL	Stock	3.3636	3.3661	3.3357	3.3475	90632780.0
2007-04-02 10:00:00	AAPL	Stock	3.3479	3.3479	3.3221	3.3339	78798440.0
2007-04-02 10:30:00	AAPL	Stock	3.3339	3.3514	3.3321	3.3496	50333612.0
2007-04-02 11:00:00	AAPL	Stock	3.3496	3.3525	3.3418	3.3425	33215112.0
2007-04-02 11:30:00	AAPL	Stock	3.3422	3.35	3.3339	3.3421	27032964.0
2007-04-02 12:00:00	AAPL	Stock	3.3421	3.35	3.3389	3.3432	19558280.0
2007-04-02 12:30:00	AAPL	Stock	3.3432	3.3493	3.3368	3.3389	16951872.0
2007-04-02 13:00:00	AAPL	Stock	3.3396	3.3432	3.3318	3.3332	22769936.0
2007-04-02 13:30:00	AAPL	Stock	3.3329	3.3389	3.3282	3.3289	20293868.0
2007-04-02 14:00:00	AAPL	Stock	3.3286	3.3318	3.3229	3.3275	30061164.0
2007-04-02 14:30:00	AAPL	Stock	3.3275	3.3361	3.325	3.3346	21487788.0
2007-04-02 15:00:00	AAPL	Stock	3.3346	3.3443	3.3329	3.3389	30125424.0
2007-04-02 15:30:00	AAPL	Stock	3.3389	3.3439	3.3321	3.3439	38555720.0
2007-04-02 16:00:00	AAPL	Stock	3.3436	3.3446	3.3379	3.3446	5132960.0
2007-04-02 16:30:00	AAPL	Stock	3.3421	3.3446	3.3411	3.3414	240800.0
2007-04-02 17:00:00	AAPL	Stock	3.3425	3.3429	3.3414	3.3414	188048.0
2007-04-02 17:30:00	AAPL	Stock	3.3425	3.3425	3.3425	3.3425	2800.0
2007-04-02 18:00:00	AAPL	Stock	3.3414	3.3418	3.3379	3.3418	110880.0
2007-04-02 18:30:00	AAPL	Stock	3.3396	3.3418	3.3379	3.3386	83188.0
2007-04-02 19:00:00	AAPL	Stock	3.3386	3.3386	3.3386	3.3386	4200.0
2007-04-02 19:30:00	AAPL	Stock	3.3396	3.3429	3.3396	3.3429	131600.0
2007-04-02 08:00:00	MSFT	Stock	27.9	27.9	27.85	27.85	5350.0
2007-04-02 08:30:00	MSFT	Stock	27.87	27.87	27.82	27.82	8300.0
2007-04-02 09:00:00	MSFT	Stock	27.85	27.93	27.84	27.87	20513.0
2007-04-02 09:30:00	MSFT	Stock	27.89	27.93	27.78	27.86	3472227.0
2007-04-02 10:00:00	MSFT	Stock	27.86	27.87	27.62	27.77	4284845.0
2007-04-02 10:30:00	MSFT	Stock	27.77	27.8	27.67	27.71	2825683.0
2007-04-02 11:00:00	MSFT	Stock	27.7	27.74	27.68	27.712	1649865.0
2007-04-02 11:30:00	MSFT	Stock	27.71	27.78	27.69	27.72	1484644.0
2007-04-02 12:00:00	MSFT	Stock	27.71	27.73	27.67	27.72	2237528.0
2007-04-02 12:30:00	MSFT	Stock	27.718	27.74	27.59	27.62	2987090.0
2007-04-02 13:00:00	MSFT	Stock	27.61	27.72	27.61	27.67	1793075.0
2007-04-02 13:30:00	MSFT	Stock	27.67	27.672	27.61	27.62	1752512.0
2007-04-02 14:00:00	MSFT	Stock	27.62	27.68	27.56	27.643	2603000.0
2007-04-02 14:30:00	MSFT	Stock	27.64	27.66	27.61	27.62	1587890.0
2007-04-02 15:00:00	MSFT	Stock	27.62	27.7	27.61	27.68	2603401.0
2007-04-02 15:30:00	MSFT	Stock	27.69	27.73	27.63	27.73	6519271.0
2007-04-02 16:00:00	MSFT	Stock	27.74	27.74	27.72	27.74	127894.0
2007-04-02 16:30:00	MSFT	Stock	27.74	27.75	27.73	27.74	3888730.0
2007-04-02 17:00:00	MSFT	Stock	27.73	27.74	27.7	27.74	8250.0
2007-04-02 18:00:00	MSFT	Stock	27.74	27.74	27.74	27.74	3500.0
2007-04-02 08:30:00	NVDA	Stock	0.4755	0.4755	0.4755	0.4755	6000.0
2007-04-02 09:00:00	NVDA	Stock	0.4792	0.4793	0.4742	0.4785	645480.0
2007-04-02 09:30:00	NVDA	Stock	0.4773	0.4825	0.4767	0.479	40299000.0
2007-04-02 10:00:00	NVDA	Stock	0.479	0.479	0.4723	0.474	60246240.0

> showing 50 of 56,082 rows — these rows as CSV

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