PREVIEW / stock_5min / 2009-04-03

all stock 5-min files

  file:    by_date/stock_5min/2009/2009-04-03.parquet
  size:    4.4 MB
  rows:    304,960
  symbols: 3,331

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-04-03 06:35:00	AAPL	Stock	4.1032	4.1243	4.1032	4.1243	31752.0
2009-04-03 06:40:00	AAPL	Stock	4.1246	4.1246	4.1246	4.1246	2800.0
2009-04-03 07:00:00	AAPL	Stock	4.1079	4.1246	4.1079	4.1246	19320.0
2009-04-03 07:05:00	AAPL	Stock	4.1161	4.1196	4.1161	4.1196	55720.0
2009-04-03 07:10:00	AAPL	Stock	4.1157	4.1157	4.1157	4.1157	2800.0
2009-04-03 07:15:00	AAPL	Stock	4.1243	4.1243	4.1243	4.1243	8400.0
2009-04-03 07:20:00	AAPL	Stock	4.1161	4.1171	4.1161	4.1171	24192.0
2009-04-03 07:25:00	AAPL	Stock	4.1157	4.1268	4.1157	4.1268	47600.0
2009-04-03 07:35:00	AAPL	Stock	4.125	4.1382	4.125	4.1382	9800.0
2009-04-03 07:40:00	AAPL	Stock	4.125	4.125	4.125	4.125	40572.0
2009-04-03 07:45:00	AAPL	Stock	4.125	4.125	4.125	4.125	56000.0
2009-04-03 07:50:00	AAPL	Stock	4.1171	4.1171	4.1171	4.1171	2800.0
2009-04-03 07:55:00	AAPL	Stock	4.125	4.125	4.125	4.125	112000.0
2009-04-03 08:00:00	AAPL	Stock	4.1171	4.125	4.1171	4.1225	380100.0
2009-04-03 08:05:00	AAPL	Stock	4.125	4.125	4.1161	4.1186	120820.0
2009-04-03 08:10:00	AAPL	Stock	4.1157	4.1157	4.0	4.0918	211820.0
2009-04-03 08:15:00	AAPL	Stock	4.0982	4.1018	4.0946	4.1018	58100.0
2009-04-03 08:20:00	AAPL	Stock	4.0961	4.1071	4.0961	4.1036	17640.0
2009-04-03 08:25:00	AAPL	Stock	4.1071	4.1139	4.1036	4.1068	193984.0
2009-04-03 08:30:00	AAPL	Stock	4.1068	4.125	4.1068	4.1232	332920.0
2009-04-03 08:35:00	AAPL	Stock	4.1214	4.1246	4.1182	4.1182	160496.0
2009-04-03 08:40:00	AAPL	Stock	4.1171	4.1246	4.1161	4.1189	205660.0
2009-04-03 08:45:00	AAPL	Stock	4.1179	4.1196	4.1161	4.1161	137704.0
2009-04-03 08:50:00	AAPL	Stock	4.1161	4.1179	4.1011	4.1011	443184.0
2009-04-03 08:55:00	AAPL	Stock	4.1011	4.1011	4.0821	4.0871	258160.0
2009-04-03 09:00:00	AAPL	Stock	4.0871	4.0871	4.0632	4.0714	529900.0
2009-04-03 09:05:00	AAPL	Stock	4.0736	4.0768	4.0714	4.0714	206892.0
2009-04-03 09:10:00	AAPL	Stock	4.0786	4.0786	4.0643	4.0654	154588.0
2009-04-03 09:15:00	AAPL	Stock	4.0654	4.0732	4.0632	4.0707	164640.0
2009-04-03 09:20:00	AAPL	Stock	4.0714	4.0775	4.0714	4.075	74900.0
2009-04-03 09:25:00	AAPL	Stock	4.075	4.0982	4.0714	4.0825	514220.0
2009-04-03 09:30:00	AAPL	Stock	4.0825	4.0879	4.0546	4.0546	21360052.0
2009-04-03 09:35:00	AAPL	Stock	4.0552	4.0871	4.0543	4.0814	10798760.0
2009-04-03 09:40:00	AAPL	Stock	4.0821	4.1136	4.0793	4.1125	15786540.0
2009-04-03 09:45:00	AAPL	Stock	4.1118	4.1157	4.0943	4.0986	15853516.0
2009-04-03 09:50:00	AAPL	Stock	4.0989	4.0993	4.0771	4.0789	13791456.0
2009-04-03 09:55:00	AAPL	Stock	4.0789	4.1036	4.0779	4.0943	10922436.0
2009-04-03 10:00:00	AAPL	Stock	4.0925	4.0996	4.0725	4.0732	13288492.0
2009-04-03 10:05:00	AAPL	Stock	4.0725	4.0854	4.0679	4.0832	11697756.0
2009-04-03 10:10:00	AAPL	Stock	4.0826	4.0886	4.0793	4.0811	7508564.0
2009-04-03 10:15:00	AAPL	Stock	4.0829	4.0939	4.0729	4.09	9218048.0
2009-04-03 10:20:00	AAPL	Stock	4.0882	4.0979	4.0843	4.0944	7489608.0
2009-04-03 10:25:00	AAPL	Stock	4.0943	4.11	4.0929	4.1046	8981868.0
2009-04-03 10:30:00	AAPL	Stock	4.1054	4.1143	4.0918	4.0957	8531320.0
2009-04-03 10:35:00	AAPL	Stock	4.0957	4.1007	4.0868	4.0989	6572776.0
2009-04-03 10:40:00	AAPL	Stock	4.0982	4.105	4.0843	4.085	7240184.0
2009-04-03 10:45:00	AAPL	Stock	4.0846	4.0971	4.0846	4.0954	6042120.0
2009-04-03 10:50:00	AAPL	Stock	4.0954	4.1204	4.0954	4.1204	9111340.0
2009-04-03 10:55:00	AAPL	Stock	4.1207	4.1232	4.1086	4.1156	6710144.0
2009-04-03 11:00:00	AAPL	Stock	4.1157	4.1275	4.0696	4.1211	8823136.0

> showing 50 of 304,960 rows — these rows as CSV

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