PREVIEW / stock_5min / 2012-08-31

all stock 5-min files

  file:    by_date/stock_5min/2012/2012-08-31.parquet
  size:    4.5 MB
  rows:    307,757
  symbols: 3,455

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-31 04:00:00	AAPL	Stock	23.6436	23.6436	23.6436	23.6436	2800.0
2012-08-31 04:10:00	AAPL	Stock	23.6457	23.6457	23.6457	23.6457	3024.0
2012-08-31 04:15:00	AAPL	Stock	23.6321	23.6321	23.6321	23.6321	8400.0
2012-08-31 04:25:00	AAPL	Stock	23.6289	23.6289	23.6286	23.6286	5600.0
2012-08-31 04:30:00	AAPL	Stock	23.6321	23.6321	23.6321	23.6321	2800.0
2012-08-31 04:45:00	AAPL	Stock	23.6229	23.6229	23.6229	23.6229	5600.0
2012-08-31 04:55:00	AAPL	Stock	23.6229	23.6229	23.6229	23.6229	2800.0
2012-08-31 05:25:00	AAPL	Stock	23.6214	23.6286	23.6214	23.6286	8680.0
2012-08-31 05:30:00	AAPL	Stock	23.6464	23.6536	23.6464	23.6536	8400.0
2012-08-31 05:35:00	AAPL	Stock	23.6536	23.6536	23.6536	23.6536	8400.0
2012-08-31 05:40:00	AAPL	Stock	23.65	23.6707	23.65	23.6707	11200.0
2012-08-31 05:50:00	AAPL	Stock	23.675	23.675	23.675	23.675	2800.0
2012-08-31 06:15:00	AAPL	Stock	23.6786	23.6954	23.6786	23.6954	9800.0
2012-08-31 07:00:00	AAPL	Stock	23.75	23.8214	23.7464	23.8107	129220.0
2012-08-31 07:05:00	AAPL	Stock	23.8107	23.8196	23.7893	23.7893	114100.0
2012-08-31 07:10:00	AAPL	Stock	23.785	23.7964	23.785	23.7964	19600.0
2012-08-31 07:15:00	AAPL	Stock	23.7964	23.8036	23.7964	23.8036	14000.0
2012-08-31 07:20:00	AAPL	Stock	23.8018	23.8018	23.7811	23.7811	30156.0
2012-08-31 07:25:00	AAPL	Stock	23.785	23.7854	23.785	23.7854	19600.0
2012-08-31 07:30:00	AAPL	Stock	23.7768	23.7857	23.7768	23.7857	12404.0
2012-08-31 07:35:00	AAPL	Stock	23.7857	23.7986	23.775	23.7946	135464.0
2012-08-31 07:40:00	AAPL	Stock	23.7936	23.8107	23.7929	23.8004	63000.0
2012-08-31 07:45:00	AAPL	Stock	23.7982	23.8025	23.7936	23.7943	50400.0
2012-08-31 07:50:00	AAPL	Stock	23.7954	23.8025	23.7954	23.8	14000.0
2012-08-31 07:55:00	AAPL	Stock	23.8	23.8136	23.8	23.8136	28280.0
2012-08-31 08:00:00	AAPL	Stock	23.8125	23.8125	23.7864	23.8	237076.0
2012-08-31 08:05:00	AAPL	Stock	23.7993	23.8	23.7857	23.7946	167944.0
2012-08-31 08:10:00	AAPL	Stock	23.7964	23.8104	23.7957	23.8104	80164.0
2012-08-31 08:15:00	AAPL	Stock	23.8104	23.8393	23.8104	23.8339	278264.0
2012-08-31 08:20:00	AAPL	Stock	23.8286	23.8464	23.8211	23.8429	317912.0
2012-08-31 08:25:00	AAPL	Stock	23.8464	23.8464	23.83	23.835	61740.0
2012-08-31 08:30:00	AAPL	Stock	23.8325	23.8446	23.8171	23.8375	321692.0
2012-08-31 08:35:00	AAPL	Stock	23.8389	23.8389	23.8254	23.8268	148428.0
2012-08-31 08:40:00	AAPL	Stock	23.8339	23.8375	23.825	23.8304	76300.0
2012-08-31 08:45:00	AAPL	Stock	23.8304	23.8554	23.8304	23.8536	382452.0
2012-08-31 08:50:00	AAPL	Stock	23.8557	23.8571	23.8393	23.8482	295008.0
2012-08-31 08:55:00	AAPL	Stock	23.8486	23.85	23.8393	23.8393	267316.0
2012-08-31 09:00:00	AAPL	Stock	23.8389	23.8393	23.8089	23.8125	433692.0
2012-08-31 09:05:00	AAPL	Stock	23.8139	23.8236	23.8139	23.8179	146300.0
2012-08-31 09:10:00	AAPL	Stock	23.8168	23.8168	23.8054	23.8125	198660.0
2012-08-31 09:15:00	AAPL	Stock	23.8118	23.8121	23.8061	23.8107	34580.0
2012-08-31 09:20:00	AAPL	Stock	23.8107	23.8196	23.8107	23.8146	63952.0
2012-08-31 09:25:00	AAPL	Stock	23.8154	23.8279	23.8154	23.8271	410620.0
2012-08-31 09:30:00	AAPL	Stock	23.8229	23.8571	23.7889	23.7979	12907440.0
2012-08-31 09:35:00	AAPL	Stock	23.8036	23.8104	23.7696	23.7896	7090888.0
2012-08-31 09:40:00	AAPL	Stock	23.7893	23.8	23.7282	23.7579	7256956.0
2012-08-31 09:45:00	AAPL	Stock	23.7504	23.7792	23.7461	23.76	4366600.0
2012-08-31 09:50:00	AAPL	Stock	23.76	23.7657	23.7186	23.7257	4412100.0
2012-08-31 09:55:00	AAPL	Stock	23.7254	23.7529	23.725	23.735	2798320.0
2012-08-31 10:00:00	AAPL	Stock	23.735	23.7493	23.6704	23.6804	9048508.0

> showing 50 of 307,757 rows — these rows as CSV

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