PREVIEW / stock_5min / 2012-11-19

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-11-19.parquet
  size:    4.8 MB
  rows:    325,800
  symbols: 3,477

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
2012-11-19 04:00:00	AAPL	Stock	18.9375	19.1071	18.9375	19.1071	147000.0
2012-11-19 04:05:00	AAPL	Stock	19.1036	19.1036	19.0771	19.0771	9184.0
2012-11-19 04:20:00	AAPL	Stock	19.0768	19.0768	19.0768	19.0768	8120.0
2012-11-19 04:25:00	AAPL	Stock	19.0893	19.0893	19.0643	19.0714	29848.0
2012-11-19 04:30:00	AAPL	Stock	19.0643	19.0643	19.0643	19.0643	2800.0
2012-11-19 04:40:00	AAPL	Stock	19.0625	19.0625	19.0625	19.0625	2800.0
2012-11-19 04:45:00	AAPL	Stock	19.0657	19.0657	19.0657	19.0657	2800.0
2012-11-19 04:50:00	AAPL	Stock	19.0657	19.0786	19.0657	19.0786	22624.0
2012-11-19 04:55:00	AAPL	Stock	19.0768	19.0768	19.0768	19.0768	2800.0
2012-11-19 05:05:00	AAPL	Stock	19.0893	19.0893	19.0861	19.0861	25116.0
2012-11-19 05:10:00	AAPL	Stock	19.0982	19.0982	19.0982	19.0982	18704.0
2012-11-19 05:15:00	AAPL	Stock	19.1014	19.1014	19.0982	19.0982	20916.0
2012-11-19 05:20:00	AAPL	Stock	19.0946	19.1018	19.0946	19.1018	10304.0
2012-11-19 05:25:00	AAPL	Stock	19.0964	19.0964	19.0964	19.0964	2800.0
2012-11-19 05:30:00	AAPL	Stock	19.1018	19.1071	19.0893	19.0893	41748.0
2012-11-19 05:35:00	AAPL	Stock	19.0964	19.0964	19.0964	19.0964	2800.0
2012-11-19 05:40:00	AAPL	Stock	19.1075	19.1075	19.0982	19.0982	23744.0
2012-11-19 05:45:00	AAPL	Stock	19.0839	19.0839	19.075	19.075	119000.0
2012-11-19 05:50:00	AAPL	Stock	19.075	19.0893	19.0714	19.0714	110628.0
2012-11-19 06:00:00	AAPL	Stock	19.0786	19.0786	19.0786	19.0786	26320.0
2012-11-19 06:05:00	AAPL	Stock	19.0893	19.0893	19.0804	19.0804	8400.0
2012-11-19 06:10:00	AAPL	Stock	19.0875	19.0893	19.0875	19.0893	14000.0
2012-11-19 06:15:00	AAPL	Stock	19.0893	19.0893	19.0893	19.0893	8400.0
2012-11-19 06:20:00	AAPL	Stock	19.0893	19.0893	19.0893	19.0893	3332.0
2012-11-19 06:25:00	AAPL	Stock	19.0786	19.0786	19.0786	19.0786	2800.0
2012-11-19 06:30:00	AAPL	Stock	19.0786	19.0786	19.0768	19.0768	153860.0
2012-11-19 06:35:00	AAPL	Stock	19.0786	19.0818	19.0714	19.0818	147140.0
2012-11-19 06:40:00	AAPL	Stock	19.1036	19.1071	19.0818	19.1021	68600.0
2012-11-19 06:45:00	AAPL	Stock	19.0893	19.0996	19.0893	19.0996	30800.0
2012-11-19 06:50:00	AAPL	Stock	19.0911	19.0946	19.0825	19.0946	39200.0
2012-11-19 06:55:00	AAPL	Stock	19.0946	19.0996	19.0946	19.0996	8400.0
2012-11-19 07:00:00	AAPL	Stock	19.0996	19.1071	19.0832	19.1021	148232.0
2012-11-19 07:05:00	AAPL	Stock	19.1032	19.1161	19.1032	19.1161	99652.0
2012-11-19 07:10:00	AAPL	Stock	19.1161	19.1314	19.1071	19.1071	121016.0
2012-11-19 07:15:00	AAPL	Stock	19.1071	19.1179	19.0889	19.1179	199584.0
2012-11-19 07:20:00	AAPL	Stock	19.1018	19.1071	19.0861	19.0875	83580.0
2012-11-19 07:25:00	AAPL	Stock	19.0857	19.0907	19.0804	19.0804	49196.0
2012-11-19 07:30:00	AAPL	Stock	19.0818	19.0821	19.0664	19.0739	218288.0
2012-11-19 07:35:00	AAPL	Stock	19.0739	19.0871	19.0721	19.0854	94416.0
2012-11-19 07:40:00	AAPL	Stock	19.0821	19.0821	19.0589	19.0589	81004.0
2012-11-19 07:45:00	AAPL	Stock	19.0604	19.0661	19.0375	19.0536	126224.0
2012-11-19 07:50:00	AAPL	Stock	19.0539	19.0814	19.0539	19.0804	161924.0
2012-11-19 07:55:00	AAPL	Stock	19.075	19.0818	19.0675	19.0818	203728.0
2012-11-19 08:00:00	AAPL	Stock	19.0736	19.1321	19.0629	19.0896	845264.0
2012-11-19 08:05:00	AAPL	Stock	19.1	19.125	19.0918	19.1211	369712.0
2012-11-19 08:10:00	AAPL	Stock	19.1214	19.16	19.1214	19.15	440496.0
2012-11-19 08:15:00	AAPL	Stock	19.15	19.1786	19.1439	19.1786	507780.0
2012-11-19 08:20:00	AAPL	Stock	19.1782	19.1875	19.1539	19.1796	707112.0
2012-11-19 08:25:00	AAPL	Stock	19.1821	19.2004	19.1636	19.1754	817152.0
2012-11-19 08:30:00	AAPL	Stock	19.1729	19.1857	19.1614	19.175	353248.0

> showing 50 of 325,800 rows — these rows as CSV

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