PREVIEW / stock_5min / 2011-04-08

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-04-08.parquet
  size:    4.8 MB
  rows:    321,742
  symbols: 3,529

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
2011-04-08 04:20:00	AAPL	Stock	12.1214	12.1214	12.1214	12.1214	28000.0
2011-04-08 05:00:00	AAPL	Stock	12.1243	12.1243	12.1243	12.1243	2800.0
2011-04-08 05:35:00	AAPL	Stock	12.1429	12.1429	12.1429	12.1429	2800.0
2011-04-08 05:45:00	AAPL	Stock	12.1429	12.1429	12.1429	12.1429	7000.0
2011-04-08 05:50:00	AAPL	Stock	12.1429	12.1429	12.1429	12.1429	2800.0
2011-04-08 06:40:00	AAPL	Stock	12.125	12.125	12.125	12.125	8120.0
2011-04-08 06:45:00	AAPL	Stock	12.1421	12.1421	12.1421	12.1421	2800.0
2011-04-08 07:00:00	AAPL	Stock	12.1286	12.1425	12.1286	12.1411	28000.0
2011-04-08 07:05:00	AAPL	Stock	12.1464	12.1464	12.1425	12.1425	5600.0
2011-04-08 07:10:00	AAPL	Stock	12.1393	12.1393	12.1321	12.1321	8400.0
2011-04-08 07:15:00	AAPL	Stock	12.1254	12.1393	12.125	12.1393	11200.0
2011-04-08 07:20:00	AAPL	Stock	12.1268	12.1268	12.1268	12.1268	2800.0
2011-04-08 07:25:00	AAPL	Stock	12.1339	12.1339	12.1339	12.1339	7280.0
2011-04-08 07:30:00	AAPL	Stock	12.1318	12.1318	12.1268	12.1318	42000.0
2011-04-08 07:35:00	AAPL	Stock	12.125	12.1304	12.125	12.1268	8400.0
2011-04-08 07:40:00	AAPL	Stock	12.1304	12.1304	12.125	12.1268	15400.0
2011-04-08 07:45:00	AAPL	Stock	12.1282	12.1389	12.1282	12.1375	30800.0
2011-04-08 07:50:00	AAPL	Stock	12.1425	12.1711	12.1425	12.1654	182056.0
2011-04-08 07:55:00	AAPL	Stock	12.1621	12.1671	12.1518	12.1589	115248.0
2011-04-08 08:00:00	AAPL	Stock	12.1582	12.1589	12.145	12.1543	201376.0
2011-04-08 08:05:00	AAPL	Stock	12.1546	12.1561	12.1429	12.1429	102340.0
2011-04-08 08:10:00	AAPL	Stock	12.1429	12.1518	12.1429	12.1518	42000.0
2011-04-08 08:15:00	AAPL	Stock	12.1518	12.1571	12.1482	12.1536	159124.0
2011-04-08 08:20:00	AAPL	Stock	12.1568	12.1568	12.1557	12.1568	26600.0
2011-04-08 08:25:00	AAPL	Stock	12.15	12.15	12.1404	12.1404	81200.0
2011-04-08 08:30:00	AAPL	Stock	12.1379	12.1379	12.1296	12.1296	116480.0
2011-04-08 08:35:00	AAPL	Stock	12.1339	12.1429	12.1286	12.1393	74340.0
2011-04-08 08:40:00	AAPL	Stock	12.1325	12.1325	12.1286	12.1304	72660.0
2011-04-08 08:45:00	AAPL	Stock	12.1286	12.1286	12.1286	12.1286	11200.0
2011-04-08 08:50:00	AAPL	Stock	12.1286	12.1304	12.125	12.1304	88396.0
2011-04-08 08:55:00	AAPL	Stock	12.1286	12.1511	12.1286	12.1482	117936.0
2011-04-08 09:00:00	AAPL	Stock	12.145	12.145	12.1264	12.1357	57204.0
2011-04-08 09:05:00	AAPL	Stock	12.1389	12.1429	12.1364	12.1364	30800.0
2011-04-08 09:10:00	AAPL	Stock	12.1429	12.1432	12.1393	12.1421	22960.0
2011-04-08 09:15:00	AAPL	Stock	12.1346	12.1357	12.1346	12.1357	5600.0
2011-04-08 09:20:00	AAPL	Stock	12.1339	12.1407	12.1321	12.1393	20020.0
2011-04-08 09:25:00	AAPL	Stock	12.1393	12.1486	12.1393	12.1432	395500.0
2011-04-08 09:30:00	AAPL	Stock	12.1432	12.1482	12.1	12.1086	13001772.0
2011-04-08 09:35:00	AAPL	Stock	12.1081	12.1154	12.0625	12.0639	9100756.0
2011-04-08 09:40:00	AAPL	Stock	12.0637	12.0868	12.0464	12.0804	12128816.0
2011-04-08 09:45:00	AAPL	Stock	12.0807	12.0839	12.0479	12.0596	6611556.0
2011-04-08 09:50:00	AAPL	Stock	12.0604	12.0625	12.0357	12.0414	7923328.0
2011-04-08 09:55:00	AAPL	Stock	12.0399	12.0639	12.0288	12.0557	6467748.0
2011-04-08 10:00:00	AAPL	Stock	12.0571	12.0657	12.0357	12.0475	6116796.0
2011-04-08 10:05:00	AAPL	Stock	12.0475	12.0589	12.0357	12.0407	5553604.0
2011-04-08 10:10:00	AAPL	Stock	12.04	12.0675	12.0393	12.0616	3905804.0
2011-04-08 10:15:00	AAPL	Stock	12.0611	12.0714	12.0307	12.0425	7018312.0
2011-04-08 10:20:00	AAPL	Stock	12.0429	12.0429	12.0064	12.0288	10313156.0
2011-04-08 10:25:00	AAPL	Stock	12.0286	12.0374	12.0196	12.0257	3585932.0
2011-04-08 10:30:00	AAPL	Stock	12.0264	12.0357	12.0118	12.0164	4814992.0

> showing 50 of 321,742 rows — these rows as CSV

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