PREVIEW / stock_30min / 2009-05-04

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-05-04.parquet
  size:    1.3 MB
  rows:    72,101
  symbols: 3,363

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
2009-05-04 06:00:00	AAPL	Stock	4.5696	4.585	4.5696	4.585	8400.0
2009-05-04 06:30:00	AAPL	Stock	4.585	4.585	4.585	4.585	2800.0
2009-05-04 07:30:00	AAPL	Stock	4.5518	4.5518	4.5518	4.5518	2800.0
2009-05-04 08:00:00	AAPL	Stock	4.5707	4.595	4.5707	4.5857	508200.0
2009-05-04 08:30:00	AAPL	Stock	4.5825	4.5825	4.5679	4.5711	283248.0
2009-05-04 09:00:00	AAPL	Stock	4.5711	4.5821	4.5679	4.5804	954072.0
2009-05-04 09:30:00	AAPL	Stock	4.5793	4.6038	4.56	4.5768	77397852.0
2009-05-04 10:00:00	AAPL	Stock	4.5782	4.6345	4.575	4.6343	61353488.0
2009-05-04 10:30:00	AAPL	Stock	4.6346	4.6414	4.6204	4.6268	33561584.0
2009-05-04 11:00:00	AAPL	Stock	4.6268	4.6425	4.6264	4.6357	27382656.0
2009-05-04 11:30:00	AAPL	Stock	4.6357	4.6393	4.6268	4.6393	20238092.0
2009-05-04 12:00:00	AAPL	Stock	4.6393	4.6496	4.6332	4.6454	37721544.0
2009-05-04 12:30:00	AAPL	Stock	4.6457	4.6732	4.6434	4.67	38868312.0
2009-05-04 13:00:00	AAPL	Stock	4.67	4.6954	4.67	4.6904	44655996.0
2009-05-04 13:30:00	AAPL	Stock	4.69	4.7143	4.6896	4.6986	47596332.0
2009-05-04 14:00:00	AAPL	Stock	4.6986	4.7054	4.6832	4.7029	34168232.0
2009-05-04 14:30:00	AAPL	Stock	4.7029	4.71	4.6964	4.6975	37869048.0
2009-05-04 15:00:00	AAPL	Stock	4.6982	4.7026	4.6786	4.6881	42743176.0
2009-05-04 15:30:00	AAPL	Stock	4.6882	4.7232	4.68	4.7211	70377720.0
2009-05-04 16:00:00	AAPL	Stock	4.715	4.7214	4.6393	4.7168	25500608.0
2009-05-04 16:30:00	AAPL	Stock	4.7026	4.7196	4.7026	4.7196	733908.0
2009-05-04 17:00:00	AAPL	Stock	4.7168	4.7179	4.7146	4.7175	270872.0
2009-05-04 17:30:00	AAPL	Stock	4.7168	4.7207	4.7168	4.7179	272160.0
2009-05-04 18:00:00	AAPL	Stock	4.7168	4.7196	4.7168	4.7196	1650320.0
2009-05-04 18:30:00	AAPL	Stock	4.7179	4.7196	4.7168	4.7179	68600.0
2009-05-04 19:00:00	AAPL	Stock	4.7193	4.7207	4.7186	4.7207	49000.0
2009-05-04 19:30:00	AAPL	Stock	4.7193	4.7232	4.7193	4.7232	89292.0
2009-05-04 07:00:00	MSFT	Stock	20.46	20.46	20.46	20.46	300.0
2009-05-04 07:30:00	MSFT	Stock	20.35	20.35	20.35	20.35	100.0
2009-05-04 08:00:00	MSFT	Stock	20.35	20.44	20.25	20.38	26022.0
2009-05-04 08:30:00	MSFT	Stock	20.36	20.36	20.34	20.35	17599.0
2009-05-04 09:00:00	MSFT	Stock	20.35	20.42	20.35	20.37	10698.0
2009-05-04 09:30:00	MSFT	Stock	20.37	20.4	19.98	20.02	8239086.0
2009-05-04 10:00:00	MSFT	Stock	20.02	20.34	19.99	20.3	6387139.0
2009-05-04 10:30:00	MSFT	Stock	20.3	20.3	20.09	20.112	3337655.0
2009-05-04 11:00:00	MSFT	Stock	20.12	20.28	20.11	20.25	3214611.0
2009-05-04 11:30:00	MSFT	Stock	20.25	20.28	20.13	20.16	1594979.0
2009-05-04 12:00:00	MSFT	Stock	20.16	20.22	20.05	20.09	2824244.0
2009-05-04 12:30:00	MSFT	Stock	20.09	20.16	20.06	20.15	2478348.0
2009-05-04 13:00:00	MSFT	Stock	20.15	20.19	20.09	20.19	1509382.0
2009-05-04 13:30:00	MSFT	Stock	20.19	20.2	20.135	20.19	2616870.0
2009-05-04 14:00:00	MSFT	Stock	20.19	20.23	20.08	20.21	3278389.0
2009-05-04 14:30:00	MSFT	Stock	20.21	20.22	20.08	20.11	3451588.0
2009-05-04 15:00:00	MSFT	Stock	20.108	20.16	20.08	20.118	3201948.0
2009-05-04 15:30:00	MSFT	Stock	20.12	20.24	20.06	20.24	8016456.0
2009-05-04 16:00:00	MSFT	Stock	20.25	20.26	20.104	20.23	2653011.0
2009-05-04 16:30:00	MSFT	Stock	20.23	20.25	20.23	20.24	98074.0
2009-05-04 17:00:00	MSFT	Stock	20.23	20.25	20.23	20.25	19330.0
2009-05-04 17:30:00	MSFT	Stock	20.25	20.25	20.21	20.21	4799.0
2009-05-04 18:00:00	MSFT	Stock	20.21	20.25	20.21	20.25	9342.0

> showing 50 of 72,101 rows — these rows as CSV

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