PREVIEW / stock_5min / 2009-10-06

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-10-06.parquet
  size:    4.7 MB
  rows:    321,546
  symbols: 3,394

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-10-06 04:30:00	AAPL	Stock	6.6786	6.6786	6.6786	6.6786	11200.0
2009-10-06 05:05:00	AAPL	Stock	6.6786	6.6786	6.6786	6.6786	4200.0
2009-10-06 05:10:00	AAPL	Stock	6.6911	6.6911	6.6911	6.6911	5600.0
2009-10-06 06:25:00	AAPL	Stock	6.6875	6.6875	6.6875	6.6875	5600.0
2009-10-06 06:45:00	AAPL	Stock	6.6789	6.6789	6.6711	6.6786	33404.0
2009-10-06 06:55:00	AAPL	Stock	6.6786	6.6786	6.6786	6.6786	5404.0
2009-10-06 07:05:00	AAPL	Stock	6.6904	6.6904	6.6893	6.6893	11200.0
2009-10-06 07:10:00	AAPL	Stock	6.6918	6.6918	6.6725	6.6725	114800.0
2009-10-06 07:15:00	AAPL	Stock	6.6721	6.6732	6.6643	6.6643	30604.0
2009-10-06 07:25:00	AAPL	Stock	6.6714	6.6714	6.6714	6.6714	11200.0
2009-10-06 07:30:00	AAPL	Stock	6.6804	6.6804	6.6804	6.6804	8400.0
2009-10-06 07:35:00	AAPL	Stock	6.6804	6.6804	6.675	6.675	11200.0
2009-10-06 07:45:00	AAPL	Stock	6.6839	6.6839	6.6786	6.6786	44800.0
2009-10-06 07:50:00	AAPL	Stock	6.6821	6.6839	6.6821	6.6839	13300.0
2009-10-06 07:55:00	AAPL	Stock	6.6821	6.6871	6.6821	6.6871	11340.0
2009-10-06 08:00:00	AAPL	Stock	6.6875	6.6925	6.6786	6.6925	558180.0
2009-10-06 08:05:00	AAPL	Stock	6.6925	6.6964	6.6871	6.6896	382872.0
2009-10-06 08:10:00	AAPL	Stock	6.6893	6.7014	6.6893	6.6982	460404.0
2009-10-06 08:15:00	AAPL	Stock	6.6996	6.7039	6.6996	6.6996	174216.0
2009-10-06 08:20:00	AAPL	Stock	6.7	6.7043	6.7	6.7039	105000.0
2009-10-06 08:25:00	AAPL	Stock	6.7039	6.7107	6.7036	6.7107	413028.0
2009-10-06 08:30:00	AAPL	Stock	6.7071	6.7104	6.7057	6.7104	254100.0
2009-10-06 08:35:00	AAPL	Stock	6.7071	6.7111	6.7039	6.7079	296352.0
2009-10-06 08:40:00	AAPL	Stock	6.705	6.7104	6.7043	6.7082	231700.0
2009-10-06 08:45:00	AAPL	Stock	6.7079	6.7079	6.7057	6.7071	96180.0
2009-10-06 08:50:00	AAPL	Stock	6.7082	6.7082	6.705	6.705	156912.0
2009-10-06 08:55:00	AAPL	Stock	6.7054	6.7107	6.7054	6.7107	142828.0
2009-10-06 09:00:00	AAPL	Stock	6.7107	6.7118	6.7104	6.7114	176400.0
2009-10-06 09:05:00	AAPL	Stock	6.7118	6.7143	6.7104	6.7107	416360.0
2009-10-06 09:10:00	AAPL	Stock	6.7129	6.7154	6.7107	6.713	533484.0
2009-10-06 09:15:00	AAPL	Stock	6.7111	6.7111	6.7068	6.7086	140980.0
2009-10-06 09:20:00	AAPL	Stock	6.7093	6.7129	6.7057	6.7107	325220.0
2009-10-06 09:25:00	AAPL	Stock	6.7107	6.7125	6.7054	6.7054	549080.0
2009-10-06 09:30:00	AAPL	Stock	6.7054	6.7375	6.6988	6.7211	23345784.0
2009-10-06 09:35:00	AAPL	Stock	6.7211	6.7214	6.6893	6.7071	14902020.0
2009-10-06 09:40:00	AAPL	Stock	6.7061	6.7246	6.7054	6.7114	10738532.0
2009-10-06 09:45:00	AAPL	Stock	6.7114	6.7168	6.7039	6.7068	7280840.0
2009-10-06 09:50:00	AAPL	Stock	6.7061	6.7307	6.7054	6.7268	10712128.0
2009-10-06 09:55:00	AAPL	Stock	6.7268	6.7357	6.7161	6.7211	8456168.0
2009-10-06 10:00:00	AAPL	Stock	6.7214	6.7304	6.7186	6.7239	9546376.0
2009-10-06 10:05:00	AAPL	Stock	6.7232	6.7357	6.7232	6.7268	8604960.0
2009-10-06 10:10:00	AAPL	Stock	6.7271	6.7539	6.7271	6.7532	18009404.0
2009-10-06 10:15:00	AAPL	Stock	6.7529	6.7561	6.7471	6.7546	11683224.0
2009-10-06 10:20:00	AAPL	Stock	6.7546	6.7668	6.7539	6.7636	11282964.0
2009-10-06 10:25:00	AAPL	Stock	6.7632	6.765	6.7457	6.7479	8873060.0
2009-10-06 10:30:00	AAPL	Stock	6.7464	6.7532	6.7357	6.7386	7566972.0
2009-10-06 10:35:00	AAPL	Stock	6.7386	6.7564	6.7357	6.7514	6175736.0
2009-10-06 10:40:00	AAPL	Stock	6.7525	6.7568	6.7504	6.7539	4896444.0
2009-10-06 10:45:00	AAPL	Stock	6.7539	6.7611	6.7504	6.7546	7372736.0
2009-10-06 10:50:00	AAPL	Stock	6.7543	6.7561	6.75	6.7561	3597356.0

> showing 50 of 321,546 rows — these rows as CSV

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