PREVIEW / stock_30min / 2010-04-28

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-28.parquet
  size:    1.4 MB
  rows:    74,675
  symbols: 3,476

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
2010-04-28 04:00:00	AAPL	Stock	9.1861	9.2746	9.1507	9.2143	139552.0
2010-04-28 04:30:00	AAPL	Stock	9.1893	9.1893	9.1425	9.1429	83132.0
2010-04-28 05:00:00	AAPL	Stock	9.1436	9.1607	9.1114	9.1114	78008.0
2010-04-28 05:30:00	AAPL	Stock	9.1254	9.1821	9.1125	9.1821	293944.0
2010-04-28 06:00:00	AAPL	Stock	9.1543	9.2321	9.1536	9.2232	344596.0
2010-04-28 06:30:00	AAPL	Stock	9.2232	9.2643	9.2139	9.2643	318836.0
2010-04-28 07:00:00	AAPL	Stock	9.2679	9.3221	9.2575	9.3125	1121484.0
2010-04-28 07:30:00	AAPL	Stock	9.3139	9.3714	9.305	9.3232	1086232.0
2010-04-28 08:00:00	AAPL	Stock	9.3325	9.4218	9.3271	9.4179	3481436.0
2010-04-28 08:30:00	AAPL	Stock	9.4139	9.4325	9.4107	9.4179	2204020.0
2010-04-28 09:00:00	AAPL	Stock	9.4196	9.4421	9.4029	9.4043	1602188.0
2010-04-28 09:30:00	AAPL	Stock	9.4018	9.4286	9.2946	9.305	111512884.0
2010-04-28 10:00:00	AAPL	Stock	9.305	9.32	9.1575	9.2437	165793964.0
2010-04-28 10:30:00	AAPL	Stock	9.2443	9.2525	9.1827	9.24	50323140.0
2010-04-28 11:00:00	AAPL	Stock	9.24	9.2971	9.2286	9.25	61785024.0
2010-04-28 11:30:00	AAPL	Stock	9.2486	9.2643	9.2071	9.2617	41493144.0
2010-04-28 12:00:00	AAPL	Stock	9.2611	9.32	9.2279	9.315	29415484.0
2010-04-28 12:30:00	AAPL	Stock	9.3177	9.3218	9.2768	9.3071	22703268.0
2010-04-28 13:00:00	AAPL	Stock	9.3061	9.3721	9.2921	9.338	34614216.0
2010-04-28 13:30:00	AAPL	Stock	9.3389	9.3657	9.3271	9.3482	18060868.0
2010-04-28 14:00:00	AAPL	Stock	9.3482	9.375	9.2989	9.3543	42807632.0
2010-04-28 14:30:00	AAPL	Stock	9.3559	9.3854	9.3221	9.3614	42382704.0
2010-04-28 15:00:00	AAPL	Stock	9.3629	9.3775	9.3379	9.3536	29442952.0
2010-04-28 15:30:00	AAPL	Stock	9.3543	9.3786	9.2954	9.3432	62174924.0
2010-04-28 16:00:00	AAPL	Stock	9.3432	9.3454	9.28	9.3449	8276492.0
2010-04-28 16:30:00	AAPL	Stock	9.3553	9.3553	9.2768	9.3	713972.0
2010-04-28 17:00:00	AAPL	Stock	9.2964	9.3464	9.2964	9.34	324156.0
2010-04-28 17:30:00	AAPL	Stock	9.3393	9.345	9.3304	9.3393	126896.0
2010-04-28 18:00:00	AAPL	Stock	9.3321	9.3429	9.3221	9.3286	104468.0
2010-04-28 18:30:00	AAPL	Stock	9.3282	9.3304	9.3082	9.315	234024.0
2010-04-28 19:00:00	AAPL	Stock	9.3179	9.3214	9.3089	9.3125	88340.0
2010-04-28 19:30:00	AAPL	Stock	9.3093	9.3204	9.3036	9.3036	295932.0
2010-04-28 04:30:00	MSFT	Stock	30.72	30.72	30.65	30.65	1715.0
2010-04-28 05:00:00	MSFT	Stock	30.64	30.64	30.64	30.64	120.0
2010-04-28 05:30:00	MSFT	Stock	30.6	30.6	30.56	30.56	949.0
2010-04-28 06:00:00	MSFT	Stock	30.57	30.57	30.57	30.57	300.0
2010-04-28 06:30:00	MSFT	Stock	30.72	30.72	30.72	30.72	699.0
2010-04-28 07:00:00	MSFT	Stock	30.8	30.89	30.79	30.89	2538.0
2010-04-28 08:00:00	MSFT	Stock	30.83	30.94	30.83	30.94	5362.0
2010-04-28 08:30:00	MSFT	Stock	30.93	30.94	30.9	30.94	16658.0
2010-04-28 09:00:00	MSFT	Stock	30.97	31.06	30.92	30.92	100957.0
2010-04-28 09:30:00	MSFT	Stock	30.92	30.95	30.74	30.78	5578465.0
2010-04-28 10:00:00	MSFT	Stock	30.779	30.93	30.71	30.881	6046597.0
2010-04-28 10:30:00	MSFT	Stock	30.88	30.9	30.78	30.83	4602913.0
2010-04-28 11:00:00	MSFT	Stock	30.83	30.93	30.62	30.71	5044511.0
2010-04-28 11:30:00	MSFT	Stock	30.71	30.93	30.69	30.82	5070081.0
2010-04-28 12:00:00	MSFT	Stock	30.815	30.93	30.73	30.91	3811705.0
2010-04-28 12:30:00	MSFT	Stock	30.91	30.92	30.85	30.88	1223636.0
2010-04-28 13:00:00	MSFT	Stock	30.89	30.95	30.86	30.882	1789590.0
2010-04-28 13:30:00	MSFT	Stock	30.88	30.9	30.84	30.879	970706.0

> showing 50 of 74,675 rows — these rows as CSV

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