PREVIEW / stock_5min / 2010-07-14

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-07-14.parquet
  size:    4.6 MB
  rows:    317,536
  symbols: 3,426

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-07-14 05:40:00	AAPL	Stock	9.0714	9.0714	9.0714	9.0714	2800.0
2010-07-14 05:45:00	AAPL	Stock	9.0657	9.0657	9.0657	9.0657	2800.0
2010-07-14 05:50:00	AAPL	Stock	9.0657	9.0657	9.0657	9.0657	2800.0
2010-07-14 06:00:00	AAPL	Stock	9.0536	9.0536	9.0536	9.0536	8400.0
2010-07-14 06:35:00	AAPL	Stock	9.0429	9.0429	9.0429	9.0429	14000.0
2010-07-14 06:55:00	AAPL	Stock	9.0446	9.0446	9.0446	9.0446	2800.0
2010-07-14 07:00:00	AAPL	Stock	9.0446	9.0446	9.0411	9.0432	41720.0
2010-07-14 07:05:00	AAPL	Stock	9.0286	9.0286	9.0179	9.0179	8400.0
2010-07-14 07:10:00	AAPL	Stock	9.0111	9.0254	9.0111	9.0254	5600.0
2010-07-14 07:15:00	AAPL	Stock	9.0107	9.0111	9.0107	9.0107	11200.0
2010-07-14 07:25:00	AAPL	Stock	9.0179	9.0179	9.0179	9.0179	11200.0
2010-07-14 07:30:00	AAPL	Stock	9.0182	9.0264	9.0182	9.0264	8400.0
2010-07-14 07:35:00	AAPL	Stock	9.0268	9.0286	9.0268	9.0286	28000.0
2010-07-14 07:40:00	AAPL	Stock	9.0286	9.0286	9.0282	9.0286	11200.0
2010-07-14 07:45:00	AAPL	Stock	9.0268	9.0268	9.0214	9.0214	36400.0
2010-07-14 07:50:00	AAPL	Stock	9.0218	9.0246	9.0193	9.0196	47600.0
2010-07-14 07:55:00	AAPL	Stock	9.0246	9.0246	8.9725	8.9871	340536.0
2010-07-14 08:00:00	AAPL	Stock	8.9871	9.0125	8.9861	8.9964	501340.0
2010-07-14 08:05:00	AAPL	Stock	8.9896	8.9896	8.9643	8.9821	518000.0
2010-07-14 08:10:00	AAPL	Stock	8.9821	8.9893	8.9286	8.9293	617260.0
2010-07-14 08:15:00	AAPL	Stock	8.9304	8.9304	8.8689	8.8721	1315104.0
2010-07-14 08:20:00	AAPL	Stock	8.8718	8.9	8.87	8.8875	791728.0
2010-07-14 08:25:00	AAPL	Stock	8.8875	8.9104	8.8825	8.8825	529172.0
2010-07-14 08:30:00	AAPL	Stock	8.8825	8.9257	8.8786	8.925	627648.0
2010-07-14 08:35:00	AAPL	Stock	8.9211	8.9286	8.9129	8.9161	645120.0
2010-07-14 08:40:00	AAPL	Stock	8.9196	8.9221	8.9021	8.91	273084.0
2010-07-14 08:45:00	AAPL	Stock	8.9071	8.9071	8.8993	8.9071	278348.0
2010-07-14 08:50:00	AAPL	Stock	8.905	8.9057	8.8846	8.8875	277312.0
2010-07-14 08:55:00	AAPL	Stock	8.8886	8.8936	8.8789	8.8789	800100.0
2010-07-14 09:00:00	AAPL	Stock	8.8789	8.8875	8.8625	8.8636	1278116.0
2010-07-14 09:05:00	AAPL	Stock	8.8636	8.87	8.8507	8.8564	1062824.0
2010-07-14 09:10:00	AAPL	Stock	8.8546	8.8796	8.8507	8.8746	1429596.0
2010-07-14 09:15:00	AAPL	Stock	8.8761	8.8929	8.8761	8.8929	304864.0
2010-07-14 09:20:00	AAPL	Stock	8.8911	8.9	8.8889	8.8946	646800.0
2010-07-14 09:25:00	AAPL	Stock	8.8939	8.9196	8.8896	8.9061	765100.0
2010-07-14 09:30:00	AAPL	Stock	8.9054	8.9721	8.8929	8.9686	30628808.0
2010-07-14 09:35:00	AAPL	Stock	8.9692	9.0	8.9471	8.9732	25416356.0
2010-07-14 09:40:00	AAPL	Stock	8.9721	9.0104	8.9643	8.965	19993568.0
2010-07-14 09:45:00	AAPL	Stock	8.9643	8.9846	8.9411	8.9689	13980848.0
2010-07-14 09:50:00	AAPL	Stock	8.9689	8.9736	8.9321	8.9418	13117664.0
2010-07-14 09:55:00	AAPL	Stock	8.9414	8.9421	8.9164	8.9329	14225260.0
2010-07-14 10:00:00	AAPL	Stock	8.9329	8.9589	8.9225	8.9543	12418112.0
2010-07-14 10:05:00	AAPL	Stock	8.9539	8.9821	8.9375	8.9821	9642724.0
2010-07-14 10:10:00	AAPL	Stock	8.9821	9.0254	8.9807	9.0054	23230396.0
2010-07-14 10:15:00	AAPL	Stock	9.0032	9.0089	8.9857	8.9946	13189428.0
2010-07-14 10:20:00	AAPL	Stock	8.9971	9.0196	8.9921	9.0061	11951800.0
2010-07-14 10:25:00	AAPL	Stock	9.0082	9.0214	9.0	9.0154	9537220.0
2010-07-14 10:30:00	AAPL	Stock	9.015	9.0418	9.0054	9.0407	15017268.0
2010-07-14 10:35:00	AAPL	Stock	9.0404	9.0461	8.9704	9.0236	14270116.0
2010-07-14 10:40:00	AAPL	Stock	9.0243	9.0386	9.0196	9.0307	10789772.0

> showing 50 of 317,536 rows — these rows as CSV

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