PREVIEW / stock_30min / 2010-05-11

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-05-11.parquet
  size:    1.4 MB
  rows:    76,284
  symbols: 3,484

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-05-11 04:00:00	AAPL	Stock	9.0536	9.0536	9.0071	9.0071	5600.0
2010-05-11 04:30:00	AAPL	Stock	8.9982	8.9982	8.9807	8.9807	21840.0
2010-05-11 05:30:00	AAPL	Stock	8.9493	8.9493	8.9293	8.9293	50120.0
2010-05-11 06:00:00	AAPL	Stock	8.9379	8.9643	8.9379	8.9643	16800.0
2010-05-11 06:30:00	AAPL	Stock	8.9693	8.9793	8.9382	8.9793	9380.0
2010-05-11 07:00:00	AAPL	Stock	8.9443	8.9696	8.9321	8.9696	455476.0
2010-05-11 07:30:00	AAPL	Stock	8.9779	8.9893	8.9625	8.9736	312032.0
2010-05-11 08:00:00	AAPL	Stock	8.9746	9.0071	8.9668	8.9921	1892436.0
2010-05-11 08:30:00	AAPL	Stock	8.9932	8.9932	8.9446	8.9554	2788380.0
2010-05-11 09:00:00	AAPL	Stock	8.9514	8.9957	8.94	8.9911	2353848.0
2010-05-11 09:30:00	AAPL	Stock	8.9943	9.0493	8.9464	9.0091	113358140.0
2010-05-11 10:00:00	AAPL	Stock	9.0089	9.0282	8.9746	9.0104	48604108.0
2010-05-11 10:30:00	AAPL	Stock	9.01	9.0807	8.9971	9.0571	56407036.0
2010-05-11 11:00:00	AAPL	Stock	9.0583	9.1679	9.0568	9.1669	77582400.0
2010-05-11 11:30:00	AAPL	Stock	9.1664	9.2286	9.1489	9.2111	78389948.0
2010-05-11 12:00:00	AAPL	Stock	9.2104	9.2625	9.2039	9.2302	59029488.0
2010-05-11 12:30:00	AAPL	Stock	9.2296	9.2807	9.2189	9.2675	45895360.0
2010-05-11 13:00:00	AAPL	Stock	9.2675	9.2732	9.2421	9.2571	33486236.0
2010-05-11 13:30:00	AAPL	Stock	9.2564	9.2818	9.2436	9.2739	39372144.0
2010-05-11 14:00:00	AAPL	Stock	9.274	9.2818	9.1964	9.2029	64350608.0
2010-05-11 14:30:00	AAPL	Stock	9.2025	9.21	9.1543	9.18	67988704.0
2010-05-11 15:00:00	AAPL	Stock	9.18	9.1801	9.1204	9.1557	59787364.0
2010-05-11 15:30:00	AAPL	Stock	9.1554	9.2107	9.1429	9.1632	73491964.0
2010-05-11 16:00:00	AAPL	Stock	9.1557	9.2045	9.1371	9.1411	9461424.0
2010-05-11 16:30:00	AAPL	Stock	9.1482	9.2132	9.135	9.135	1064196.0
2010-05-11 17:00:00	AAPL	Stock	9.1375	9.1429	9.0677	9.1336	848344.0
2010-05-11 17:30:00	AAPL	Stock	9.1286	9.1554	9.1286	9.1521	408156.0
2010-05-11 18:00:00	AAPL	Stock	9.1521	9.1614	9.1114	9.1114	702436.0
2010-05-11 18:30:00	AAPL	Stock	9.1089	9.1139	9.0993	9.1093	420196.0
2010-05-11 19:00:00	AAPL	Stock	9.1125	9.1229	9.1125	9.1214	236040.0
2010-05-11 19:30:00	AAPL	Stock	9.1146	9.1184	9.1075	9.1164	286972.0
2010-05-11 04:00:00	MSFT	Stock	28.88	28.88	28.88	28.88	200.0
2010-05-11 06:30:00	MSFT	Stock	28.63	28.63	28.63	28.63	1000.0
2010-05-11 07:00:00	MSFT	Stock	28.6	28.6	28.6	28.6	800.0
2010-05-11 07:30:00	MSFT	Stock	28.64	28.8	28.64	28.79	7213.0
2010-05-11 08:00:00	MSFT	Stock	28.71	28.79	28.63	28.65	5997.0
2010-05-11 08:30:00	MSFT	Stock	28.69	28.7	28.69	28.69	1340.0
2010-05-11 09:00:00	MSFT	Stock	28.69	28.72	28.63	28.69	55296.0
2010-05-11 09:30:00	MSFT	Stock	28.68	28.97	28.57	28.93	6304498.0
2010-05-11 10:00:00	MSFT	Stock	28.93	29.04	28.75	28.99	4470170.0
2010-05-11 10:30:00	MSFT	Stock	28.995	29.65	28.91	29.005	4303024.0
2010-05-11 11:00:00	MSFT	Stock	29.01	29.11	28.95	29.07	3253074.0
2010-05-11 11:30:00	MSFT	Stock	29.08	29.21	29.03	29.104	8785573.0
2010-05-11 12:00:00	MSFT	Stock	29.11	29.32	29.08	29.252	2914504.0
2010-05-11 12:30:00	MSFT	Stock	29.25	29.41	29.23	29.364	2486567.0
2010-05-11 13:00:00	MSFT	Stock	29.366	29.39	29.23	29.27	2690676.0
2010-05-11 13:30:00	MSFT	Stock	29.26	29.45	29.23	29.27	3534039.0
2010-05-11 14:00:00	MSFT	Stock	29.272	29.35	29.08	29.16	3969871.0
2010-05-11 14:30:00	MSFT	Stock	29.167	29.18	29.02	29.098	3817066.0
2010-05-11 15:00:00	MSFT	Stock	29.1	29.11	28.88	28.95	6159711.0

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

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