PREVIEW / stock_5min / 2010-04-28

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-04-28.parquet
  size:    4.9 MB
  rows:    331,046
  symbols: 3,476

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-04-28 04:05:00	AAPL	Stock	9.1861	9.1861	9.1861	9.1861	14000.0
2010-04-28 04:15:00	AAPL	Stock	9.1643	9.2746	9.1507	9.1507	108500.0
2010-04-28 04:20:00	AAPL	Stock	9.2007	9.2143	9.2007	9.2143	17052.0
2010-04-28 04:30:00	AAPL	Stock	9.1893	9.1893	9.1625	9.1625	8400.0
2010-04-28 04:45:00	AAPL	Stock	9.1432	9.1432	9.1425	9.1425	22008.0
2010-04-28 04:50:00	AAPL	Stock	9.1425	9.185	9.1425	9.1429	21924.0
2010-04-28 04:55:00	AAPL	Stock	9.1625	9.1625	9.1429	9.1429	30800.0
2010-04-28 05:00:00	AAPL	Stock	9.1436	9.1436	9.1414	9.1414	17696.0
2010-04-28 05:05:00	AAPL	Stock	9.1564	9.1607	9.1564	9.1607	23772.0
2010-04-28 05:15:00	AAPL	Stock	9.1286	9.1286	9.1286	9.1286	2800.0
2010-04-28 05:20:00	AAPL	Stock	9.1268	9.1268	9.1268	9.1268	2800.0
2010-04-28 05:25:00	AAPL	Stock	9.1254	9.1432	9.1114	9.1114	30940.0
2010-04-28 05:30:00	AAPL	Stock	9.1254	9.1257	9.1254	9.1257	19544.0
2010-04-28 05:35:00	AAPL	Stock	9.1125	9.1125	9.1125	9.1125	11200.0
2010-04-28 05:40:00	AAPL	Stock	9.1143	9.1143	9.1125	9.1125	45920.0
2010-04-28 05:45:00	AAPL	Stock	9.1214	9.1496	9.1214	9.1496	71400.0
2010-04-28 05:50:00	AAPL	Stock	9.1429	9.1804	9.1429	9.1786	120680.0
2010-04-28 05:55:00	AAPL	Stock	9.1536	9.1821	9.1536	9.1821	25200.0
2010-04-28 06:00:00	AAPL	Stock	9.1543	9.1964	9.1536	9.1964	76384.0
2010-04-28 06:05:00	AAPL	Stock	9.1786	9.2146	9.1786	9.2143	164948.0
2010-04-28 06:10:00	AAPL	Stock	9.225	9.2321	9.225	9.2321	39816.0
2010-04-28 06:15:00	AAPL	Stock	9.2321	9.2321	9.2018	9.2321	30520.0
2010-04-28 06:20:00	AAPL	Stock	9.2321	9.2321	9.215	9.215	16128.0
2010-04-28 06:25:00	AAPL	Stock	9.2321	9.2321	9.2232	9.2232	16800.0
2010-04-28 06:30:00	AAPL	Stock	9.2232	9.2411	9.2139	9.2214	35224.0
2010-04-28 06:35:00	AAPL	Stock	9.2321	9.2321	9.2321	9.2321	4200.0
2010-04-28 06:40:00	AAPL	Stock	9.2214	9.2361	9.2214	9.2361	19600.0
2010-04-28 06:45:00	AAPL	Stock	9.2429	9.2429	9.2393	9.2393	22400.0
2010-04-28 06:50:00	AAPL	Stock	9.2429	9.2589	9.2429	9.2554	171024.0
2010-04-28 06:55:00	AAPL	Stock	9.2507	9.2643	9.2507	9.2643	66388.0
2010-04-28 07:00:00	AAPL	Stock	9.2679	9.275	9.2575	9.275	80528.0
2010-04-28 07:05:00	AAPL	Stock	9.2739	9.2932	9.2739	9.2861	519876.0
2010-04-28 07:10:00	AAPL	Stock	9.2861	9.2861	9.275	9.2854	78456.0
2010-04-28 07:15:00	AAPL	Stock	9.2857	9.3114	9.275	9.3114	153356.0
2010-04-28 07:20:00	AAPL	Stock	9.3161	9.3221	9.2986	9.3179	73640.0
2010-04-28 07:25:00	AAPL	Stock	9.3125	9.3214	9.3125	9.3125	215628.0
2010-04-28 07:30:00	AAPL	Stock	9.3139	9.3318	9.3139	9.3175	330736.0
2010-04-28 07:35:00	AAPL	Stock	9.305	9.3232	9.305	9.3196	64400.0
2010-04-28 07:40:00	AAPL	Stock	9.3182	9.3389	9.3182	9.3321	165200.0
2010-04-28 07:45:00	AAPL	Stock	9.3371	9.3714	9.3357	9.355	383460.0
2010-04-28 07:50:00	AAPL	Stock	9.3493	9.3493	9.3214	9.3214	92036.0
2010-04-28 07:55:00	AAPL	Stock	9.3179	9.3339	9.3179	9.3232	50400.0
2010-04-28 08:00:00	AAPL	Stock	9.3325	9.385	9.3271	9.3714	758940.0
2010-04-28 08:05:00	AAPL	Stock	9.3664	9.3786	9.3661	9.3786	393148.0
2010-04-28 08:10:00	AAPL	Stock	9.3786	9.4054	9.3786	9.4054	433048.0
2010-04-28 08:15:00	AAPL	Stock	9.4054	9.4179	9.3964	9.4112	739144.0
2010-04-28 08:20:00	AAPL	Stock	9.4096	9.4161	9.4018	9.4071	683872.0
2010-04-28 08:25:00	AAPL	Stock	9.41	9.4218	9.4011	9.4179	473284.0
2010-04-28 08:30:00	AAPL	Stock	9.4139	9.4175	9.4107	9.4175	219800.0
2010-04-28 08:35:00	AAPL	Stock	9.4175	9.4232	9.4161	9.4196	322728.0

> showing 50 of 331,046 rows — these rows as CSV

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