PREVIEW / stock_30min / 2010-06-04

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-06-04.parquet
  size:    1.4 MB
  rows:    76,274
  symbols: 3,472

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-06-04 04:00:00	AAPL	Stock	9.4279	9.4279	9.4279	9.4279	8400.0
2010-06-04 05:00:00	AAPL	Stock	9.425	9.425	9.425	9.425	23772.0
2010-06-04 06:00:00	AAPL	Stock	9.4375	9.4554	9.4375	9.4554	11200.0
2010-06-04 06:30:00	AAPL	Stock	9.4196	9.4196	9.4071	9.4071	32900.0
2010-06-04 07:00:00	AAPL	Stock	9.4018	9.4182	9.3539	9.3661	116452.0
2010-06-04 07:30:00	AAPL	Stock	9.3661	9.3661	9.31	9.3179	364308.0
2010-06-04 08:00:00	AAPL	Stock	9.3214	9.3661	9.3214	9.3586	1400196.0
2010-06-04 08:30:00	AAPL	Stock	9.3511	9.3511	9.2146	9.2357	9808540.0
2010-06-04 09:00:00	AAPL	Stock	9.2368	9.2387	9.1821	9.2207	4194820.0
2010-06-04 09:30:00	AAPL	Stock	9.2218	9.3525	9.1821	9.32	124578776.0
2010-06-04 10:00:00	AAPL	Stock	9.3196	9.3536	9.2929	9.3346	63648900.0
2010-06-04 10:30:00	AAPL	Stock	9.3343	9.3393	9.2879	9.2925	41841968.0
2010-06-04 11:00:00	AAPL	Stock	9.2914	9.3086	9.2536	9.2643	48660696.0
2010-06-04 11:30:00	AAPL	Stock	9.265	9.2982	9.2536	9.2818	35922376.0
2010-06-04 12:00:00	AAPL	Stock	9.2807	9.2807	9.2461	9.2536	35564256.0
2010-06-04 12:30:00	AAPL	Stock	9.2539	9.2796	9.2389	9.2786	26134472.0
2010-06-04 13:00:00	AAPL	Stock	9.2789	9.2814	9.2164	9.2273	32645088.0
2010-06-04 13:30:00	AAPL	Stock	9.2275	9.2357	9.2011	9.2096	35879760.0
2010-06-04 14:00:00	AAPL	Stock	9.2071	9.2243	9.1807	9.1986	41817664.0
2010-06-04 14:30:00	AAPL	Stock	9.1968	9.2118	9.1471	9.1514	55216476.0
2010-06-04 15:00:00	AAPL	Stock	9.1521	9.1689	9.1154	9.1201	70437080.0
2010-06-04 15:30:00	AAPL	Stock	9.1206	9.1614	9.0939	9.1459	106030904.0
2010-06-04 16:00:00	AAPL	Stock	9.1414	9.1766	9.1289	9.1421	14347704.0
2010-06-04 16:30:00	AAPL	Stock	9.1425	9.1607	9.1255	9.1571	2006620.0
2010-06-04 17:00:00	AAPL	Stock	9.1536	9.1571	9.1364	9.1464	732396.0
2010-06-04 17:30:00	AAPL	Stock	9.1496	9.1571	9.1418	9.1518	316680.0
2010-06-04 18:00:00	AAPL	Stock	9.1468	9.1536	9.1375	9.1389	1019200.0
2010-06-04 18:30:00	AAPL	Stock	9.1382	9.1489	9.1382	9.1404	231896.0
2010-06-04 19:00:00	AAPL	Stock	9.1411	9.1411	9.1307	9.1375	140224.0
2010-06-04 19:30:00	AAPL	Stock	9.1079	9.14	9.1071	9.1143	384664.0
2010-06-04 07:30:00	MSFT	Stock	26.62	26.62	26.61	26.61	400.0
2010-06-04 08:00:00	MSFT	Stock	26.69	26.7	26.59	26.59	6898.0
2010-06-04 08:30:00	MSFT	Stock	26.59	26.63	26.25	26.25	27427.0
2010-06-04 09:00:00	MSFT	Stock	26.29	26.3	26.08	26.1	111055.0
2010-06-04 09:30:00	MSFT	Stock	26.1	26.43	26.03	26.24	13893689.0
2010-06-04 10:00:00	MSFT	Stock	26.24	26.57	26.23	26.54	5850411.0
2010-06-04 10:30:00	MSFT	Stock	26.54	26.55	26.24	26.28	4221933.0
2010-06-04 11:00:00	MSFT	Stock	26.28	26.42	26.26	26.295	3183607.0
2010-06-04 11:30:00	MSFT	Stock	26.3	26.43	26.28	26.36	3518346.0
2010-06-04 12:00:00	MSFT	Stock	26.362	26.37	26.22	26.25	4724569.0
2010-06-04 12:30:00	MSFT	Stock	26.24	26.28	26.18	26.27	2207670.0
2010-06-04 13:00:00	MSFT	Stock	26.26	26.27	26.09	26.17	2980029.0
2010-06-04 13:30:00	MSFT	Stock	26.17	26.18	25.97	26.01	3830620.0
2010-06-04 14:00:00	MSFT	Stock	26.005	26.11	25.99	26.04	4253591.0
2010-06-04 14:30:00	MSFT	Stock	26.04	26.1	25.84	25.86	6233984.0
2010-06-04 15:00:00	MSFT	Stock	25.86	25.92	25.79	25.802	8230722.0
2010-06-04 15:30:00	MSFT	Stock	25.8	25.85	25.62	25.78	20838988.0
2010-06-04 16:00:00	MSFT	Stock	25.78	26.835	25.69	25.83	3920491.0
2010-06-04 16:30:00	MSFT	Stock	25.72	26.023	25.69	25.71	400844.0
2010-06-04 17:00:00	MSFT	Stock	26.85	26.85	25.7	25.74	1868.0

> showing 50 of 76,274 rows — these rows as CSV

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