PREVIEW / stock_5min / 2010-06-21

all stock 5-min files

  file:    by_date/stock_5min/2010/2010-06-21.parquet
  size:    4.9 MB
  rows:    336,159
  symbols: 3,471

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-06-21 04:05:00	AAPL	Stock	9.9464	9.9464	9.9382	9.9393	42000.0
2010-06-21 04:10:00	AAPL	Stock	9.9382	9.9404	9.9382	9.9386	42000.0
2010-06-21 04:15:00	AAPL	Stock	9.9236	9.9536	9.9236	9.9536	8400.0
2010-06-21 04:20:00	AAPL	Stock	9.9336	9.9336	9.9329	9.9329	5600.0
2010-06-21 04:25:00	AAPL	Stock	9.9336	9.9357	9.9336	9.9357	5600.0
2010-06-21 04:30:00	AAPL	Stock	9.9375	9.9375	9.9375	9.9375	5600.0
2010-06-21 04:40:00	AAPL	Stock	9.9286	9.9286	9.9286	9.9286	2800.0
2010-06-21 04:45:00	AAPL	Stock	9.925	9.9286	9.8996	9.9286	19600.0
2010-06-21 05:10:00	AAPL	Stock	9.9286	9.9518	9.9286	9.9518	22400.0
2010-06-21 05:40:00	AAPL	Stock	9.9457	9.9457	9.9457	9.9457	8400.0
2010-06-21 05:45:00	AAPL	Stock	9.9107	9.9286	9.9096	9.9286	25200.0
2010-06-21 05:55:00	AAPL	Stock	9.9286	9.9286	9.9286	9.9286	5600.0
2010-06-21 06:00:00	AAPL	Stock	9.9454	9.9454	9.9454	9.9454	2800.0
2010-06-21 06:20:00	AAPL	Stock	9.9357	9.9357	9.9357	9.9357	11172.0
2010-06-21 06:30:00	AAPL	Stock	9.9461	9.9464	9.9461	9.9464	15764.0
2010-06-21 06:40:00	AAPL	Stock	9.95	9.95	9.9304	9.9304	48636.0
2010-06-21 07:00:00	AAPL	Stock	9.9429	9.95	9.9375	9.9461	99400.0
2010-06-21 07:05:00	AAPL	Stock	9.9536	9.9536	9.9529	9.9529	5600.0
2010-06-21 07:10:00	AAPL	Stock	9.9536	9.9589	9.9482	9.9554	218960.0
2010-06-21 07:15:00	AAPL	Stock	9.9536	9.9571	9.9446	9.9464	165676.0
2010-06-21 07:20:00	AAPL	Stock	9.9464	9.9518	9.9464	9.9518	31500.0
2010-06-21 07:25:00	AAPL	Stock	9.9514	9.9518	9.9514	9.9518	21140.0
2010-06-21 07:30:00	AAPL	Stock	9.9468	9.9589	9.9468	9.9589	22400.0
2010-06-21 07:35:00	AAPL	Stock	9.9529	9.9532	9.95	9.9532	22400.0
2010-06-21 07:40:00	AAPL	Stock	9.9507	9.9536	9.9446	9.9536	118580.0
2010-06-21 07:45:00	AAPL	Stock	9.9514	9.9529	9.9393	9.9393	67200.0
2010-06-21 07:50:00	AAPL	Stock	9.9393	9.9393	9.9286	9.9357	35700.0
2010-06-21 07:55:00	AAPL	Stock	9.9357	9.9357	9.9207	9.9286	45500.0
2010-06-21 08:00:00	AAPL	Stock	9.9279	9.9346	9.8929	9.9046	1061592.0
2010-06-21 08:05:00	AAPL	Stock	9.9046	9.9196	9.9029	9.9179	520044.0
2010-06-21 08:10:00	AAPL	Stock	9.915	9.9196	9.9125	9.9179	465276.0
2010-06-21 08:15:00	AAPL	Stock	9.9179	9.9196	9.9096	9.9107	269976.0
2010-06-21 08:20:00	AAPL	Stock	9.9096	9.9104	9.8929	9.8943	659932.0
2010-06-21 08:25:00	AAPL	Stock	9.8939	9.9043	9.8929	9.9043	754712.0
2010-06-21 08:30:00	AAPL	Stock	9.8968	9.9107	9.8968	9.9107	184828.0
2010-06-21 08:35:00	AAPL	Stock	9.9107	9.9107	9.9014	9.9014	99876.0
2010-06-21 08:40:00	AAPL	Stock	9.9014	9.9018	9.8929	9.895	326788.0
2010-06-21 08:45:00	AAPL	Stock	9.8971	9.9018	9.8861	9.8925	515760.0
2010-06-21 08:50:00	AAPL	Stock	9.8925	9.8979	9.8861	9.8929	318920.0
2010-06-21 08:55:00	AAPL	Stock	9.8929	9.8989	9.8925	9.8989	298564.0
2010-06-21 09:00:00	AAPL	Stock	9.8993	9.9179	9.8993	9.9157	820372.0
2010-06-21 09:05:00	AAPL	Stock	9.9168	9.925	9.9125	9.925	459480.0
2010-06-21 09:10:00	AAPL	Stock	9.9239	9.9311	9.9232	9.9232	961100.0
2010-06-21 09:15:00	AAPL	Stock	9.9221	9.9261	9.9182	9.9232	218400.0
2010-06-21 09:20:00	AAPL	Stock	9.9232	9.9261	9.9168	9.925	391664.0
2010-06-21 09:25:00	AAPL	Stock	9.925	9.925	9.9071	9.9196	557788.0
2010-06-21 09:30:00	AAPL	Stock	9.9186	9.9314	9.9021	9.9271	20924820.0
2010-06-21 09:35:00	AAPL	Stock	9.9267	9.9375	9.9168	9.9299	16474472.0
2010-06-21 09:40:00	AAPL	Stock	9.9279	9.9461	9.9164	9.9382	16956772.0
2010-06-21 09:45:00	AAPL	Stock	9.9396	9.9454	9.9182	9.9393	14053256.0

> showing 50 of 336,159 rows — these rows as CSV

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