PREVIEW / stock_5min / 2009-06-23

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-06-23.parquet
  size:    4.6 MB
  rows:    317,399
  symbols: 3,356

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-06-23 04:15:00	AAPL	Stock	4.9061	4.9061	4.9061	4.9061	2800.0
2009-06-23 05:10:00	AAPL	Stock	4.9268	4.9268	4.9268	4.9268	5012.0
2009-06-23 06:40:00	AAPL	Stock	4.9268	4.9268	4.9268	4.9268	21392.0
2009-06-23 06:50:00	AAPL	Stock	4.9279	4.9279	4.9279	4.9279	30408.0
2009-06-23 07:05:00	AAPL	Stock	4.9139	4.9139	4.9139	4.9139	2800.0
2009-06-23 07:10:00	AAPL	Stock	4.9132	4.9132	4.9061	4.9061	41720.0
2009-06-23 07:20:00	AAPL	Stock	4.91	4.91	4.91	4.91	5600.0
2009-06-23 07:25:00	AAPL	Stock	4.9107	4.9107	4.9107	4.9107	2800.0
2009-06-23 07:40:00	AAPL	Stock	4.9129	4.9129	4.9129	4.9129	2800.0
2009-06-23 07:45:00	AAPL	Stock	4.9157	4.9161	4.9157	4.9161	11200.0
2009-06-23 07:50:00	AAPL	Stock	4.9171	4.9171	4.9089	4.9089	64400.0
2009-06-23 07:55:00	AAPL	Stock	4.9125	4.9125	4.9071	4.9071	16100.0
2009-06-23 08:00:00	AAPL	Stock	4.9114	4.9114	4.88	4.8957	360164.0
2009-06-23 08:05:00	AAPL	Stock	4.8896	4.8939	4.8857	4.8939	135464.0
2009-06-23 08:10:00	AAPL	Stock	4.8939	4.9004	4.8939	4.8996	185724.0
2009-06-23 08:15:00	AAPL	Stock	4.8982	4.905	4.8982	4.9	215488.0
2009-06-23 08:20:00	AAPL	Stock	4.8932	4.8932	4.8821	4.8821	102200.0
2009-06-23 08:25:00	AAPL	Stock	4.8854	4.895	4.8854	4.895	99736.0
2009-06-23 08:30:00	AAPL	Stock	4.8921	4.8954	4.8861	4.8861	105700.0
2009-06-23 08:35:00	AAPL	Stock	4.8914	4.8918	4.8857	4.8893	138012.0
2009-06-23 08:40:00	AAPL	Stock	4.8864	4.8864	4.8786	4.8786	180768.0
2009-06-23 08:45:00	AAPL	Stock	4.8818	4.8832	4.8775	4.8804	96572.0
2009-06-23 08:50:00	AAPL	Stock	4.8821	4.8896	4.8821	4.8896	120764.0
2009-06-23 08:55:00	AAPL	Stock	4.8918	4.8918	4.8893	4.8893	34860.0
2009-06-23 09:00:00	AAPL	Stock	4.8875	4.8914	4.8864	4.8864	232344.0
2009-06-23 09:05:00	AAPL	Stock	4.8864	4.8893	4.8786	4.8786	235200.0
2009-06-23 09:10:00	AAPL	Stock	4.8789	4.8864	4.875	4.8804	542836.0
2009-06-23 09:15:00	AAPL	Stock	4.8789	4.8814	4.8757	4.8811	87332.0
2009-06-23 09:20:00	AAPL	Stock	4.8768	4.8775	4.8657	4.8714	268380.0
2009-06-23 09:25:00	AAPL	Stock	4.87	4.8921	4.8675	4.8707	1033900.0
2009-06-23 09:30:00	AAPL	Stock	4.8714	4.8911	4.8336	4.8732	24767288.0
2009-06-23 09:35:00	AAPL	Stock	4.8743	4.875	4.8221	4.8268	26608400.0
2009-06-23 09:40:00	AAPL	Stock	4.8264	4.8404	4.7675	4.775	34753852.0
2009-06-23 09:45:00	AAPL	Stock	4.7743	4.79	4.7575	4.7629	26460140.0
2009-06-23 09:50:00	AAPL	Stock	4.7625	4.7871	4.7518	4.7807	28707924.0
2009-06-23 09:55:00	AAPL	Stock	4.7811	4.7839	4.7564	4.7589	17814160.0
2009-06-23 10:00:00	AAPL	Stock	4.7579	4.7764	4.7457	4.7743	26078304.0
2009-06-23 10:05:00	AAPL	Stock	4.7754	4.7929	4.7664	4.7811	27778156.0
2009-06-23 10:10:00	AAPL	Stock	4.7815	4.7818	4.75	4.75	18041968.0
2009-06-23 10:15:00	AAPL	Stock	4.75	4.7896	4.7486	4.7871	14986468.0
2009-06-23 10:20:00	AAPL	Stock	4.7875	4.7911	4.7764	4.7814	12323836.0
2009-06-23 10:25:00	AAPL	Stock	4.7814	4.7854	4.7607	4.7618	12432224.0
2009-06-23 10:30:00	AAPL	Stock	4.7621	4.7911	4.7607	4.7911	12414192.0
2009-06-23 10:35:00	AAPL	Stock	4.7907	4.7957	4.7732	4.7739	12256272.0
2009-06-23 10:40:00	AAPL	Stock	4.7754	4.7754	4.7571	4.7657	10606344.0
2009-06-23 10:45:00	AAPL	Stock	4.7657	4.7743	4.7589	4.7614	9123716.0
2009-06-23 10:50:00	AAPL	Stock	4.7621	4.7643	4.7507	4.7593	10923360.0
2009-06-23 10:55:00	AAPL	Stock	4.7593	4.7718	4.7543	4.7689	9003316.0
2009-06-23 11:00:00	AAPL	Stock	4.7693	4.7707	4.7611	4.7629	4787664.0
2009-06-23 11:05:00	AAPL	Stock	4.7636	4.7639	4.7554	4.7554	5836880.0

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

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