PREVIEW / stock_5min / 2012-08-17

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-08-17.parquet
  size:    4.5 MB
  rows:    306,746
  symbols: 3,480

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-08-17 04:10:00	AAPL	Stock	22.7214	22.7214	22.7214	22.7214	2800.0
2012-08-17 04:25:00	AAPL	Stock	22.7214	22.7214	22.7214	22.7214	8400.0
2012-08-17 04:35:00	AAPL	Stock	22.7214	22.7214	22.7214	22.7214	16800.0
2012-08-17 05:15:00	AAPL	Stock	22.7507	22.7507	22.7507	22.7507	8400.0
2012-08-17 05:20:00	AAPL	Stock	22.7493	22.7657	22.7493	22.7657	22400.0
2012-08-17 05:25:00	AAPL	Stock	22.7657	22.7657	22.7589	22.7589	8400.0
2012-08-17 05:30:00	AAPL	Stock	22.7589	22.7657	22.7589	22.7657	41440.0
2012-08-17 05:35:00	AAPL	Stock	22.7836	22.7843	22.7836	22.7843	44800.0
2012-08-17 05:40:00	AAPL	Stock	22.7843	22.7843	22.7657	22.7657	30240.0
2012-08-17 05:45:00	AAPL	Stock	22.7843	22.7843	22.7596	22.7596	11200.0
2012-08-17 05:50:00	AAPL	Stock	22.7643	22.7643	22.7643	22.7643	11200.0
2012-08-17 06:10:00	AAPL	Stock	22.7843	22.7843	22.7843	22.7843	5600.0
2012-08-17 06:15:00	AAPL	Stock	22.7843	22.7939	22.7843	22.7939	5600.0
2012-08-17 06:25:00	AAPL	Stock	22.7911	22.7943	22.7911	22.7943	11480.0
2012-08-17 06:35:00	AAPL	Stock	22.8118	22.8118	22.8118	22.8118	11200.0
2012-08-17 07:00:00	AAPL	Stock	22.7911	22.7964	22.7893	22.7911	61572.0
2012-08-17 07:05:00	AAPL	Stock	22.7911	22.7911	22.7804	22.7804	53200.0
2012-08-17 07:10:00	AAPL	Stock	22.7786	22.7786	22.7786	22.7786	29260.0
2012-08-17 07:15:00	AAPL	Stock	22.775	22.7804	22.775	22.7804	13916.0
2012-08-17 07:20:00	AAPL	Stock	22.79	22.7911	22.7857	22.7857	38192.0
2012-08-17 07:25:00	AAPL	Stock	22.7839	22.7857	22.7839	22.7854	34944.0
2012-08-17 07:30:00	AAPL	Stock	22.7821	22.7821	22.7818	22.7821	20860.0
2012-08-17 07:35:00	AAPL	Stock	22.7768	22.7768	22.7714	22.7764	23100.0
2012-08-17 07:40:00	AAPL	Stock	22.7761	22.7821	22.775	22.7786	78400.0
2012-08-17 07:45:00	AAPL	Stock	22.7807	22.7871	22.7804	22.7871	51828.0
2012-08-17 07:50:00	AAPL	Stock	22.7875	22.7946	22.7875	22.7946	65688.0
2012-08-17 07:55:00	AAPL	Stock	22.7946	22.8054	22.7911	22.8054	156576.0
2012-08-17 08:00:00	AAPL	Stock	22.8014	22.8118	22.7821	22.8018	475440.0
2012-08-17 08:05:00	AAPL	Stock	22.8086	22.8318	22.8025	22.8239	615216.0
2012-08-17 08:10:00	AAPL	Stock	22.8193	22.8286	22.8132	22.8139	184352.0
2012-08-17 08:15:00	AAPL	Stock	22.8064	22.8139	22.8061	22.8111	102900.0
2012-08-17 08:20:00	AAPL	Stock	22.8139	22.8161	22.7964	22.8029	62020.0
2012-08-17 08:25:00	AAPL	Stock	22.8029	22.8039	22.7911	22.7911	124796.0
2012-08-17 08:30:00	AAPL	Stock	22.7911	22.8007	22.7821	22.7889	433776.0
2012-08-17 08:35:00	AAPL	Stock	22.7925	22.8018	22.7925	22.7982	119280.0
2012-08-17 08:40:00	AAPL	Stock	22.8014	22.8071	22.7982	22.8036	165396.0
2012-08-17 08:45:00	AAPL	Stock	22.8029	22.8071	22.7946	22.7946	377692.0
2012-08-17 08:50:00	AAPL	Stock	22.7986	22.7986	22.7857	22.7946	128744.0
2012-08-17 08:55:00	AAPL	Stock	22.7939	22.7979	22.7264	22.7946	180880.0
2012-08-17 09:00:00	AAPL	Stock	22.7946	22.8464	22.7946	22.8414	712208.0
2012-08-17 09:05:00	AAPL	Stock	22.8429	22.8525	22.8393	22.8482	667576.0
2012-08-17 09:10:00	AAPL	Stock	22.8464	22.8661	22.84	22.8657	1112244.0
2012-08-17 09:15:00	AAPL	Stock	22.8614	22.8661	22.8464	22.8518	501312.0
2012-08-17 09:20:00	AAPL	Stock	22.8536	22.8571	22.8404	22.8464	305256.0
2012-08-17 09:25:00	AAPL	Stock	22.8436	22.8896	22.8057	22.815	4232788.0
2012-08-17 09:30:00	AAPL	Stock	22.8146	22.9221	22.8136	22.9036	47293568.0
2012-08-17 09:35:00	AAPL	Stock	22.9036	22.9214	22.8718	22.875	13925240.0
2012-08-17 09:40:00	AAPL	Stock	22.8782	22.9232	22.8754	22.9071	14700896.0
2012-08-17 09:45:00	AAPL	Stock	22.908	22.9486	22.9054	22.9396	15632960.0
2012-08-17 09:50:00	AAPL	Stock	22.9397	22.9414	22.9171	22.9375	6636364.0

> showing 50 of 306,746 rows — these rows as CSV

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