PREVIEW / stock_30min / 2010-10-05

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-05.parquet
  size:    1.4 MB
  rows:    74,523
  symbols: 3,499

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-10-05 04:00:00	AAPL	Stock	10.0	10.0714	10.0	10.0714	7056.0
2010-10-05 04:30:00	AAPL	Stock	10.0643	10.0643	10.0643	10.0643	2800.0
2010-10-05 07:00:00	AAPL	Stock	10.0021	10.0318	10.0021	10.0318	14000.0
2010-10-05 07:30:00	AAPL	Stock	10.0096	10.0254	10.0096	10.0125	36120.0
2010-10-05 08:00:00	AAPL	Stock	10.0071	10.05	10.0057	10.0464	1272488.0
2010-10-05 08:30:00	AAPL	Stock	10.0457	10.0618	10.0357	10.0536	1612548.0
2010-10-05 09:00:00	AAPL	Stock	10.0564	10.0714	9.9514	10.0707	1964228.0
2010-10-05 09:30:00	AAPL	Stock	10.07	10.1893	10.065	10.1839	103323164.0
2010-10-05 10:00:00	AAPL	Stock	10.1857	10.2336	10.1689	10.2143	70717556.0
2010-10-05 10:30:00	AAPL	Stock	10.2139	10.2375	10.2082	10.2082	38273172.0
2010-10-05 11:00:00	AAPL	Stock	10.2104	10.2232	10.2036	10.2196	22787856.0
2010-10-05 11:30:00	AAPL	Stock	10.2182	10.25	10.2164	10.2382	27049036.0
2010-10-05 12:00:00	AAPL	Stock	10.2382	10.2411	10.2214	10.2271	13220732.0
2010-10-05 12:30:00	AAPL	Stock	10.2254	10.2472	10.2239	10.2439	11075036.0
2010-10-05 13:00:00	AAPL	Stock	10.2439	10.2604	10.2357	10.2421	18446372.0
2010-10-05 13:30:00	AAPL	Stock	10.2414	10.2536	10.2304	10.2525	13432160.0
2010-10-05 14:00:00	AAPL	Stock	10.2514	10.2586	10.2411	10.2496	11768428.0
2010-10-05 14:30:00	AAPL	Stock	10.25	10.2821	10.2496	10.2809	29864968.0
2010-10-05 15:00:00	AAPL	Stock	10.2821	10.3143	10.2754	10.3064	38481016.0
2010-10-05 15:30:00	AAPL	Stock	10.3075	10.3371	10.2939	10.3371	60182360.0
2010-10-05 16:00:00	AAPL	Stock	10.3325	10.3381	10.0751	10.3236	23545312.0
2010-10-05 16:30:00	AAPL	Stock	10.3236	10.3257	10.3014	10.325	387044.0
2010-10-05 17:00:00	AAPL	Stock	10.2381	10.3257	10.2381	10.3232	237328.0
2010-10-05 17:30:00	AAPL	Stock	10.325	10.3361	10.3214	10.3268	841680.0
2010-10-05 18:00:00	AAPL	Stock	10.3264	10.3304	10.3193	10.3304	468412.0
2010-10-05 18:30:00	AAPL	Stock	10.3314	10.3368	10.3314	10.3339	309512.0
2010-10-05 19:00:00	AAPL	Stock	10.3357	10.3368	10.3321	10.3325	172872.0
2010-10-05 19:30:00	AAPL	Stock	10.3336	10.3411	10.3325	10.3411	552860.0
2010-10-05 06:30:00	MSFT	Stock	23.98	23.98	23.9	23.9	4100.0
2010-10-05 07:00:00	MSFT	Stock	23.93	23.93	23.93	23.93	200.0
2010-10-05 07:30:00	MSFT	Stock	23.93	23.95	23.93	23.95	22300.0
2010-10-05 08:00:00	MSFT	Stock	23.95	24.05	23.95	24.05	21104.0
2010-10-05 08:30:00	MSFT	Stock	24.05	24.05	24.02	24.03	41706.0
2010-10-05 09:00:00	MSFT	Stock	24.03	24.2	23.91	24.07	307124.0
2010-10-05 09:30:00	MSFT	Stock	24.07	24.11	23.91	24.09	10476021.0
2010-10-05 10:00:00	MSFT	Stock	24.08	24.18	24.02	24.143	9255594.0
2010-10-05 10:30:00	MSFT	Stock	24.15	24.33	24.14	24.28	8191647.0
2010-10-05 11:00:00	MSFT	Stock	24.28	24.38	24.27	24.35	6378694.0
2010-10-05 11:30:00	MSFT	Stock	24.34	24.45	24.33	24.36	4513438.0
2010-10-05 12:00:00	MSFT	Stock	24.36	24.37	24.29	24.3	2867138.0
2010-10-05 12:30:00	MSFT	Stock	24.29	24.42	24.28	24.37	2130153.0
2010-10-05 13:00:00	MSFT	Stock	24.371	24.45	24.35	24.39	3195599.0
2010-10-05 13:30:00	MSFT	Stock	24.4	24.42	24.32	24.35	3181864.0
2010-10-05 14:00:00	MSFT	Stock	24.345	24.37	24.33	24.354	2307648.0
2010-10-05 14:30:00	MSFT	Stock	24.35	24.4	24.32	24.36	2978653.0
2010-10-05 15:00:00	MSFT	Stock	24.36	24.44	24.352	24.4	3974715.0
2010-10-05 15:30:00	MSFT	Stock	24.4	24.42	24.34	24.37	9593877.0
2010-10-05 16:00:00	MSFT	Stock	24.36	24.412	24.26	24.36	5381089.0
2010-10-05 16:30:00	MSFT	Stock	24.37	24.41	24.298	24.37	156103.0
2010-10-05 17:00:00	MSFT	Stock	24.33	24.38	24.33	24.38	1776.0

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

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