PREVIEW / stock_5min / 2009-09-18

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-09-18.parquet
  size:    4.9 MB
  rows:    335,861
  symbols: 3,400

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
2009-09-18 06:30:00	AAPL	Stock	6.5714	6.5714	6.5714	6.5714	13944.0
2009-09-18 06:45:00	AAPL	Stock	6.5796	6.6214	6.5543	6.6214	151200.0
2009-09-18 06:50:00	AAPL	Stock	6.6071	6.6214	6.6071	6.6207	89600.0
2009-09-18 06:55:00	AAPL	Stock	6.6071	6.6161	6.6071	6.6143	117600.0
2009-09-18 07:00:00	AAPL	Stock	6.6054	6.6054	6.605	6.6054	22400.0
2009-09-18 07:05:00	AAPL	Stock	6.6036	6.6143	6.6036	6.6143	136136.0
2009-09-18 07:10:00	AAPL	Stock	6.6182	6.6182	6.6118	6.6118	52500.0
2009-09-18 07:15:00	AAPL	Stock	6.6118	6.6118	6.6043	6.6043	148400.0
2009-09-18 07:20:00	AAPL	Stock	6.6036	6.6036	6.6036	6.6036	2800.0
2009-09-18 07:25:00	AAPL	Stock	6.6036	6.6036	6.6036	6.6036	11200.0
2009-09-18 07:35:00	AAPL	Stock	6.5993	6.6118	6.5993	6.6118	68600.0
2009-09-18 07:40:00	AAPL	Stock	6.6171	6.625	6.6086	6.6086	112280.0
2009-09-18 07:45:00	AAPL	Stock	6.6089	6.6089	6.6089	6.6089	5600.0
2009-09-18 07:50:00	AAPL	Stock	6.6164	6.6164	6.6164	6.6164	5600.0
2009-09-18 07:55:00	AAPL	Stock	6.6089	6.6125	6.6089	6.6125	12600.0
2009-09-18 08:00:00	AAPL	Stock	6.6082	6.6182	6.5936	6.6107	605752.0
2009-09-18 08:05:00	AAPL	Stock	6.6107	6.6179	6.6107	6.6143	294840.0
2009-09-18 08:10:00	AAPL	Stock	6.6157	6.6179	6.6107	6.6143	302652.0
2009-09-18 08:15:00	AAPL	Stock	6.6143	6.6143	6.6071	6.6071	271964.0
2009-09-18 08:20:00	AAPL	Stock	6.6039	6.6107	6.6025	6.6104	102200.0
2009-09-18 08:25:00	AAPL	Stock	6.6104	6.615	6.61	6.6107	121800.0
2009-09-18 08:30:00	AAPL	Stock	6.6139	6.6221	6.6139	6.6182	429016.0
2009-09-18 08:35:00	AAPL	Stock	6.6189	6.6196	6.6154	6.6179	137200.0
2009-09-18 08:40:00	AAPL	Stock	6.6214	6.6318	6.6214	6.6318	154840.0
2009-09-18 08:45:00	AAPL	Stock	6.6293	6.6293	6.625	6.625	521640.0
2009-09-18 08:50:00	AAPL	Stock	6.6268	6.6321	6.625	6.6289	170100.0
2009-09-18 08:55:00	AAPL	Stock	6.6271	6.6289	6.6268	6.6289	103516.0
2009-09-18 09:00:00	AAPL	Stock	6.63	6.6329	6.6275	6.6304	256480.0
2009-09-18 09:05:00	AAPL	Stock	6.6293	6.6357	6.6286	6.6339	712152.0
2009-09-18 09:10:00	AAPL	Stock	6.6357	6.6375	6.6304	6.6304	729400.0
2009-09-18 09:15:00	AAPL	Stock	6.6296	6.6296	6.6196	6.6239	356160.0
2009-09-18 09:20:00	AAPL	Stock	6.6225	6.6279	6.6221	6.625	208124.0
2009-09-18 09:25:00	AAPL	Stock	6.6246	6.6389	6.6246	6.6375	908180.0
2009-09-18 09:30:00	AAPL	Stock	6.6379	6.6575	6.6236	6.6568	102662112.0
2009-09-18 09:35:00	AAPL	Stock	6.6571	6.6589	6.6293	6.6357	20484688.0
2009-09-18 09:40:00	AAPL	Stock	6.6361	6.6464	6.6279	6.6411	14801892.0
2009-09-18 09:45:00	AAPL	Stock	6.6418	6.6514	6.6321	6.64	13548724.0
2009-09-18 09:50:00	AAPL	Stock	6.6329	6.655	6.6321	6.6482	10216640.0
2009-09-18 09:55:00	AAPL	Stock	6.6482	6.6625	6.6368	6.6557	13023724.0
2009-09-18 10:00:00	AAPL	Stock	6.6561	6.6575	6.6329	6.6425	12908280.0
2009-09-18 10:05:00	AAPL	Stock	6.6425	6.6436	6.6021	6.6193	22969912.0
2009-09-18 10:10:00	AAPL	Stock	6.6182	6.6207	6.6021	6.615	9951032.0
2009-09-18 10:15:00	AAPL	Stock	6.6146	6.6232	6.6107	6.618	9766148.0
2009-09-18 10:20:00	AAPL	Stock	6.6189	6.6339	6.6182	6.6293	7555212.0
2009-09-18 10:25:00	AAPL	Stock	6.63	6.6314	6.6096	6.6125	6135780.0
2009-09-18 10:30:00	AAPL	Stock	6.6111	6.6304	6.6107	6.6296	8047088.0
2009-09-18 10:35:00	AAPL	Stock	6.6304	6.6368	6.6225	6.6239	6168596.0
2009-09-18 10:40:00	AAPL	Stock	6.6239	6.6354	6.6239	6.6289	5102580.0
2009-09-18 10:45:00	AAPL	Stock	6.6286	6.6286	6.6071	6.6107	9026528.0
2009-09-18 10:50:00	AAPL	Stock	6.6107	6.6246	6.6054	6.62	8458324.0

> showing 50 of 335,861 rows — these rows as CSV

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