PREVIEW / stock_30min / 2010-01-22

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-22.parquet
  size:    1.4 MB
  rows:    73,584
  symbols: 3,447

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-01-22 04:00:00	AAPL	Stock	7.4554	7.4554	7.4554	7.4554	2800.0
2010-01-22 05:30:00	AAPL	Stock	7.4389	7.4389	7.4311	7.4311	5600.0
2010-01-22 06:00:00	AAPL	Stock	7.4264	7.4264	7.4264	7.4264	5600.0
2010-01-22 06:30:00	AAPL	Stock	7.4143	7.4229	7.4021	7.4021	36848.0
2010-01-22 07:00:00	AAPL	Stock	7.395	7.4018	7.39	7.3911	49700.0
2010-01-22 07:30:00	AAPL	Stock	7.4018	7.41	7.3932	7.3932	42000.0
2010-01-22 08:00:00	AAPL	Stock	7.4232	7.4282	7.4054	7.4261	990108.0
2010-01-22 08:30:00	AAPL	Stock	7.4246	7.435	7.4179	7.4179	952644.0
2010-01-22 09:00:00	AAPL	Stock	7.4121	7.4346	7.3839	7.3846	2186548.0
2010-01-22 09:30:00	AAPL	Stock	7.385	7.4107	7.3232	7.3682	106722196.0
2010-01-22 10:00:00	AAPL	Stock	7.3641	7.3671	7.2596	7.3279	95051628.0
2010-01-22 10:30:00	AAPL	Stock	7.3257	7.3282	7.2825	7.2982	43168384.0
2010-01-22 11:00:00	AAPL	Stock	7.3	7.3368	7.2964	7.3264	37349732.0
2010-01-22 11:30:00	AAPL	Stock	7.3268	7.3346	7.2893	7.2961	28881496.0
2010-01-22 12:00:00	AAPL	Stock	7.2982	7.3157	7.2879	7.3107	23327360.0
2010-01-22 12:30:00	AAPL	Stock	7.3121	7.3121	7.2757	7.2787	26300344.0
2010-01-22 13:00:00	AAPL	Stock	7.2793	7.2857	7.2611	7.2621	28147252.0
2010-01-22 13:30:00	AAPL	Stock	7.2636	7.2746	7.25	7.2571	32510828.0
2010-01-22 14:00:00	AAPL	Stock	7.2568	7.2736	7.2382	7.2411	39105136.0
2010-01-22 14:30:00	AAPL	Stock	7.2411	7.2418	7.1496	7.1693	93102912.0
2010-01-22 15:00:00	AAPL	Stock	7.17	7.1889	7.0957	7.1018	104091232.0
2010-01-22 15:30:00	AAPL	Stock	7.1018	7.1125	7.0414	7.0629	164007172.0
2010-01-22 16:00:00	AAPL	Stock	7.0557	7.2287	7.0554	7.095	26858272.0
2010-01-22 16:30:00	AAPL	Stock	7.0999	7.3005	7.0911	7.1196	3666152.0
2010-01-22 17:00:00	AAPL	Stock	7.1205	7.1371	7.0564	7.1182	2422028.0
2010-01-22 17:30:00	AAPL	Stock	7.1196	7.1214	7.0875	7.1146	1504580.0
2010-01-22 18:00:00	AAPL	Stock	7.1193	7.1214	7.0625	7.0929	2082612.0
2010-01-22 18:30:00	AAPL	Stock	7.0929	7.1064	7.0929	7.0936	635124.0
2010-01-22 19:00:00	AAPL	Stock	7.0962	7.0964	7.0875	7.0875	428036.0
2010-01-22 19:30:00	AAPL	Stock	7.0862	7.0868	7.0754	7.0857	710136.0
2010-01-22 20:00:00	AAPL	Stock	7.3136	7.3136	7.3136	7.3136	14000.0
2010-01-22 04:00:00	MSFT	Stock	30.06	30.06	30.06	30.06	100.0
2010-01-22 04:30:00	MSFT	Stock	30.06	30.06	30.06	30.06	500.0
2010-01-22 05:30:00	MSFT	Stock	29.96	29.99	29.96	29.99	900.0
2010-01-22 06:30:00	MSFT	Stock	29.96	29.99	29.88	29.88	1675.0
2010-01-22 07:00:00	MSFT	Stock	29.9	29.9	29.9	29.9	4950.0
2010-01-22 08:00:00	MSFT	Stock	30.0	30.03	29.93	30.03	5700.0
2010-01-22 08:30:00	MSFT	Stock	30.03	30.03	30.01	30.01	2094.0
2010-01-22 09:00:00	MSFT	Stock	30.01	30.03	29.93	30.03	5262.0
2010-01-22 09:30:00	MSFT	Stock	30.0	30.2	29.91	30.01	8164191.0
2010-01-22 10:00:00	MSFT	Stock	30.012	30.03	29.73	29.9	8654028.0
2010-01-22 10:30:00	MSFT	Stock	29.89	29.98	29.77	29.9	4997837.0
2010-01-22 11:00:00	MSFT	Stock	29.909	29.99	29.76	29.8	5411363.0
2010-01-22 11:30:00	MSFT	Stock	29.8	29.877	29.74	29.86	4231969.0
2010-01-22 12:00:00	MSFT	Stock	29.865	29.94	29.83	29.91	4663395.0
2010-01-22 12:30:00	MSFT	Stock	29.908	29.93	29.79	29.85	4938003.0
2010-01-22 13:00:00	MSFT	Stock	29.85	29.88	29.785	29.84	2115059.0
2010-01-22 13:30:00	MSFT	Stock	29.84	29.85	29.58	29.6	6299498.0
2010-01-22 14:00:00	MSFT	Stock	29.6	29.78	29.44	29.52	5331870.0
2010-01-22 14:30:00	MSFT	Stock	29.51	29.7	29.18	29.2	8199448.0

> showing 50 of 73,584 rows — these rows as CSV

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